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.
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
76
views
asked 5 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
63
views
asked 5 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
214
views
asked 5 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
139
views
asked 5 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
417
views
asked 5 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
166
views
asked 5 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
347
views
asked 5 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
70
views
asked 5 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
258
views
asked 5 months agolg...
Can we delete the column of the table in Athena
1
answers
0
votes
945
views
asked 5 months agolg...
Hi team, please i need you help. I kept getting this road block. I am trying to query a table from CURs report in an S3 bucket via athena and i got this error.
```
TABLE_NOT_FOUND: line 6:7: Table...
3
answers
0
votes
249
views
asked 5 months agolg...
background:
Users upload files to an S3 bucket containing their predictions for events under certain circumstances. I want my query results to only show the most recently made prediction for the...
2
answers
0
votes
367
views
asked 5 months agolg...