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 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
190
views
asked 5 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
1462
views
asked 5 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
484
views
asked 5 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
619
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
670
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
480
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
400
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
126
views
asked 6 months agolg...
I am trying to run an athena query in a Sagemaker R Kernel notebook. The query uses an external UDF function. This query works on athena console but gives the following error in the...
1
answers
0
votes
195
views
asked 6 months agolg...
When a view is created by running an Athena SQL query, it appears in the Glue catalog but errors are raised when querying the view in a Glue job or a Glue Spark context.
I am able to make the view...
1
answers
0
votes
375
views
asked 6 months agolg...
Hello
I am trying to create a protected view following https://docs.aws.amazon.com/athena/latest/ug/views-glue.html
I created a simple Athena table backed by an s3 stored csv file.
The table looks...
1
answers
1
votes
199
views
asked 6 months agolg...
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
361
views
asked 6 months agolg...