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.
We are experiencing the following issue, that is blocking us from upgrading to **Athena engine version 3**. It's important to note that the query runs **successfully** when using Athena engine version...
0
answers
0
votes
419
views
asked 2 years agolg...
HIVE_UNSUPPORTED_FORMAT: Output format org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat with SerDe org.openx.data.jsonserde.JsonSerDe is not supported. If a data manifest file was generated...
0
answers
0
votes
184
views
asked 2 years agolg...
hi,
I am looking for a query structure with would allow me to simply delete a specify column from a table not partitioned.
I tried this below
ALTER TABLE table_name
DROP COLUMN column_name
but it...
0
answers
0
votes
72
views
asked 2 years agolg...
I encounter the error when I try to create a new Athena dataset on QuickSight (click on [Validate connection] button);
* Error Code: ACCESS_DENIED_TO_RESULT_STAGING_AREA
* Error Message:...
0
answers
0
votes
189
views
asked 2 years agolg...
Hi guys, hope you are well!
I need help with a query in athena to get my data for the previous month. In sql I used a query that worked very well and in athena I'm not getting it.
My field is coming...
0
answers
0
votes
137
views
asked 2 years agolg...
Hello, we are experiencing extremely slow queries against lake formation governed tables when using the Athena console and/or jdbc clients. For example, a simple count(*) of a three-row table takes...
0
answers
0
votes
106
views
asked 2 years agolg...
when select data from athena, it reports error:
HIVE_UNKNOWN_ERROR: com.amazonaws.services.lakeformation.model.InvalidInputException: Unsupported vendor for Glue supported principal:...
0
answers
0
votes
53
views
asked 2 years agolg...
I just tried out Athena Engine version 3 with my existing workload (that works under engine version 2), and I get a number of errors like this one:
> NOT_SUPPORTED: Casting a Timestamp with Time Zone...
0
answers
0
votes
307
views
asked 2 years agolg...
We have a JSON which is like this { Id: \"12\", Id_type: \"xyz\",\"Details\":[{\"Timestamp\": \"2022-10-21\"}]}. This is our format. When I update the mainfest file with the foldr name it is taking...
0
answers
0
votes
59
views
asked 2 years agolg...
We've set up cross account access as described [here](https://docs.aws.amazon.com/athena/latest/ug/data-sources-glue-cross-account.html). All our cross account queries have been working up to...
0
answers
0
votes
118
views
asked 2 years agolg...
Hi,
I'm using Glue with DataBrew for Quicksight and I got this message on quicksight.
> Partition value count does not match the partition column count. (from athena)
So my table is using a column...
0
answers
0
votes
61
views
asked 2 years agolg...
"HIVE_CURSOR_ERROR: java.io.IOException: Start of Object expected" error when using Hive JSON SerDelg...
I recently switched from using the "org.openx.data.jsonserde.JsonSerDe" to "org.apache.hive.hcatalog.data.JsonSerDe" so I can use custom timestamp formats ( as described [here in the AWS...
0
answers
0
votes
205
views
asked 2 years agolg...