Questions tagged with Amazon Athena

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...

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...

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...

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...

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...

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...

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...

Hi, I'have deployed dashboards and trying to mapping account id with names. I'm following this...

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...

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...

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...

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...