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.
We have our data stored in S3, and for analytical tasks, we're utilizing Athena to query this data. Our visualization is done through Power BI. However, we're encountering an issue when Power BI sends...
0
answers
0
votes
81
views
asked 9 months agolg...
I've got Athena setup to query a DocumentDB instance with the Lambda function built and AWS Glue configured. The setup was done through the datasource connector for DocumentDB.
I can see the database...
0
answers
0
votes
182
views
asked 9 months agolg...
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
19
views
asked 10 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
118
views
asked 10 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
126
views
asked 10 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
249
views
asked 10 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
46
views
asked 10 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
72
views
asked a year 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
99
views
asked a year 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
334
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
137
views
asked a year agolg...