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.
The query is working on 1 table with a CSV source file. After adding 2 more columns to the same file it is giving me an error for the normal select query.
**HIVE_BAD_DATA: Error reading field value:...
0
answers
0
votes
227
views
asked 9 months agolg...
I have two tables in Athena, both have the same schema (user_id - a string, items - an array of ASINs). One table records users in Week 1 and the other one in Week 2. Some users in both tables share...
0
answers
0
votes
42
views
asked 9 months agolg...
Is it possible for Athena to `UNLOAD` the results, and retain the key names?
This seems to be really inconsistent.
When I do not use UNLOAD, and use the default Athena -> S3 as CSV output, then the...
0
answers
0
votes
68
views
asked 10 months agolg...
When Glue table is created in CDK V2, AWS Athena can not SHOW CREATE TABLE over it.
`[ErrorCategory:USER_ERROR, ErrorCode:DDL_FAILED], Detail:FAILED: Execution Error, return code 1 from...
0
answers
0
votes
87
views
asked 10 months agolg...
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
325
views
asked 10 months 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 10 months 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
132
views
asked 10 months 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
102
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
123
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
82
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
120
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
194
views
asked a year agolg...