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.
When trying to insert data into an Athena/Iceberg table, using Java Athena JDBC Driver 3.0.0, getting error "Member must have length less than or equal to 1024".
# The table:
CREATE TABLE IF NOT...
0
answers
0
votes
207
views
asked 3 months agolg...
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
370
views
asked 3 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
198
views
asked 3 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
365
views
asked 3 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
346
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
452
views
asked 4 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
696
views
asked 4 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
424
views
asked 4 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
421
views
asked 4 months agolg...
How can I consume S3 data and make it as an asset in AWS DataZone ?
1
answers
0
votes
673
views
asked 4 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
611
views
asked 4 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
558
views
asked 4 months agolg...