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.
background:
Users upload files to an S3 bucket containing their predictions for events under certain circumstances. I want my query results to only show the most recently made prediction for the...
2
answers
0
votes
428
views
asked 7 months agolg...
In the AWS forecast, How can we use DynamoDB as an input?
1
answers
0
votes
357
views
asked 7 months agolg...
We have created a table in athena and we are updating the schema of the table accordingly the versions are being created of that table in AWS Glue so can we roll down that version in glue and same...
1
answers
0
votes
722
views
asked 7 months agolg...
Can we create a table or manage the schema in athena using AWS Data migration service.
1
answers
0
votes
456
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
171
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
438
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
421
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
273
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
430
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
374
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
244
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
469
views
asked 7 months agolg...