Unanswered 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.
Started getting this error today when querying data from Athena in a table created from parquet files in our S3 bucket:
![Enter image description...
0
answers
0
votes
96
views
asked a year agolg...
Getting the below error while querying on Athena -
HIVE_INVALID_PARTITION_VALUE: Invalid partition value 'Unsaved-2023-03 22:00:00' for TIMESTAMP partition key: ingest_timestamp=Unsaved-2023-03...
0
answers
0
votes
110
views
asked a year agolg...
I do a crawler to load all my S3 csv files to Glue Data Catalog. Now I want to create a glue job to execute ETL (create and drop temporary tables, select and insert data to tables in Data Catalog) But...
0
answers
0
votes
55
views
asked a year agolg...
My requirement is like : I want to query the iceberg table present in another AWS account.
Let's say I am a user of account A and want to query account B's iceberg tables present in that account's...
0
answers
0
votes
191
views
asked a year agolg...
Getting following error while executing Node and edge sql : ERROR: NOT_SUPPORTED: ROW comparison not supported for fields with null elements
This query ran against the "wow_athena" database, unless...
0
answers
0
votes
36
views
asked a year agolg...
I am having this error when querying the information table in Athena. I wonder if anyone else received this error.
```SQL
select distinct substr("table_name", 12, 8) as "dt" from...
0
answers
0
votes
34
views
asked a year agolg...
The parquet has a nested structure where a map contains a struct which is itself nested.
i'm not sure if athen'as serDe can handle it, but i would like to find a way to read it with athena.
The table...
0
answers
1
votes
274
views
asked a year agolg...
All,
I recently updated an AVRO Schema. I have checked that the updates made to the schema are backward compatible; and they are. Next, I saved an avro file w/ the new schema to an s3 Bucket and...
0
answers
0
votes
47
views
asked a year agolg...
When creating a new data set in QuickSight, I receive an error:
```
[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. Access denied when writing to location: s3://<data...
0
answers
0
votes
176
views
asked a year agolg...
We are tying to call the AWS Athena from Tableau on local desktop and it works fine. We have changed the firewall settings and open the port 443,444.
Now, we tried to do the same thing from Tableau...
0
answers
0
votes
135
views
asked a year agolg...
So we noticed an issue after upgrading from the Athena v2 engine to v3 it happens when trying to use CTAS to create a table and bucket the data based on a timestamp this is definitely a new issue...
0
answers
1
votes
184
views
asked a year agolg...
I've tried to UNLOAD() data from MySQL to S3 by Athena engine 3 and got an error: __INVALID_SESSION_PROPERTY: Unknown session property ***.manifest_location.__
*** - this is my Data source.
But it...
0
answers
0
votes
97
views
asked a year agolg...