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.
Athena version 3lg...
Getting the following error in AWS Athena with version 3 engine. The same query works in version 2. The error is not very descriptive and we have a very large dataset. Without knowing what the exact...
1
answers
0
votes
258
views
asked 6 months agolg...
I'm using an AWS Glue job for my data processing tasks, and my source system provides monthly snapshots of data. Before executing the create_dynamicframe function, I want to execute a select count(*)...
1
answers
0
votes
386
views
asked 6 months agolg...
Hi,
I have a log insight query in that there is field named as instance_id it contains just 2 or more ec2 instance id's. I have a requirement of separating each ec2 instance in to a new field .
...
1
answers
0
votes
353
views
asked 6 months agolg...
Hi I have a lambda that try to do a simple select in a table(s3) of Athena, this lambda always is showing me access denied in results showed in log bucket, the lambdas has fullbaccesS3 fullaccess...
2
answers
0
votes
232
views
asked 6 months agolg...
Tried in CLI and console mode, when I clicked on a database in dsta catalog, getting below error
AccessDeniedException: Please migrate your catalog to enable access to this database
This Athena...
1
answers
1
votes
436
views
asked 6 months agolg...
I am trying to add a table property to an iceberg table from Athena.
```
ALTER TABLE silver.table_name SET TBLPROPERTIES (
'write.merge.mode'='merge-on-read'
)
```
The query fails with error :...
1
answers
0
votes
665
views
asked 6 months agolg...
Is it possible to query S3 data (semi-structured json files) using s3 data without Glue Catalog?
basically on query time, choose the s3 location i want to query.
s3 location -...
2
answers
0
votes
1094
views
asked 7 months agolg...
I'm looking for an open-source solution that can help us make our python API more accessible.
For simplicity's sake, the data is accessed using Athena and has three string fields A, B, C.
Every...
0
answers
0
votes
144
views
asked 7 months agolg...
Athena Query Errorlg...
Getting these errors when I run a query in Athena following successful AWS glue crawler run, kindly help
HIVE_BAD_DATA: Error Parsing a column in the table: fieldValue should not be null
This query...
1
answers
0
votes
411
views
asked 7 months agolg...
I am trying to create the table using that following command that worked fine yesterday:
```
CREATE EXTERNAL TABLE IF NOT EXISTS `delta_gold`.`properties`
LOCATION...
Accepted AnswerAmazon Athena
3
answers
4
votes
597
views
asked 7 months agolg...
I'm trying to create a new Athena/Iceberg table in my existing S3 directory structure. The location contains equal signs, e.g. `country=all/data`. These equal signs are escaped by Athena, which...
0
answers
0
votes
117
views
asked 7 months agolg...
I am running query in athena engine 3.0 and getting the error
**[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE]** Amazon Athena experienced an internal error while executing this query.
Query is like :
/*...
1
answers
0
votes
280
views
asked 7 months agolg...