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.
I'm trying to run a Python script in aws glue that uses athena.get_query_runtime_statistics when I run i on my local machine the script works, but running at glue returns this error
0
answers
0
votes
242
views
asked 14 days agolg...
1. Created table using
CREATE EXTERNAL TABLE `daily_wallet_dlr_new`(
`transactiondate` bigint,
`walletid` string,
`appname` string,
`app_id` string,
`sku` string,
...
1
answers
0
votes
220
views
asked 15 days agolg...
Amazon QuickSightlg...
Hello everyone,
Please, I need help resolving the "No tables found" error![Quicksight](/media/postImages/original/IMTNgSk5_lQXOfIyIvOZs8og)
on Quicksight
I would appreciate it if anyone could guide...
2
answers
0
votes
291
views
asked 17 days agolg...
I have data that I collect from AWS Batch and CloudWatch. I made a lambda function that runs every day that collects those data daily and saves the result to S3. I have a folder called 'logs' and the...
0
answers
0
votes
654
views
asked 19 days agolg...
We have enabled the lake formation for some POC and we are unable to disable it and get default setting. The problem we have is if I create a db in athena and to create table in same database using...
1
answers
0
votes
154
views
asked 19 days agolg...
I'm experimenting with Amazon DataZone and encountered something unexpected. I have a simple setup with one AWS account and one DataZone domain, which includes:
1 Glue Table
1 S3 bucket with my...
1
answers
0
votes
310
views
asked 20 days agolg...
Do anyone know how to filter athena waf log from the last hour?
for example
`SELECT count(*) AS countRequests,httprequest.clientip, terminatingruleid, httprequest.uri
FROM "waf_logs"
WHERE
date...
Accepted AnswerAmazon Athena
2
answers
0
votes
105
views
asked 20 days agolg...
I wrote a python code that uploads data to S3 in csv format daily. I formatted the file name like this: 'some_data_YY_MM_DD.csv'. Using Athena, I want to query from the past 7 days of data.
1. Is...
3
answers
0
votes
684
views
asked 21 days agolg...
Facing the following error when using 2 jobs and 1 crawler:
Job 1: changing the schema and saving the csv file as parquet in S3.
Job 2: ETL Process
Crawler: Saving it in the AWs Glue Datacatalog...
1
answers
0
votes
616
views
asked 21 days agolg...
I have creat the grafana dashbaord ,but when i tying to use time series getting was showing Data is missing a number field .
Present iam using the python code i will update every minute new data to...
1
answers
0
votes
316
views
asked 22 days agolg...
Hello,
I am storing some AWS Batch and CloudWatch logs on S3 in CSV format. I wrote a python script that gets data for the past 24 hours. With this data, I am going to use Athena to grab the data in...
2
answers
0
votes
375
views
asked 25 days agolg...
Athena query failed with error:
```
Amazon Athena experienced an internal error while executing this query. Please try submitting the query again and if the issue reoccurs, contact AWS support for...
1
answers
0
votes
89
views
asked 25 days agolg...