Questions tagged with Amazon Athena
Start querying data instantly. Get results in seconds. Pay only for the queries you run.
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.
1047 results
we have a daily glue job to get athena results to s3, the job has been working and today's run we got an error, the same query works in Athena UI
Glue error:
id:...
I have a huge Athena query with a CASE statement with approx. 700 WHEN clause, this query is failing with the error :
**[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal...
Hi,
I’m trying to run a query on Athena, but I started getting the following error:
[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE]
Amazon Athena experienced an internal error while executing this query....
I am trying to create a View with the column Average Day(s) Between Orders for each name_detail but I'm continously get following error:
![Athena Query...
In Athena, when using the `unload` command to output text files to an s3 location such as:
` UNLOAD (SELECT * FROM some_view)
TO 's3://results_folder/some_run/'
WITH (
format =...
1. I am trying to create data catalog table in AWS glue which has different cols and their datatypes (varchar,date,timestamp). and the respective values are stored in CSV format in S3.
But while...
I need to get information like file name, file size, file type from hierarchical S3 folder structure which is organized like business/sub_business/date/files_with_name_of_originator . I need to get...
Hello,
I’m seeking guidance and suggestions on cost-effective methods for scanning a couple of DynamoDB tables, each with sizes of up to 3 TB and 5 TB.
Our goal is to join these tables based on...
I created a table for query AWS SES event logs on Athena and turn on partition projection for date.
```
TBLPROPERTIES (
'projection.enabled'='true',
'projection.date.type'='date',
...
Hello Team,
Background:
Recently I was working for AWS billing automation for our organization account.
1. Initially, I tried Cost explorer API method - No AWS Data Transfer cost in the service...
Hi folks,
I have a partitioned table in Athena that uses dynamic partition projection, enabled with the following table properties:
```
projection.account.type injected
projection.region.type ...
I have created a dynamodb table that stores some data, then created a glue crawler that crawls to store the metadata of this table so I can query it using Athena. I am seeing the dynamodb table got...