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!
I have several thousand CloudWatch log files accumulated over the years and I have set up an Athena connection to query them.
Q: Is there a way to limit the query to - say the last month - so...
1
answers
0
votes
283
views
asked 4 months agolg...
I am trying to merge two iceberg tables using Athena but ran into error: "NOT_SUPPORTED: Iceberg table updates require at least format version 2". However, according to...
Accepted AnswerAmazon Athena
1
answers
0
votes
499
views
asked 4 months agolg...
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
213
views
asked 4 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
391
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
201
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
386
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
362
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
473
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
744
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
426
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
422
views
asked 4 months agolg...
How can I consume S3 data and make it as an asset in AWS DataZone ?
1
answers
0
votes
696
views
asked 5 months agolg...