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.
My understanding of Athena is it presents a database like view for files stored in S3 bucket. Am I correct?
So, what happens when I insert or modify a row (or multiple rows) in an Athena table via...
2
answers
0
votes
462
views
asked 6 months agolg...
Hello,
I have currently setup cloudtrail logs to be query able in athena, however my create table looks something like
```
CREATE EXTERNAL TABLE cloudtrail(
eventVersion STRING,
userIdentity...
1
answers
0
votes
368
views
asked 6 months agolg...
Hi All, I have created a cloudtrail log to read any s3 dataevent. I see in s3 location, logs have started building. But when I try to query this data in S3 , it's failing with error ...
0
answers
0
votes
108
views
asked 6 months agolg...
According to https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-evolving-table-schema.html
> Drop – Removes an existing column from a table or nested struct.
However in...
0
answers
0
votes
90
views
asked 6 months agolg...
Issue while querying the cloudfront logs using Athena. All the resources are being created successfully when I run a basic sql query to fetch last 100 logs it fails with below error. verified the...
0
answers
0
votes
67
views
asked 6 months agolg...
Hi, I am trying to run a query against search data, the query runs as expected but after about 25 seconds of run time, it fails and this error message...
Accepted AnswerAmazon Athena
1
answers
0
votes
252
views
asked 6 months agolg...
Hey, i want to us athena to query cloud watch logs from other account(not my account).
When i set up athena data source and choose CloudWatch Logs, i don't see any option to control the account(and...
1
answers
0
votes
185
views
asked 6 months agolg...
If my environment is full of Apache Hudi integrating with EMR and Lake Formation, I found out that Hudi environment is not very friendly to be used by Redshift nor Athena. There are many advanced...
1
answers
0
votes
479
views
asked 6 months agolg...
Hello,
I'm trying to do this tutorial about "Analyzing insights from reviews"(https://docs.aws.amazon.com/comprehend/latest/dg/tutorial-reviews-tables.html).
When I arrive at step 5 I get this error...
1
answers
0
votes
190
views
asked 7 months agolg...
Usually I have no problems creating Athena tables in CDK v2 using ``new glue.Table``
However now I'm stuck trying to create Iceberg table using the same approach. Documentation was not really helpful,...
2
answers
0
votes
449
views
asked 7 months agolg...
Hello,
I want to run a query where the table name is a parameter, so the query is something like
`select * from :table_name`
I am getting this error ' mismatched input' as table name contains...
0
answers
0
votes
78
views
asked 7 months agolg...
Query ID: 84d42059-9f5a-4782-8d04-6c8acff6f0cb
We can reliably generate this error with our query
What should be do
2
answers
0
votes
322
views
asked 7 months agolg...