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_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
208
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
108
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
101
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
141
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
126
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
193
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
90
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
205
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
208
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...
First, I debug my regular expression online through Regex101, and successfully get the data I want. this is my debug [url](https://regex101.com/r/PfJlCL/1).
**My Text...
0
answers
0
votes
74
views
asked 2 years agolg...