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
428
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
245
views
asked 5 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
156
views
asked 5 months agolg...
What are the ways to access delta tables in S3 other than AWS Athena?
0
answers
0
votes
78
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 6 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
136
views
asked 6 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 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
105
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
146
views
asked 7 months agolg...