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.
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
70
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
188
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
135
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
306
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...
Hi there,
I'm trying to create a AWS Glue json table using the geojson schema published in https://geojson.org/schema/GeoJSON.json
I created the schema in the schema registry without problems,...
0
answers
1
votes
107
views
asked 2 years agolg...