Unanswered 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.
Error - "SYNTAX_ERROR: line 5:14: Invalid reference to output projection attribute from ORDER BY aggregation"
I have connected athena to quicksight. Since, quicksight doesn't show count beyond 99 in a...
0
answers
0
votes
260
views
asked 2 years agolg...
I am new to AWS and exploring Athena for querying S3 objects. I am using AWS Glue Crawler for data catalog.
I have successfully created table using Crawler for my JSON files available on the S3...
0
answers
0
votes
122
views
asked 2 years agolg...
Not really a question, really -- more of a bug report, but I can't find a better channel for this.
It looks like the AthenaJDBC42-2.0.30.1001.jar contains a set of Apache Commons dependency classes...
0
answers
0
votes
89
views
asked 2 years agolg...
I have a parquet file from which amongst all the columns of data, I have one shown as BigDecimal, which is a format that is not included in AWS. I would like to format it as `decimal(38,18)`, but it...
0
answers
0
votes
86
views
asked 2 years agolg...
I encountered this error when trying to update a record in the Iceberg table by Athena:
"GENERIC_INTERNAL_ERROR: Fail to commit without transaction conflict"
The Iceberg V2 table is created by Spark...
0
answers
0
votes
262
views
asked 2 years agolg...
Athena: Reference left-hand row in right-hand subquery? (correlated subquery, CROSS JOIN LATERAL)lg...
I have a usecase where I need to support recursive relationship fetching, with a possible LIMIT clause on each depth of relationship.
Something like:
```sql
SELECT ... FROM artists LIMIT 5
for...
0
answers
0
votes
70
views
asked 2 years agolg...
I have some CSV data that have an array of strings. For example, I want to extract two columns:
```
USGLS,"['MXMAR', 'BZBZE', 'MXCZM']",TEST
```
Unfortunately, the Glue CSV crawler (after executing...
0
answers
0
votes
89
views
asked 2 years agolg...
HI , I have data in delta format in s3 ,
created external table with following query .
>CREATE EXTERNAL TABLE delta_mongo.transactions
> ( `_id` string ,
>account_id bigint,
>bucket_end_date...
0
answers
0
votes
149
views
asked 2 years agolg...
SYNTAX_ERROR: line 1:8: SELECT * not allowed from relation that has no columns
I got the above error while trying to preview my created table created with AWS Glue Crawler. The file is my test data...
0
answers
0
votes
172
views
asked 2 years agolg...
Has someone received this error message in Athena before. If yes, could you please help me understand the possible solutions:
Number of stages in the query (1595) exceeds the allowed maximum (1500)....
0
answers
0
votes
108
views
asked 2 years agolg...
I have some event logs stored as Ion data in S3, and I am trying to query it using Amazon Athena's Ion Hive SerDe. One of the datafields that is in most of our events is typically an int, but in a few...
0
answers
0
votes
120
views
asked 2 years agolg...
Hi,
I have been trying to implement a monitoring solution to monitor the resources for AWS accounts in the organizations with AWS config, AWS Athena and Quicksight. I have set up all the services...
0
answers
0
votes
298
views
asked 2 years agolg...