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.
According to the insights on the Cudos dashboard, we were making a monthly saving of $12k when switching to standard-ia in this table.
We made the transition on January 31st, and even now, we can see...
2
answers
0
votes
679
views
asked 3 months agolg...
S3 LOCATION INvalidlg...
HI, Having problem w my query. It says "S3 location provided to save your query results is invalid". Can you help me with this?
1
answers
0
votes
188
views
asked 4 months agolg...
I have 2 AWS accounts, Account "A" contain AWS Redshift and Account "B" has external data that crawler from S3.
## What I have done
#### Account A
1. Attached spectrum role to Redshift
![spectrum...
1
answers
0
votes
538
views
asked 4 months agolg...
GENERIC_INTERNAL_ERROR: SchemaParseException thrown initializing deserializer io.trino.plugin.hive.avro.TrinoAvroSerDe. Cause: com.fasterxml.jackson.core.JsonParseException: Illegal unquoted character...
1
answers
0
votes
166
views
asked 4 months agolg...
Time stamp errorlg...
I want to filter by time stamp but i keep getting i try cast it as a time stamp; Please...
1
answers
0
votes
138
views
asked 4 months agolg...
Hi there,
I ran a workload on Athena's capacity reservation setup which completed successfully but didn't utilize the entire resource in the reserved capacity. It only used 78% percent of it...
1
answers
0
votes
180
views
asked 4 months agolg...
I have an external Iceberg REST Catalog implementation and I need to use that with Athena. Do we currently support this use case? If so, are there any documentation on how to do this?
The closest use...
2
answers
0
votes
308
views
asked 4 months agolg...
For example the MySQL driver has `useCompression=true`.
But this is always driver-specific.
Does the Athena JDBC driver have a similar option?
2
answers
0
votes
346
views
asked 4 months agolg...
Hive Bad Data errorlg...
Objective: Convert json file to parquet whenever a file lands in S3 bucket via lambda function.
First I tested my lambda function( with a single file) and created a schema of which I changed the...
2
answers
0
votes
184
views
asked 4 months agolg...
We used to have all our workgroups in the Athena Version 2, some of them were automatically upgraded to the version 3. Now, some of our analysis queries is breaking due the timestamp (3) ->...
1
answers
0
votes
146
views
asked 4 months agolg...
It is not at present possible to modify placeholder at all, including deletion. Deleting them is at least in principle possible as it doesn’t actually modify the object, but since the placeholders...
1
answers
0
votes
263
views
asked 4 months agolg...
HIVE_PARTITION_SCHEMA_MISMATCH: There is a mismatch between the table and partition schemas. The types are incompatible and cannot be coerced. The column 'harsh.cornering.angle' in table...
1
answers
0
votes
160
views
asked 4 months agolg...