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, due to the following Step by Step Guide provided by the official AWS Athena user-guide (Link at the End of the question), it should be possible to connect Tableau Desktop to Athena and Lake...
0
answers
0
votes
331
views
asked 2 years agolg...
**Background**
We've configured an export to s3 from dynamodb using the native dynamodb s3 export, and ION as the format output.
After this, we've created a table in Athena
```
CREATE EXTERNAL...
0
answers
0
votes
132
views
asked 2 years agolg...
Here is the error I am getting while loading partition to table and data is not getting push to table automatically but it is getting push to S3 Agent Event bucket.
This query ran against the...
0
answers
0
votes
135
views
asked 2 years agolg...
Hi,
I found out this weird bug in Athena when showing table partitions using Athena engine version 2.
When retrieving the most recent partition for a table, I can easily create this simple query...
0
answers
1
votes
317
views
asked 2 years agolg...
When I try to run the following query via the Athena JDBC Driver
```sql
describe gitlab.issues
```
I get the following error:
> [Simba][AthenaJDBC](100071) An error has been thrown from the AWS...
0
answers
0
votes
310
views
asked 2 years agolg...
Hello,
I am trying to query some files stored in s3. The files are stored in binary Amazon Ion format and have gzip compression.
When attempting to preview my table:
"SELECT * FROM...
0
answers
0
votes
86
views
asked 2 years agolg...
I am getting this error:
```
Failed to update Prepared Statement (Prepared Statement name) in Workgroup primary. (Service: AmazonAthena; Status Code: 400; Error Code: InvalidRequestException;
```
Can...
0
answers
0
votes
91
views
asked 2 years agolg...
I have a Glue ETL job which creates partitions during the job
```
additionalOptions = {"enableUpdateCatalog": True, "updateBehavior": "LOG"}
additionalOptions["partitionKeys"] = ["year",...
0
answers
0
votes
117
views
asked 2 years agolg...
Hello.
I'm trying to create an analysis from my DocumentDB instance. I'm using the aws services Glue, Athena and Quicksight.
In Glue I have created a connection to the DocumentDB and a crawler for...
0
answers
0
votes
331
views
asked 2 years agolg...
I created a Data Catalog with a table that I manually defined.
I run my ETL job and all works well.
I added partitions to both the table in the Data Catalog, as well as the ETL job. it creates the...
0
answers
0
votes
277
views
asked 2 years agolg...
There seems to be a bug in Athena:
If you create an Iceberg table, insert some data, delete the S3 folder, then try to DROP the table, you will get this error:
>
DDL execution timed out.
Example...
0
answers
0
votes
161
views
asked 2 years agolg...
I followed the instructions from https://docs.aws.amazon.com/athena/latest/ug/connect-to-a-data-source-lambda.html to set up the connection between Athena and snowflake. However I'm getting an error...
0
answers
0
votes
60
views
asked 2 years agolg...