All Content tagged with Amazon Athena
Start querying data instantly. Get results in seconds. Pay only for the queries you run.
Content language: English
Select up to 5 tags to filter
Sort by most recent
1116 results
Hi team,
Getting this error while runninng query in athena
com.amazonaws.services.s3.model.AmazonS3Exception: Access Denied (Service: Amazon S3; Status Code: 403; Error Code: AccessDenied; Request...
I already setup AWS SQLServerLambdaConnector connect with SQL Server on-premise
- I access my sqlserver database on-prem and do some sql queries:
create database antsomi;
go
use antsomi;
go
CREATE...
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...