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.
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
134
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
313
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
307
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
90
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
116
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
329
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
275
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
159
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
59
views
asked 2 years agolg...
I'm having trouble creating iceberg tables in Athena. I keep getting "Invalid S3 request" as an error message.
```
CREATE TABLE iceberg_test (
event_date timestamp,
log...
0
answers
0
votes
164
views
asked 2 years agolg...
Imagine if we have a time series values like this, lets say the timestamps are in epoch and device is emitting a payload every minute.
|timestamp| device| sensorName|...
0
answers
0
votes
167
views
asked 2 years agolg...