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.
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
264
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
591
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
358
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
1484
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
306
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
495
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
149
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
338
views
asked 9 months agolg...
How to create separate Glue Catalog table on single S3 bucket with various different types of fileslg...
Hi,
I have to create/generate a separate individual Glue Catalog tables by crawaling single S3 bucket based on different types of files.
Suppose, I have S3 bucket as...
2
answers
0
votes
603
views
asked 9 months agolg...
Hi,
I'm trying to query some data in parquet files in Athena, but I have two columns that are timestamp but they don't have mls. The date format is in varchar like: '2023-08-09 15:41:42'.
I'm trying...
1
answers
0
votes
795
views
asked 9 months agolg...
The way we have EXCEPT or MINUS in Redshift to know difference between two tables in Redshift - do we have something similar in Athena?
Accepted AnswerAmazon Athena
1
answers
0
votes
2342
views
asked 9 months agolg...
Hi,
New to AWS! I'm running a crawler through a folder in an s3 bucket of roughly 1000 files which are a mix of xlsx and csv. I want the crawler to pass the csv files into a table that I will...
1
answers
0
votes
223
views
asked 9 months agolg...