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.
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
78
views
asked 9 months agolg...
Hello team,
I am trying to generate dataset from Athena. After I selected desired table and use Custom SQL to query data, I faced error as shown below.
![Custom SQL...
1
answers
0
votes
307
views
asked 9 months agolg...
Hi there,
I need help,
We are loading tables from glue data catalogs into a Redshift Serverless with 8 RPUs.
All works ok with small tables, but when we try with a 1.5 million records tables (like 300...
1
answers
0
votes
427
views
asked 9 months agolg...
Hello,
I've setup Athena to query my PostgreSQL database and it works fine. My question is whether it leverages the existing indexes in my tables for improved performance?
2
answers
1
votes
245
views
asked 9 months agolg...
I was trying to create table from select query - in iceberg. I was not able to. Can we use CTAS in icebeg tables? - if yes, how?
Accepted AnswerAmazon Athena
1
answers
0
votes
348
views
asked 9 months agolg...
Hi.
I have created the parquet file from the ETL visual tool using S3 source (CSV) to S3 target (Parquet) with partition key(date). When I created the Athena table from S3 source using parquet...
1
answers
1
votes
1901
views
asked 9 months agolg...
Schema was not updated after the glue job run by following the code in this page:
https://docs.aws.amazon.com/glue/latest/dg/update-from-job.html
In the "Updating table schema" sesssion, it...
1
answers
0
votes
1127
views
asked 9 months agolg...
Hello,
I followed [this guide](https://docs.aws.amazon.com/athena/latest/ug/connectors-opensearch.html) to setup a connector between OpenSearch and Athena. But I cannot seem to be able to read...
1
answers
0
votes
319
views
asked 9 months agolg...
![](/media/postImages/original/IMCQFfKY9FSimDqokftjJLHA)
even a simple query takes forever. It does not even show the data scan amount.
Could you please check if athena is down for the moment?
1
answers
0
votes
158
views
asked 9 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
81
views
asked 9 months agolg...
Hello!
I wondered is there a way to have control over the crawled glue tables names instead of the folder name?
For example, I have a bucket called org-team-users-data
then I use a glue crawler on...
1
answers
0
votes
471
views
asked 9 months agolg...
Hi we are getting the following error "Handling TYPE_NOT_FOUND: Unknown type: row" when running a simple select query against a table in our Athena DB. The source is from DocumentDB
![Enter image...
1
answers
0
votes
545
views
asked 9 months agolg...