All Content tagged with Amazon Athena

I am using Athena UNLOAD query to unload results of SELECT in parquet format. I have columns in snake_case in Athena Table. So I did SELECT snake_case as snakeCase .. in my query. The problem is I...

I previously had csv files with some columns and data and I replaced one column with two new columns. When I run crawler and try to view on Athena, it throws this error: HIVE_INVALID_METADATA: Hive...

Hi everyone, I am trying to set up cross account access for Glue catalog, I am using a customer-managed key in Glue and also set s3 encryption type to SSE-KMS and re-encrypt all current object.. my...

Hi, I am trying to set up the cross account access for Glue catalog. I want to have access to the data located in producer account inside consumer account's Athena. after setting up the access and run...

Hi, We're working on ICEBERG table and using MERGE INTO statement. We would like to implement the following logic: 1. In case there is match between some fields in source table on top of target table...

Hi, I'd like to raise an issue with the Athena JDBC driver developers - is there a bug tracker somewhere I can log that in? thanks

Hi, I wanted to know what will be the cost to execute. MSCK REPAIR TABLE tablename Also if there is any other way to refresh / load partitions to athena table which is better than *MSCK REPAIR *...

Hi, the Glue catalog cross-account needs customer-managed keys. when we create a new KMS key, change the KMS key in the Glue catalog setting, and run crawlers, it does not mean to encrypt existing...

Hi I'm trying to read avro files in Athena, the workflow is from DynamoDB to Kinesis then to Firehose, converting the format to AVRO in firehose using a lambda and configuring the compression within...

Hello everyone, Is it possible to request a quota increase for the number of Athena workgroups, as my solution can scale and get more than 1000 customers. Thank you in advance Kind Regards, N.E

I'm using [Athena JDBC driver 3.2](https://docs.aws.amazon.com/athena/latest/ug/jdbc-v3-driver.html) (uberjar) to execute queries in clojure. Queries that I execute produce expected results, but also...

I am trying to use the DATEADD function, but I encountered an issue. I am querying an S3 database using Athena. Do I need to store the data in Redshift to use the DATEADD function? Any guidance would...