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.
Hello, I have a query that ran in 1 min 20 sec
When I click on the execution details in the query stats page, I am able to see the execution plan and the runtime for each stage. However, it is...
0
answers
0
votes
18
views
asked 9 months agolg...
when i click on preview table in athena its working fine. but iam getting error when i make any change in the query like SELECT count(*) FROM "project"."enigma_jhud"; Please help...
0
answers
0
votes
107
views
asked 9 months agolg...
Hi
* Is there a way in Athena to join queries from 2 different data sources AWSDataCatelog & a postgres connector?
* I am experiencing following error when during "select COUNT(*) from <table>" but...
0
answers
0
votes
105
views
asked 9 months agolg...
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...