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.
I am running query in athena engine 3.0 and getting the error
**[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE]** Amazon Athena experienced an internal error while executing this query.
Query is like :
/*...
1
answers
0
votes
252
views
asked 6 months agolg...
Hi,
The following CTAS query fails with Col not found error.
```
CREATE table <table_name>
with(
format='PARQUET'
, write_compression='SNAPPY'
, partitioned_by=ARRAY["yearMonth"]
, external_location...
1
answers
0
votes
251
views
asked 6 months agolg...
I have a glue table specified that refers to a location in S3. I noticed that when Firehose puts data there in parquet format it might be not always compressed.
Will it cause issues for Glue table,...
1
answers
0
votes
281
views
asked 6 months agolg...
Hello,
Is there a DQ rule that can identify empty or null columns? Or is there an sql query that can identify empty columns?
thanks.
1
answers
0
votes
258
views
asked 6 months agolg...
1. I am trying to understand how to estimate the end result of pricing for Glue crawlers for data being ingested by AWS Kinesis Firehose service with the max possible buffer setting while glue...
0
answers
0
votes
169
views
asked 6 months agolg...
We are getting this error when trying to do select query in Athena.
This query ran against the "application_discovery_service_database" database, unless qualified by the query.
1
answers
0
votes
405
views
asked 6 months agolg...
I have an athena query that runs in around 3 secs both from console and even is called using pyathena. I have added the query execution into a step function as I need to perform some pre and post...
0
answers
0
votes
138
views
asked 6 months agolg...
Glue to Athena Errorlg...
HIVE_UNKNOWN_ERROR: java.net.URISyntaxException: Relative path in absolute URI: arn:aws:dynamodb:{Account}:table/{Table}
This query ran against the "{Created Athena Database}" database, unless...
1
answers
0
votes
190
views
asked 6 months agolg...
I have a Glue table created from schema in Glue schema registry that is in JSON draft 07 format.
I tried setting up a Firehose that converts incoming JSON data into Parquet as it saves it into S3,...
0
answers
0
votes
190
views
asked 6 months agolg...
Hello, we have a simple table with a few string columns and a few timestamp columns.
Recently we've noticed that any query performed on this table which has a WHERE clause, from the simplest to the...
Accepted AnswerAmazon Athena
4
answers
10
votes
667
views
asked 6 months agolg...
Athena Query Id: 48b0a8cc-13ce-4c90-8295-c69c682e7f11
When doing a SELECT statement for a table it returns an INTERNAL_ERROR_QUERY_ENGINE error when we have a lot of `AND ((attr1 = 'value' AND attr2...
0
answers
0
votes
167
views
asked 6 months agolg...
In Athena I've a column with an array(json), is there a way to calculate the length of that array for every row?
Accepted AnswerAmazon Athena
2
answers
0
votes
996
views
asked 6 months agolg...