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.
Getting below error while querying a Glue Table using Athena
com.amazonaws.services.s3.model.AmazonS3Exception: Access Denied (Service: Amazon S3; Status Code: 403; Error Code: AccessDenied; Request...
1
answers
0
votes
398
views
asked 4 months agolg...
![Reference table](/media/postImages/original/IMC_LZPd3JRsS-H1eO9mS9Fg)
Hello, I’ve a problem with the ordering generated by row_number, I have two STRING type columns (str_dt,str_ts) I need to order...
0
answers
0
votes
202
views
asked 4 months agolg...
Hi,
We send our database old data into S3 in this format:
{table}/year/month/day/asset_id.parquet
so we have a lot of files like...
1
answers
0
votes
396
views
asked 4 months agolg...
I am using below terraform script to create Athena Iceberg table,
resource "aws_glue_catalog_table" "athena_threshold_table" {
name = "my_config_table"
database_name =...
1
answers
0
votes
368
views
asked 4 months agolg...
I have json-per-line files in S3 that look like this:
{ "eventTimestamp": "...", "eventType": "...", "eventPayload": { complex object of unknown schema } }
How can I define an Athena table that...
1
answers
0
votes
481
views
asked 5 months agolg...
Hello,
While trying to run this command `DELETE FROM "datasets"."us_spending"` in Athena, on a table from AWS Data Catalog, I had this error:
```
NOT_SUPPORTED: Cannot delete from non-managed Hive...
1
answers
0
votes
767
views
asked 5 months agolg...
[Simba][AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Unable to load AWS credentials from any provider in the chain: [EnvironmentVariableCredentialsProvider: Unable to load AWS...
0
answers
0
votes
427
views
asked 5 months agolg...
The query below on current AWS Athena version 3 gives a wrong result for the centroid, which lies way below the polygon (POINT (6.127790214246207 46.2084751184263)). The exact same query in PostGIS...
0
answers
0
votes
423
views
asked 5 months agolg...
How can I consume S3 data and make it as an asset in AWS DataZone ?
1
answers
0
votes
720
views
asked 5 months agolg...
I am trying to write a pyspark dataframe to S3 and the AWS data catalog using the Iceberg format and the pyspark.sql.DataFrameWriterV2 with the createOrReplace function. When I write the same...
1
answers
0
votes
669
views
asked 5 months agolg...
Can someone please help with this error? I have a csv file in an S3 bucket, created a crawler to update a table in glue, and the crawler runs but when I try to view the data in athena I get this...
1
answers
0
votes
593
views
asked 5 months agolg...
Hello, I would like to know if there is a way to query Iceberg tables (backed with S3 parquet files) cataloged within the AWS Glue Catalog using AWS Databrew. (maybe through Athena?).
Also, is it...
2
answers
0
votes
595
views
asked 5 months agolg...