Questions tagged with Amazon Athena
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Glue to Athena Errorlg...
HIVE_UNKNOWN_ERROR: java.net.URISyntaxException: Relative path in absolute URI: arn:aws:dynamodb:{Account}:table/{Table}
This query ran against the "{Created Athena Database}" database, unless...
1
answers
0
votes
191
views
asked 6 months agolg...
I have a Glue table created from schema in Glue schema registry that is in JSON draft 07 format.
I tried setting up a Firehose that converts incoming JSON data into Parquet as it saves it into S3,...
0
answers
0
votes
190
views
asked 6 months agolg...
Hello, we have a simple table with a few string columns and a few timestamp columns.
Recently we've noticed that any query performed on this table which has a WHERE clause, from the simplest to the...
Accepted AnswerAmazon Athena
4
answers
10
votes
673
views
asked 6 months agolg...
Athena Query Id: 48b0a8cc-13ce-4c90-8295-c69c682e7f11
When doing a SELECT statement for a table it returns an INTERNAL_ERROR_QUERY_ENGINE error when we have a lot of `AND ((attr1 = 'value' AND attr2...
0
answers
0
votes
167
views
asked 6 months agolg...
In Athena I've a column with an array(json), is there a way to calculate the length of that array for every row?
Accepted AnswerAmazon Athena
2
answers
0
votes
1015
views
asked 6 months agolg...
how to fix issue with AWS crawler that split comma listed values which is supposed to be one column. The data in the column is not enclosed by double quotes that is why we cannot create a custom...
1
answers
0
votes
357
views
asked 6 months agolg...
If I want to extract specific properties from a JSON array using SQL, for example, if the requestparameters structure is as follows:
```
{
'gree': [
{
'Grantee': {
'xsi:type':...
0
answers
0
votes
86
views
asked 6 months agolg...
I have a set of Apache Iceberg tables that are logged in Glue Catalog. I was running some basic tests on Iceberg table partitions via Athena in us-east-1 without issue. We re-deployed the exact same...
1
answers
0
votes
650
views
asked 6 months agolg...
I was trying to update the CID Dashboards to display account names as per this doc(https://catalog.workshops.aws/awscid/en-US/dashboards/foundational/cudos-cid-kpi/add-accounts) . When I run the query...
1
answers
0
votes
360
views
asked 6 months agolg...
I have ran this query for more than a year, and the query always succeed until now.
This is the Athena Query: "select * from <table_name> where organization = '<org_name>' AND start >= <epoch_time>...
1
answers
0
votes
878
views
asked 6 months agolg...
'DeleteObjects''s requestparameters is like '{"bucketName":"demo-bucket","Host":"s3.us-east-2.amazonaws.com","delete":""}' , how can i get deleted ObjectKey
3
answers
0
votes
248
views
asked 6 months agolg...
this is my sql, but 'json_extract_scalar(requestparameters, '$.x-amz-copy-source') as source' is error,
SELECT
userIdentity.username as...
Accepted AnswerAmazon Athena
4
answers
0
votes
211
views
asked 6 months agolg...