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.
If I have an athena table built on top of a s3 bucket whose objects are in the intelligent tiering storage class, is there anything to keep in mind? Will it still work?
1
answers
0
votes
758
views
asked 9 months agolg...
Hi,
The environment is, there are multiple JSON files in a S3 bucket. I would like to add all of them to the Athena Table with the filtered values. I used the ChatGPT for the Athena query to create...
2
answers
0
votes
2853
views
asked 9 months agolg...
Say I have a s3 bucket with json files in the following format:`s3://bucket_name/logs/region={region}/year={year}/month={month}/day={day}/hour={hour}/`
I would like to use partition projection on...
1
answers
0
votes
672
views
asked 9 months agolg...
Hello
I am getting a timeout when trying to connect to Athena through JDBC (I am using squirrel client)
java.util.concurrent.TimeoutException
at...
1
answers
0
votes
236
views
asked 9 months agolg...
Hello
I have been trying to setup a jdbc connection to Amazon Athena but my connection gets hung. Below is the line at which connection just hangs
Sep 06 23:34:24.281 TRACE 291...
1
answers
0
votes
269
views
asked 9 months agolg...
How to restrict a user from downloading Athena query results, and prevent them from uploading files directly to the Athena results bucket? User should still be able to run query in Athena and see the...
Accepted AnswerAmazon Athena
1
answers
0
votes
602
views
asked 9 months agolg...
I am still learning to use the Glue ETL process for building new aggregate tables and need help optimizing my ETL job.
My ETL job is designed to run once per day in the mornings and pull in all the...
1
answers
0
votes
363
views
asked 9 months agolg...
Hi,
I have used Firehose, AWS Glue Crawler, and Athena since 2022, and everything as well until May 2023, when the AWS Glue Crawler got an Internal Service Exception. I can't find the exact reason. I...
1
answers
0
votes
1502
views
asked 9 months agolg...
**Problem:**
MSCK REPAIR TABLE "table"; => Double quote does not work.
Result: line 1:1: mismatched input 'MSCK'. Expecting: 'ALTER', 'ANALYZE', 'CALL', 'COMMENT', 'COMMIT', 'CREATE', 'DEALLOCATE',...
1
answers
0
votes
311
views
asked 9 months agolg...
Hi I have a table in Athena with an attached screenshot.
How i can list all entries in between two days using timestamp column as reference![Enter image description...
2
answers
0
votes
503
views
asked 9 months agolg...
Athena has started giving suggestions when you are typing, called typeahead, which can be switched on or off.
I would like these on as they are very useful, but every time you click on a suggestion...
1
answers
0
votes
152
views
asked 9 months agolg...
HI,
I have 2 AWS accounts.
I have enabled cross account access for S3 and Glue artifacts.
Acc A has data in S3 Buckets.
Acc B is reading the data using Athena.
I am using SSE with KMS (SSE-KMS)
I...
1
answers
0
votes
342
views
asked 9 months agolg...