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.
Can we create a table or manage the schema in athena using AWS Data migration service.
1
answers
0
votes
449
views
asked 7 months agolg...
I've set up an ODBC connection with Athena. When connecting from excel:
The connection works fine when using Get Data / From Other Sources / ODBC. I get access to the tables and data in Athena.
The...
1
answers
0
votes
169
views
asked 7 months agolg...
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
429
views
asked 7 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
410
views
asked 7 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
270
views
asked 7 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
425
views
asked 7 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
367
views
asked 7 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
240
views
asked 7 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
458
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
717
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
1197
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
147
views
asked 7 months agolg...