Unanswered 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 followed the instructions from https://docs.aws.amazon.com/athena/latest/ug/connect-to-a-data-source-lambda.html to set up the connection between Athena and snowflake. However I'm getting an error...
0
answers
0
votes
60
views
asked 2 years agolg...
I'm having trouble creating iceberg tables in Athena. I keep getting "Invalid S3 request" as an error message.
```
CREATE TABLE iceberg_test (
event_date timestamp,
log...
0
answers
0
votes
165
views
asked 2 years agolg...
Imagine if we have a time series values like this, lets say the timestamps are in epoch and device is emitting a payload every minute.
|timestamp| device| sensorName|...
0
answers
0
votes
168
views
asked 2 years agolg...
I am trying to create a view using a table have more than 5 billion rows.
using the following query:-
with
date_month as
(select distinct as_on_month from...
0
answers
0
votes
134
views
asked 2 years agolg...
[After resolving my first...
0
answers
0
votes
155
views
asked 2 years agolg...
[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error while executing this query.
0
answers
0
votes
169
views
asked 2 years agolg...
Anywhere i can get further context to this error? I can download this file and decode it with out issue using the same avro schema locally, i'm assuming i have not done something correctly in the...
0
answers
0
votes
171
views
asked 2 years agolg...
Athena and Analyticslg...
1. What is the best way to Create a subset of factory location data
Current process: Query location data for specific factories, save in a new Athena table with a direct insert statement
2. Get...
0
answers
0
votes
87
views
asked 2 years agolg...
This is the query I use in the view to put the string to date:
"date_parse"("ctr"."currentagentsnapshot"."agentstatus"."starttimestamp", '%Y-%m-%dT%H:%i:%sZ')...
0
answers
0
votes
174
views
asked 2 years agolg...
A crawler reported it created a table but the table is not visible in the Glue console under tables.
* I can see the table in Athena and when I query it data is returned as expected
* When I use the...
0
answers
1
votes
112
views
asked 2 years agolg...
getting this error from athena "HIVE_CURSOR_ERROR: java.lang.UnsupportedOperationException: The separator, quote, and escape characters must be different!". This error is showing up only for some...
0
answers
0
votes
100
views
asked 2 years agolg...
Hi,
I followed this article - https://aws.amazon.com/blogs/mt/how-to-query-your-aws-resource-configuration-states-using-aws-config-and-amazon-athena/
When I check the Lambda logs - It is trying to...
0
answers
0
votes
138
views
asked 2 years agolg...