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.
Hi all,
We are having two queries fail on Athena. Here's a message that was in the Query Results section. Please let me know what additional information you need from me to resolve the issues....
1
answers
1
votes
369
views
asked 8 months agolg...
I have converted a json format file in parquet, I can see the parquet file and the columns, but while querying with Athena getting error.
HIVE_UNKNOWN_ERROR: Path is not absolute:...
1
answers
0
votes
288
views
asked 8 months agolg...
![Enter image description here](/media/postImages/original/IMSoAO_86HTGGJ_gtDX5SZEA)
Here is an example of the issue I'm experiencing with rounding in Athena. The first column has a datatype of...
1
answers
0
votes
282
views
asked 8 months agolg...
Consistently getting [ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] after adding a new UNION to a viewlg...
Hello,
I'm trying to run a view that is made of 3 UNIONs (so four SELECT statements in total). I noticed that after adding the last UNION SELECT statement, the view no longer runs and I get the...
Accepted AnswerAmazon Athena
1
answers
0
votes
281
views
asked 8 months agolg...
Hello everyone,
### 1. Context
We have a Delta Lake where we write our tables in **S3** in **Delta format**, and we use the **Glue Catalog** for queries in **Athena**. Tables are created both with...
1
answers
1
votes
678
views
asked 8 months agolg...
When I try to run the following query in Athena:
`ALTER TABLE my_iceberg_table ALTER COLUMN old_column_name TO new_column_name`
I get the following error:
`line 1:37: missing 'TO' at...
2
answers
0
votes
1551
views
asked 8 months agolg...
Query:
```sql
SELECT *
FROM delta_prod.behavioral_logs
LIMIT 10
```
This query fails with
```
Amazon Athena experienced an internal error while executing this query. Please try submitting the query...
9
answers
0
votes
557
views
asked 8 months agolg...
HIVE_CANNOT_OPEN_SPLIT: Error opening Hive split s3://si-dag-uploads/si-demo/fact_pipeline_workflow_step_instances/dt=2023-08-24/fact_pipeline_workflow_step_instances_0011_part_13.parquet...
2
answers
0
votes
303
views
asked 8 months agolg...
Hi,
We are currently investigating the use of the Timestream Athena connector (https://docs.aws.amazon.com/athena/latest/ug/connectors-timestream.html) as a way of enabling our data teams to work...
0
answers
0
votes
132
views
asked 8 months agolg...
HI , when im using athena udf , im not able to read functions arguments in lambda function, getting key error while extracting from event .
Here is my athena function sql :
**USING EXTERNAL FUNCTION...
1
answers
0
votes
323
views
asked 8 months agolg...
athena query errorlg...
Hi Team,
When iam run querry facing error, Kindly support anyone please
SELECT * not allowed from relation that has no columns
This query ran against the "penguin-landing-data" database, unless...
Accepted AnswerAmazon Athena
1
answers
0
votes
337
views
asked 9 months agolg...
Glue table recreation causes GENERIC_INTERNAL_ERROR: io.trino.spi.block.VariableWidthBlockBuilderlg...
It seems like there is an issue with the management of glue tables under the hood?
We have data pipelines that have recently started failing on all our raw glue tables, where downstream tables...
1
answers
1
votes
273
views
asked 9 months agolg...