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.
GENERIC_INTERNAL_ERROR
This query ran against the "synergy_mysql_prod" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id:...
1
answers
0
votes
79
views
asked a month agolg...
Trying to create an Athena table with the following query
```
CREATE TABLE IF NOT EXISTS current_energy_rates
WITH (table_type = 'ICEBERG', format='PARQUET', location='s3://pr-energy-lookup',...
0
answers
0
votes
60
views
asked a month agolg...
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
199
views
asked a month 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
108
views
asked a month 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
105
views
asked a month 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
151
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
110
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
346
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
348
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
175
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
514
views
asked 2 months agolg...