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.
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
57
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
188
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
101
views
asked 2 years agolg...
I am using AWS Athena,
I have a subquery like this.
select * from (WITH dataset (json_str) AS (
VALUES (
json '{
"address":{
...
0
answers
0
votes
97
views
asked 2 years agolg...
Hi! I created a presto view from a data catalog using CfnTable syntax and it is generating the correct CVAS query. However, when I query the view I get the following error.
``GENERIC_INTERNAL_ERROR:...
0
answers
0
votes
137
views
asked 2 years agolg...
Athena query errorlg...
HIVE_BAD_DATA: Error parsing field value for field 1: java.lang.Boolean cannot be cast to java.lang.Integer
This query ran against the "logmessagedb" database, unless qualified by the query. Please...
0
answers
0
votes
125
views
asked 2 years agolg...
In my early steps on the S3, Glue and Athena services, I managed to create a table with Glue, with respect some parquet files in an S3 bucket. Every 30 minutes a new parquet file, with same columns,...
0
answers
0
votes
186
views
asked 2 years agolg...
I have a database that I have been working with and I am trying to add a new table through Glue.
I have been able to create the table and populate data, but I cannot update the partition names in the...
0
answers
1
votes
104
views
asked 2 years agolg...
I tried to perform simple SQL query via Athena SDK. If I run the same SQL query in the web console, I got the correct result. Here is my...
0
answers
0
votes
87
views
asked 2 years agolg...
Error:
HIVE_PARTITION_SCHEMA_MISMATCH: There is a mismatch between the table and partition schemas. The types are incompatible and cannot be coerced. The column 'isfallbackkey' in table...
0
answers
0
votes
200
views
asked 2 years agolg...
Hello, I am currently having a problem following along this blog post: https://aws.amazon.com/blogs/mt/visualizing-aws-config-data-using-amazon-athena-and-amazon-quicksight/ along with this blog which...
0
answers
0
votes
174
views
asked 2 years agolg...
The data I am working with has several data entries at each time stamp. Each data point contains a field for sensor name as well as a field for value. So the field for sensor name is automatically...
0
answers
0
votes
72
views
asked 2 years agolg...