Unanswered Questions tagged with Amazon Athena
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
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...
0
answers
0
votes
134
views
asked 9 months agolg...
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...
0
answers
0
votes
102
views
asked 9 months agolg...
DataSource.Error: ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWSlg...
Hi all,
I am using the Power BI AWS Athena Connector with Simba Athena ODBC driver to import data in Power BI Desktop.
At this stage, I have connected to the data source with the following...
0
answers
0
votes
111
views
asked 10 months agolg...
Using Athena on an s3 bucket that's been crawled and get the error:
class org.apache.parquet.io.GroupColumnIO cannot be cast to class org.apache.parquet.io.PrimitiveColumnIO
I've narrowed down the...
0
answers
0
votes
83
views
asked 10 months agolg...
We have our data stored in S3, and for analytical tasks, we're utilizing Athena to query this data. Our visualization is done through Power BI. However, we're encountering an issue when Power BI sends...
0
answers
0
votes
85
views
asked 10 months agolg...
I've got Athena setup to query a DocumentDB instance with the Lambda function built and AWS Glue configured. The setup was done through the datasource connector for DocumentDB.
I can see the database...
0
answers
0
votes
191
views
asked 10 months agolg...
Hello, I have a query that ran in 1 min 20 sec
When I click on the execution details in the query stats page, I am able to see the execution plan and the runtime for each stage. However, it is...
0
answers
0
votes
21
views
asked 10 months agolg...
when i click on preview table in athena its working fine. but iam getting error when i make any change in the query like SELECT count(*) FROM "project"."enigma_jhud"; Please help...
0
answers
0
votes
124
views
asked a year agolg...
Hi
* Is there a way in Athena to join queries from 2 different data sources AWSDataCatelog & a postgres connector?
* I am experiencing following error when during "select COUNT(*) from <table>" but...
0
answers
0
votes
133
views
asked a year agolg...
The query is working on 1 table with a CSV source file. After adding 2 more columns to the same file it is giving me an error for the normal select query.
**HIVE_BAD_DATA: Error reading field value:...
0
answers
0
votes
256
views
asked a year agolg...
I have two tables in Athena, both have the same schema (user_id - a string, items - an array of ASINs). One table records users in Week 1 and the other one in Week 2. Some users in both tables share...
0
answers
0
votes
49
views
asked a year agolg...
Is it possible for Athena to `UNLOAD` the results, and retain the key names?
This seems to be really inconsistent.
When I do not use UNLOAD, and use the default Athena -> S3 as CSV output, then the...
0
answers
0
votes
76
views
asked a year agolg...