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.
Hey everyone I am trying to query a set of JSON files in S3 with Athena and I am getting the Hive cursor error for invalid JSON even though the files in question are valid single-line JSON. Is there a...
2
answers
0
votes
81
views
asked 21 hours agolg...
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
97
views
asked 2 days 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
121
views
asked 3 days agolg...
HIVE_CANNOT_OPEN_SPLIT: Error opening Hive split...
1
answers
0
votes
203
views
asked 4 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
176
views
asked 8 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
170
views
asked 8 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
140
views
asked 8 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
199
views
asked 9 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
154
views
asked 9 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
192
views
asked 11 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
167
views
asked 11 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
256
views
asked 13 days agolg...