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.
Trying to query an athena view using a Glue Job I am getting this jdbc driver issue:
>Error Category: UNCLASSIFIED_ERROR; An error occurred while calling o109.load....
1
answers
0
votes
223
views
asked 5 months agolg...
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
415
views
asked 5 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
314
views
asked 5 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
100
views
asked 5 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
82
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
64
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
225
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
158
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
435
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
177
views
asked 6 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
377
views
asked 6 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
71
views
asked 6 months agolg...