All Content tagged with Amazon Athena

I am trying to extract current month data from database which is having 3 months data getting following error: HIVE_CANNOT_OPEN_SPLIT: Error opening Hive split SELECT fc, pl, bucket, scheduled_...

TYPE_MISMATCH: line 3:32: Cannot apply operator: date < varchar(10) This query ran against the "alchemy_cdn_cloudfront_logs_db" database, unless qualified by the query. Please post the error message o...

In my organization we have deployed the cost intelligence dashboard ( which works like a peach kudos ). I have some trouble though with understanding how it exactly works and more specifically the par...

I'm trying to query Athena using cross-account access from ECS and getting the following error: > Insufficient permissions to execute the query. User: arn:aws:sts::123456:assumed-role/foo-athena/foo-...

Hi, I have set up an Athena MySQL connector for federated queries to RDS. For some reason an extra column not present in my RDS table is added called "partition_name" all values set to "*". I have no...

hello. i have a question. cant we use the awsdatacatalog database (external table in glue data catalog) in redshift + amazon q(generative sql)? is this disabled? if can, is there any guidelines to use...

Good afternoon, I'm currently working within S3, Athena, and Glue, and I've run into a problem when uploading new data into S3. Whenever I upload new data into S3 manually, there's a mismatch in how ...

Hi, having troubles querying Iceberg history table using PySpark from AWS Glue 4.0, *same queries working in the Athena web query editor*. **The query that failing:** ``` def get_last_snapshot_id_by_...

How to partition data so that I can query with Athena without scanning the full bucket ? I like cost saving details and how to create partitions ? I dont have prefixes or any folders.

we have a daily glue job to get athena results to s3, the job has been working and today's run we got an error, the same query works in Athena UI Glue error: id: <redacted> Error Category: UNCLASSIF...

I have a huge Athena query with a CASE statement with approx. 700 WHEN clause, this query is failing with the error : **[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal...

Hi, I’m trying to run a query on Athena, but I started getting the following error: [ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error while executing this query. P...