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.
Hello AWS Community,
I'm facing a challenging issue with our AWS data pipeline that affects data visualization in Amazon QuickSight. Initially, our setup involved directly importing CSV data from S3...
0
answers
0
votes
203
views
asked 2 months agolg...
When trying to add an Athena dataset (pointing to an Iceberg table on S3 created with Glue), I get the following error message:
![Error...
1
answers
0
votes
124
views
asked 2 months agolg...
Getting this while i am querying document db using lambda function using Athena for specific tables only
TYPE_NOT_FOUND: Unknown type: row
This query ran against the "sample" database, unless...
1
answers
0
votes
128
views
asked 2 months agolg...
Hi all,
Does anyone know if Athena supports a SPLIT function? Are the Athena functions available limited to only those on this page https://docs.aws.amazon.com/athena/latest/ug/functions.html or do...
Accepted AnswerAmazon Athena
1
answers
0
votes
183
views
asked 2 months agolg...
In java getting Error:
java.sql.SQLException: [Simba][AthenaJDBC](100123) An error has occurred. Exception during column initialization .Details: select columns from "schema"."table" where filter...
1
answers
0
votes
119
views
asked 2 months agolg...
We are using Tableau and Tableau has a schedule querying athena.
It worked well until yesterday but I got below issue today.
> HIVE_CANNOT_OPEN_SPLIT: Error opening Hive split...
1
answers
0
votes
370
views
asked 2 months agolg...
Actually i uploaded one JSON file into my s3 bucket which is having nested JSON data. and, created Athena table out of it by using glue crawler. after that when i was trying to query the table i am...
0
answers
0
votes
352
views
asked 2 months agolg...
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
181
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
250
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
531
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
244
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
201
views
asked 2 months agolg...