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.
Whenever i am trying to query data from my hudi data lake hosted in athena i am getting the following error
```
HIVE_UNKNOWN_ERROR: Cannot invoke "org.apache.hadoop.fs.Path.toString()" because...
0
answers
0
votes
87
views
asked a year agolg...
HI,
I'm working with databrew to import some excel file to be then used by Athena. For some columns if I try to add an action I get the following error
`<ACTION>has not allowed characters in...
0
answers
0
votes
88
views
asked a year agolg...
First of all, I have already asked about this problem here in re:Post and on Database Administrators Stack Exchange...
0
answers
0
votes
125
views
asked a year agolg...
When I run the query (I have reduced the column names and airport codes in the query to reduce your scrolling time) below in Amazon Athena it runs and I get no problems or error messages:
```
SELECT
...
0
answers
0
votes
129
views
asked a year agolg...
I'm currently facing an issue while accessing a RDS (MySQL) in another AWS account, using a shared VPC through AWS Athena Federated Query. I have already configured everything, including VPC, Subnets....
0
answers
0
votes
147
views
asked a year agolg...
Trying to read parquet data produced with Athena using SerDe below into Pandas. It uses Map types, but produces this error:
"Map keys must be annotated as required".
Other libraries also fail to read...
0
answers
0
votes
49
views
asked a year agolg...
AWS Athena - Cross Account access - Engine version 2 deprecate on August 6, 2023 in EU-WEST-1 regionlg...
Hi,
I have 2 aws accounts as below. Both the accounts are in the region eu-west-1. I need to do Athena Cross Account queries with right catalog permission settings.
Account 1 (producer account) -...
0
answers
0
votes
117
views
asked a year agolg...
We are using AWS Lookout Metrics for anomalies detection from sometime now. While analysing we identified that it shows broken graph for some dates and while hovering the graph says value as NULL...
0
answers
0
votes
80
views
asked a year agolg...
I am receiving this error while querying in athena: GENERIC_INTERNAL_ERROR: java.lang.IllegalArgumentException: Error: type expected at the position 0 of 'set<string>' but 'set' is found.
What does...
0
answers
0
votes
47
views
asked a year agolg...
Hi, I'd appreciate AWS Athena support for TIMESTAMP data type with microsecond precision for all row formats and table engines. Currently, the support is very inconsistent. See the SQL script below....
0
answers
0
votes
145
views
asked a year agolg...
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
97
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
115
views
asked a year agolg...