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.
Athena engine version 3 fail create table query, but on version 2 works good.
Error : "pyathena.error.OperationalError: Amazon Athena experienced an internal error while executing this query. Please...
0
answers
0
votes
328
views
asked a year agolg...
I've been trying to read some zstd data in Athena. The files are multi-frame, which is a feature that ZSTD format fully supports. In fact, a multi-frame file is simply a file created by concatenating...
0
answers
0
votes
51
views
asked a year agolg...
I have parquet file with milliseconds field (example 1686900160123)
When I create external table in Athena engine 2 it seems correctly for S3 parquet files
But In Athena engine 3 all fields have value...
0
answers
1
votes
135
views
asked a year agolg...
Get data from S3 bucket through Athena using GraphQL API without using AWS AppSync!
I have a react application in which i have to load the S3 file in a table, I am planning to use Athena to query the...
0
answers
0
votes
106
views
asked a year agolg...
`SYNTAX_ERROR: line 2:6: Schema ardl_common_prodna does not exist`
This query ran against the "" database, unless qualified by the query. Please post the error message on our forum or contact...
0
answers
0
votes
129
views
asked a year agolg...
Running any query in Athena on a particular table "sometable" fails after ~15 seconds eg:
```
SELECT * FROM "somedatabase"."sometable" limit 10;
```
And returns this error message...
0
answers
0
votes
83
views
asked a year agolg...
I don't understand why this error. I didn't declare customer id column as string. Does not make sense;
ERROR: HIVE_BAD_DATA: Error reading field value: Cannot convert value FAILED: Execution Error...
0
answers
0
votes
124
views
asked a year agolg...
When I execute the following:
alter table <db_name>.<table_name> drop column <column_name>
The column name remains in the Glue catalog. We're using Athena v3 engine. I also used the following to...
0
answers
1
votes
202
views
asked a year agolg...
We are trying to query a hudi table stored in s3 and cataloged in glue using Athena. The table has around 400 partitions (based on date) and is of size 120 MB (5.5M records). We have used the configs:...
0
answers
0
votes
86
views
asked a year agolg...
We are interested in using the Athena CloudWatch connector to query log statements that can potentially contain personal data. For this we wonder if there is any cross-region data transfer going on...
0
answers
0
votes
100
views
asked a year agolg...
[ErrorCategory:USER_ERROR, ErrorCode:DDL_FAILED], Detail:FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
This query ran against the "license_usage" database, unless...
0
answers
0
votes
159
views
asked a year agolg...
Hey all! I want to use AWS Quicksight to show the values over time of a data set I have in S3 data lake. It looks like this:
![Data...
0
answers
0
votes
106
views
asked a year agolg...