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. I am using Athena Pyspark notebooks that I would like to schedule for weekly automated runs. Is there a way to use Step Function Workflow Jobs to do this? In the documentation, it only mentions...
1
answers
0
votes
371
views
asked 8 months agolg...
My Glue 4.0 jobs have suddenly stopped working with error message below. As it is related to boto3, I am unable to make any changes to library config. Pls advise.
NB: I noticed that urllib3 released...
0
answers
0
votes
100
views
asked 8 months agolg...
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
361
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
281
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
263
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
276
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
514
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
1495
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
541
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
296
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
130
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
313
views
asked 8 months agolg...