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 Team,
I have requirement to access S3 bucket which exists in AWS account (say Account A) from Account B using Athena. I had done following setup for this :-
In Account A:-
* Added bucket policy...
2
answers
0
votes
1237
views
asked 9 months agolg...
© Exception in User Class: org.apache.spark.sql.catalyst.analysis.AccessControlException : User:
arn:aws:sts::awsaccoundid:assumedRole/IAMRole/GlueJobRunnerSessionisnotauthorizedto perform:...
1
answers
0
votes
322
views
asked 9 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
80
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
311
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
432
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
247
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
353
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
1904
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
1136
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
322
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
159
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...