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 team, please i need you help. I kept getting this road block. I am trying to query a table from CURs report in an S3 bucket via athena and i got this error.
```
TABLE_NOT_FOUND: line 6:7: Table...
3
answers
0
votes
280
views
asked 7 months agolg...
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
434
views
asked 7 months agolg...
In the AWS forecast, How can we use DynamoDB as an input?
1
answers
0
votes
360
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
728
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
458
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
172
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
448
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
423
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
435
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...