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 using [Athena JDBC driver 3.2](https://docs.aws.amazon.com/athena/latest/ug/jdbc-v3-driver.html) (uberjar) to execute queries in clojure. Queries that I execute produce expected results, but also...
0
answers
0
votes
24
views
asked 12 hours agolg...
I am trying to use the DATEADD function, but I encountered an issue. I am querying an S3 database using Athena. Do I need to store the data in Redshift to use the DATEADD function? Any guidance would...
1
answers
0
votes
32
views
asked a day agolg...
Why this error in table query of Athena INVALID_TABLE_PROPERTY: Must provide a range to build a projected temporal partition column! (property: projection.datehour.range)
This query ran against the...
1
answers
0
votes
138
views
asked 3 days agolg...
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
157
views
asked 5 days 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
142
views
asked 6 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
185
views
asked 7 days agolg...
HIVE_CANNOT_OPEN_SPLIT: Error opening Hive split...
1
answers
0
votes
271
views
asked 8 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
239
views
asked 12 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
227
views
asked 12 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
189
views
asked 12 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
260
views
asked 13 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
211
views
asked 13 days agolg...