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'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
154
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
170
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...
AWSTemplateFormatVersion: '2010-09-09'
Description: 'Creating QuickSight data source'
Resources:
QuickSightDataSource:
Type: AWS::QuickSight::DataSource
Properties:
AwsAccountId: !Ref...
0
answers
0
votes
120
views
asked 2 years agolg...