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.
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...
1
answers
0
votes
43
views
asked 12 hours 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...
1
answers
0
votes
47
views
asked a day 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...
1
answers
0
votes
34
views
asked 2 days 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
42
views
asked 3 days 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
49
views
asked 3 days 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
57
views
asked 4 days 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
80
views
asked 7 days agolg...
Hi,
I'have deployed dashboards and trying to mapping account id with names. I'm following this...
1
answers
0
votes
42
views
asked 8 days agolg...
I'm following the Well Architected Lab religiously: https://www.wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/
When trying the create the CUDOS dashboards...
1
answers
0
votes
27
views
asked 9 days agolg...
I am working on a view in Athena, which requires being able to do the following, identify the time of each work experience, using the number of months, days and count how many jobs you have had in...
1
answers
0
votes
71
views
asked 9 days agolg...
I want to disable the 'Copy' button in Athena for an IAM role.
The Download permission is already denied for this role using 'aws:calledViaLast' condition. But the user can still copy data using the...
Accepted AnswerAmazon Athena
1
answers
0
votes
61
views
asked 9 days agolg...
I am testing a Glue data source for Athena has been configured to point to the catalog ID of the same account (i.e. in AccountA I have "Data-Lake" that points to catalog id: AccountA).
When querying...
0
answers
0
votes
73
views
asked 12 days agolg...