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.
Hi, I am trying to share a View from AccountA to AccountB using Lake Formation.
But it seems the shared view is trying to refer resources in the Target Account (AccountB) instead of Source Account...
2
answers
0
votes
295
views
asked 4 months agolg...
I have a CTR data in JSON format stored in s3 bucket which has the below column
"SegmentAttributes": {
"connect:Subtype": {
"ValueString": "connect:Telephony"
}
}
Due...
1
answers
0
votes
337
views
asked 4 months agolg...
Hi all, I need to demonstrate lake formation data filters usage. What is the easiest way to query this data and show the difference caused by filters.
I have 2 roles accessible to my account. One role...
1
answers
0
votes
291
views
asked 4 months agolg...
What are the ways to access delta tables in S3 other than AWS Athena?
0
answers
0
votes
73
views
asked 4 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
118
views
asked 4 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
126
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
85
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
208
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
387
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
282
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
91
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
75
views
asked 5 months agolg...