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 excuting this sql in the AWS Management Console / Athena Query Editor
```
ALTER TABLE iceberg_table CHANGE COLUMN comment blog_comment string AFTER id
```
it should allow for...
0
answers
0
votes
176
views
asked 2 months agolg...
0
I'm encountering a NoSuchKey error while attempting to create an Athena Iceberg table using AWS Wrangler. Here's the anonymized error message:
{
"errorMessage": "GENERIC_INTERNAL_ERROR:...
0
answers
0
votes
245
views
asked 2 months agolg...
I wanted to know, what are the different ways through which we an access s3 data for different usecases . I have mentioned below about the ways i know :
- Accessing s3 data directly over internet
-...
3
answers
-1
votes
516
views
asked 2 months agolg...
Hi Experts,
We have replicated DB from SQL server to AWS.
We need to extract latest table data using extraction_timestamp.
For every insert and update in SQL DB it is being synchronized with AWS S3...
2
answers
0
votes
222
views
asked 2 months agolg...
We seeing errors with Athena Iceberg tables. One error is:
ICEBERG_CANNOT_OPEN_SPLIT: Error opening Iceberg split...
1
answers
0
votes
189
views
asked 2 months agolg...
folks, struggling to get instance family being used for Elasticache across Payer, I tried few combination of CUR queries to no avail. Does anyone have a tested reference to get the information? TIA
Accepted AnswerAmazon Athena
1
answers
0
votes
170
views
asked 2 months agolg...
I have JSON data stored in an S3 bucket, and I'm creating an Athena table to query this data. One of the columns in the JSON represents monetary values stored as integers (e.g., 1000 represents...
1
answers
0
votes
220
views
asked 2 months agolg...
Hi Aws team,
Getting error after running query and selecting default table also. Any solution.
![Enter image description here](/media/postImages/original/IM5LqYwCEAQcGJZ1hR2mxMHQ)
2
answers
0
votes
474
views
asked 2 months agolg...
I have an Iceberg Table which holds constant number of rows.
Every hour I update some of this rows using `MERGE` command.
After *each* `MERGE` I'm executing `VACUUM` command.
Table is created with...
1
answers
0
votes
569
views
asked 2 months agolg...
I have a partitioned table in athena based on
I query the data with this where clause
DATE(year || '-' || month || '-' || day) >= from_iso8601_timestamp('2024-03-18T00:00:00')
does it still make...
2
answers
0
votes
495
views
asked 2 months agolg...
Example s3://bucket1/mytable/ -- > east-2 bucket folder with same schema
s3://bucket2/mytable/ -- > west-2 bucket folder with same schema
can we create a single table from this two...
3
answers
0
votes
563
views
asked 2 months agolg...
# Error while running UNLOAD to PARQUET query using column names with spaces in
## Introduction
I have a table in Athena with the following column names ["column space 1", "column space 2"]. I...
1
answers
0
votes
643
views
asked 2 months agolg...