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.
using
```
UNLOAD(SELECT * FROM TABLE) TO 's3://...'
WITH (format = 'PARQUET',compression = 'SNAPPY');
```
there is a column in table with is an array which comes back with`Parquet record is...
0
answers
0
votes
77
views
asked a year agolg...
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
420
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
185
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
190
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
107
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
54
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...