Unanswered 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
Trying to craw connect logs create bad metadata with fields like this inside the table:
struct<connect\:Subtype:struct<ValueString:string>>
obvious running this struct inside athena result in a...
0
answers
0
votes
425
views
asked 4 months agolg...
If I try to return the dataframe or use json.dumps(df) in Athena Spark start_calculation_execution codeBlock, they results appear in stdout file in S3 folder for the session and query execution. How...
0
answers
0
votes
242
views
asked 4 months agolg...
Hi,
I'm using MERGE INTO with UPDATE on top of ICEBERG.
For example
`MERGE INTO accounts t USING monthly_accounts_update s
ON (t.customer = s.customer)
WHEN MATCHED
THEN UPDATE SET...
0
answers
0
votes
148
views
asked 5 months agolg...
I have a bucket 'X' in account 'A', I want to create a copy of the bucket in account 'B' using Athena. I already have a mapping defined in Athena of account 'B' where I can already access another...
0
answers
0
votes
112
views
asked 5 months agolg...
What are the ways to access delta tables in S3 other than AWS Athena?
0
answers
0
votes
76
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
123
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
132
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
90
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
99
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
78
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...
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...