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.
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
417
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
621
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
1017
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
142
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
386
views
asked 6 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
579
views
asked 6 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
115
views
asked 6 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
267
views
asked 6 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
266
views
asked 6 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
295
views
asked 6 months agolg...
Hello,
Is there a DQ rule that can identify empty or null columns? Or is there an sql query that can identify empty columns?
thanks.
1
answers
0
votes
268
views
asked 6 months agolg...
1. I am trying to understand how to estimate the end result of pricing for Glue crawlers for data being ingested by AWS Kinesis Firehose service with the max possible buffer setting while glue...
0
answers
0
votes
172
views
asked 6 months agolg...