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.
Trying to set up AMG to query athena. Tagged the workgroup, configured the datasource and it tests ok. I don't seem to be able to return any data though, its possible I'm just struggling with syntax -...
1
answers
0
votes
406
views
asked 6 months agolg...
Can I import the PySpark MLLIB library into an Athena Notebook? If so, can you explain the steps? Do I use a jar file to setup during configuration of the individual notebook? It wasn't working for...
1
answers
0
votes
395
views
asked 6 months agolg...
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
263
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
391
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
355
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
233
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
442
views
asked 7 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
672
views
asked 7 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
1110
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
145
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
412
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
599
views
asked 7 months agolg...