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.
**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
293
views
asked 8 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
476
views
asked 8 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
146
views
asked 8 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
332
views
asked 8 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
580
views
asked 8 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
768
views
asked 8 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
2198
views
asked 8 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
215
views
asked 8 months agolg...
Recurring Issue with AWS Athena When Running Queries on Iceberg Table.
Description
I am trying to run queries on an Iceberg table using AWS Athena. The data is stored in S3, and I am using EMR...
1
answers
0
votes
603
views
asked 8 months agolg...
Hi all,
I have an error message when I want to query Waf logs with Athena following these procedures described here below
https://docs.aws.amazon.com/athena/latest/ug/waf-logs.html
I created a...
1
answers
0
votes
758
views
asked 8 months agolg...
Greetings
I hope you are having a great day.
We were trying to create a Data Wrangler on AWS SageMaker to retrieve our data from AWS Athena to AWS SageMaker. We had this error while specifying the...
1
answers
0
votes
227
views
asked 9 months agolg...
Hello,
I'm playing around with Session Manager and I enabled logging to S3 Bucket, however logs are sent to the S3 bucket in a raw format and that makes it unpossible to query through the Athena...
1
answers
0
votes
342
views
asked 9 months agolg...