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 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
352
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
89
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
184
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
478
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
447
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
76
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
320
views
asked 7 months agolg...
Can we delete the column of the table in Athena
1
answers
0
votes
1267
views
asked 7 months agolg...