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.
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
119
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
56
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
200
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
279
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
48
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
184
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
148
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
192
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...
Hi,
I am getting this below error when writing data to iceberg table where I'm partitioning the table on a column called device_id.
The device_id has a set of guids which is stored as a string.
I...
0
answers
0
votes
64
views
asked a year agolg...