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 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
99
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
191
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
89
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
204
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
185
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...
Error - "SYNTAX_ERROR: line 5:14: Invalid reference to output projection attribute from ORDER BY aggregation"
I have connected athena to quicksight. Since, quicksight doesn't show count beyond 99 in a...
0
answers
0
votes
260
views
asked 2 years agolg...