All Content tagged with Amazon Athena

On AWS Athena, query csv data then get error as below even though just `select * from table` ``` HIVE_BAD_DATA: Error Parsing a column in the table: Cannot convert value of type String to a REAL...

- I have MS SQL server running on-prem and I want to take from MS Sql Server somehow get to Athena to query data. When I find data source for MS SQL Server, it needs connection with Lambda. So after...

I am new to Athena, and referred [this page](https://docs.aws.amazon.com/athena/latest/ug/connectors-docdb.html) to create Document DB connector. **Background**: I had to create the lambda manually ...

* Setup like this is done: https://aws.amazon.com/blogs/big-data/bring-your-workforce-identity-to-amazon-emr-studio-and-athena/ * S3 Access point created * Bucket Policy to allow access via AP given *...

Trying to have a Glue Crawler/Athena automatically pick up a timestamp format of `yyyy-MM-dd'T'HH:mm:ss.SSS'Z'`. I have confirmed all the values in my dataset are formatted as this format, example:...

Hi everyone! I’ve been following this guide (https://aws.amazon.com/blogs/aws/simplify-custom-contact-center-insights-with-amazon-connect-analytics-data-lake/) to gather data from Amazon Connect and...

We have loved the flexibility of the Athena engine, but are starting to get concerned about its instability. Recently we've identified needs to rerun major queries that return zero records the first...

Hi, I am creating a table by `UNION ALL` 6 views with same schema. However, I am getting `INTERNAL_ERROR_QUERY_ENGINE` when executing the query. I tried to run just the `SELECT` parts without the...

Athena runs all queries in a [shared regional cluster](https://athena.guide/articles/athena-basics-running-queries). When you submit a query, the Athena engine query planner estimates the compute...

I am experiencing timeout for my athena queries since yesterday. Sharing couple of queries here: Query 1: (ID:b4e3438a-2dce-4884-87f6-7e93f375ee86 ) Query 2: (ID: a8bc9d3b-f55c-4c61-ba66-d6bbe4f4a64f...

We need help to get the data of shut down instances in all regions from the past 90 days on all member accounts from Management (root) account using Athena. We have a sample script but the script...

Dear members of the AWS community, I have been facing an issue for the past couple of days trying to setup AWS Managed Grafana workspace with Athena workgroup. The underlying reason why I want to do...