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.
Hello,
I've enabled the AWS WAF service in my project. I've also set the rule action of HostingProviderIPList Rule in AWSManagedRulesAnonymousIpList
as "Challenge." After analyzing the WAF logs from...
1
answers
0
votes
76
views
asked a day agolg...
I've got a fairly simple ETL job that reads several catalog tables or views and does some joins. the job errors out with the following error:
```
Error Category: UNCLASSIFIED_ERROR; An error...
0
answers
0
votes
58
views
asked 2 days agolg...
HIVE_CANNOT_OPEN_SPLIT: Error opening Hive split...
1
answers
0
votes
144
views
asked 3 days agolg...
I have csv files stored in S3. The files are named as followed: {region name}_{today's date}.csv. There are multiple regions. These files are saved under 'log/year/month/date' directory. So this...
1
answers
0
votes
118
views
asked 7 days agolg...
I have Excel sheets with multiple sheets on it stored in S3. Currently, I have separate csv files for each sheet, and crawling from each csv files. Instead of doing this, I would like to crawl from...
1
answers
0
votes
111
views
asked 7 days agolg...
Hi All,
Relatively new to the AWS world. I have a requirement where i have some sensitive files in s3 that i want users to only have read access (no download, no s3 query select). On the other end I...
1
answers
0
votes
84
views
asked 7 days agolg...
I am keeping track of some data, based on the date on S3. The files are stored in directories like this: year=yyyy/month=mm/day=dd and inside this directory, there are multiple csv files. I want a...
1
answers
0
votes
141
views
asked 8 days agolg...
From the AWS documentation (https://docs.aws.amazon.com/athena/latest/ug/connectors-bigquery.html#connectors-bigquery-passthrough-queries), it says that I can use something like:
SELECT * FROM...
1
answers
0
votes
95
views
asked 8 days agolg...
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
136
views
asked 10 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
105
views
asked 10 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
196
views
asked 12 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
643
views
asked 14 days agolg...