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.
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
14
views
asked 4 hours 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
16
views
asked 13 hours 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
17
views
asked 2 days 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
49
views
asked 4 days 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
64
views
asked 7 days 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
56
views
asked 11 days 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
263
views
asked 15 days 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
318
views
asked 15 days 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
155
views
asked 16 days 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
223
views
asked 17 days 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
456
views
asked 19 days 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
141
views
asked 23 days agolg...