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,
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
351
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
230
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
429
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
660
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
1073
views
asked 6 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 6 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
405
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
595
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
277
views
asked 7 months agolg...
Hi,
The following CTAS query fails with Col not found error.
```
CREATE table <table_name>
with(
format='PARQUET'
, write_compression='SNAPPY'
, partitioned_by=ARRAY["yearMonth"]
, external_location...
1
answers
0
votes
276
views
asked 7 months agolg...
I have a glue table specified that refers to a location in S3. I noticed that when Firehose puts data there in parquet format it might be not always compressed.
Will it cause issues for Glue table,...
1
answers
0
votes
302
views
asked 7 months agolg...