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.
What are the ways to access delta tables in S3 other than AWS Athena?
0
answers
0
votes
77
views
asked 5 months agolg...
Hi,
I am trying to run an SQL query from sagemaker R kernel notebook.
I have connected to db using rJDBC and this works:
```
show_databases <- dbGetQuery(conn, "show...
0
answers
0
votes
128
views
asked 5 months agolg...
Hi, i have a domain in datazone in account A and i need to access data that is located in account B, but i'm facing some issues.
Here are the steps i made so far:
1) In Account B i added the data lake...
0
answers
0
votes
135
views
asked 5 months agolg...
AWS Athena Timeoutlg...
Hi, is it feasible to set a timeout for Athena queries that exceed a 2-minute duration? I'm aware of the default 30-minute soft limit, but is there a way to decrease this timeout threshold?
0
answers
0
votes
93
views
asked 5 months agolg...
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
237
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
431
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
324
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
104
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
85
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
65
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
233
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
168
views
asked 6 months agolg...