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,
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
156
views
asked 5 months agolg...
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...
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
86
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
66
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
75
views
asked 6 months agolg...
I'm looking for an open-source solution that can help us make our python API more accessible.
For simplicity's sake, the data is accessed using Athena and has three string fields A, B, C.
Every...
0
answers
0
votes
145
views
asked 7 months agolg...
I'm trying to create a new Athena/Iceberg table in my existing S3 directory structure. The location contains equal signs, e.g. `country=all/data`. These equal signs are escaped by Athena, which...
0
answers
0
votes
118
views
asked 7 months agolg...
1. I am trying to understand how to estimate the end result of pricing for Glue crawlers for data being ingested by AWS Kinesis Firehose service with the max possible buffer setting while glue...
0
answers
0
votes
176
views
asked 7 months agolg...