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 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
164
views
asked 3 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
267
views
asked 3 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
336
views
asked 3 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
172
views
asked 3 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
135
views
asked 3 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
229
views
asked 3 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
150
views
asked 3 months agolg...
i have the following script to be used in Athena query for AR product:
-- Look for drive units containing these motor assemblies.
SELECT pt_floor, du_id, subsystem, serial_num, part_num, rev_num,...
1
answers
0
votes
157
views
asked 3 months agolg...
Hi all,
I run some AWS Athena queries with the `ResultReuseByAgeConfiguration` option set. From a behaviour perspective, I would expect Athena to cache the results, but it seems Athena is caching it...
1
answers
0
votes
174
views
asked 3 months agolg...
Hi there,
We are having trouble with Athena Version 3 when some files have different types of data from the DDL table. In our case, some fields are timestamps in numeric format and some in date...
2
answers
0
votes
201
views
asked 3 months agolg...
Hi all,
I want to protect the connection between Power BI and Amazon Athena. I gave the end users IAM credentials, so they can setup their DSN in their local machines and start creating reports in...
0
answers
0
votes
81
views
asked 4 months agolg...
Is there a way to sync Athena notebooks with Git for version control? (Preferably with bitbucket, otherwise github or some other version control software to mange code.) If so, could you please send...
1
answers
0
votes
212
views
asked 4 months agolg...