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.
I am trying to follow the notebook here to create a AWS Athena database, fill it with data from Amazon reviews and execute a query....
1
answers
0
votes
425
views
asked 6 months agolg...
We're using ICEBERG table and we see that each update increase the number of folders and PARQUET files in S3, although data itself wasn't change. Is there an option to compacting and optimizing...
1
answers
0
votes
442
views
asked 6 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
161
views
asked 6 months agolg...
I have uploaded two separate csv files (just to check the query results) with the tables in the right order and values in S3, but everytime I run the crawler and view the individual table data in...
1
answers
0
votes
253
views
asked 6 months agolg...
I am trying to see if I can use EMR Serverless to serve as a compute engine for customers querying data in S3. But even with pre-initialized capacity, the simplest of queries possible (select 1+2 as...
1
answers
0
votes
195
views
asked 6 months agolg...
To know about the data type of a column, I am running this query.
```sql
SELECT
*
FROM
information_schema.columns
WHERE
table_name = 'orders'
AND column_name = 'shipment_time';
```
and it...
1
answers
0
votes
1502
views
asked 6 months agolg...
Using SQL Alchemy ORM to query an AWS athena database. First off, here is the raw SQL query, which is working perfectly
```sql
WITH zi AS (SELECT
trip.start_dt,
address.zone_id
FROM...
1
answers
0
votes
494
views
asked 6 months agolg...
Hi,
I'm using Athena Table - ICEBERG type.
I would like to update with Select statement in order to update bunch of records at a time. For example:
`UPDATE skus_market_share_sum1
SET...
2
answers
0
votes
634
views
asked 6 months agolg...
I am using Athena together with SQL Alchemy ORM. I just created a table (for testing some machine learning model integration) and pushed some data to it using SQL Alchemy ORM. But unfortunately, I can...
1
answers
0
votes
690
views
asked 6 months agolg...
Hi,
I created ICEBERG table by using CTAS command.
By mistake I deleted the Parquet files and afterwards tried to drop the table.
Now once I'm trying to delete the table I'm getting the following...
1
answers
0
votes
492
views
asked 6 months agolg...
I have been made to understand that Athena is different from normal SQL as it basically reads and queries data from an s3 backend. However, I am very much used to the SQL Alchemy ORM interface for...
1
answers
0
votes
408
views
asked 6 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...
1
answers
0
votes
128
views
asked 6 months agolg...