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.
Trying to create an Athena table with the following query
```
CREATE TABLE IF NOT EXISTS current_energy_rates
WITH (table_type = 'ICEBERG', format='PARQUET', location='s3://pr-energy-lookup',...
0
answers
0
votes
27
views
asked 2 days agolg...
Hello AWS Community,
I'm facing a challenging issue with our AWS data pipeline that affects data visualization in Amazon QuickSight. Initially, our setup involved directly importing CSV data from S3...
0
answers
0
votes
20
views
asked 3 days agolg...
Actually i uploaded one JSON file into my s3 bucket which is having nested JSON data. and, created Athena table out of it by using glue crawler. after that when i was trying to query the table i am...
0
answers
0
votes
320
views
asked 17 days agolg...
When excuting this sql in the AWS Management Console / Athena Query Editor
```
ALTER TABLE iceberg_table CHANGE COLUMN comment blog_comment string AFTER id
```
it should allow for...
0
answers
0
votes
157
views
asked 18 days agolg...
0
I'm encountering a NoSuchKey error while attempting to create an Athena Iceberg table using AWS Wrangler. Here's the anonymized error message:
{
"errorMessage": "GENERIC_INTERNAL_ERROR:...
0
answers
0
votes
226
views
asked 19 days agolg...
I have a service logs as below format
```
{"date":"2024-03-13T16:19:22.456430Z","stream":"stdout","log":"{\"level\":\"info\",\"message\":\"request arrived - method: GET url:...
0
answers
0
votes
527
views
asked a month agolg...
Currently I'm trying to get data source from Athena in AWS Grafana.
Under the section - Apps/AWS Data Sources/Data sources, I selected Service as 'Athena' and when i select the Regions as 'Asia...
0
answers
0
votes
371
views
asked a month agolg...
I have this table:
```
RetsIncomingTable:
Type: AWS::Glue::Table
Properties:
CatalogId: !Ref AWS::AccountId
DatabaseName: !Ref TheDatabase
TableInput:
Name:...
0
answers
0
votes
144
views
asked 2 months agolg...
I have an iceberg table defined like this:
CREATE TABLE IF NOT EXISTS staging (
id STRING,
staging_timestamp BIGINT,
... blah blah blah ...
)
PARTITIONED BY...
0
answers
0
votes
166
views
asked 2 months agolg...
hi all,
I am running my athena script, in athena console and got this error,
`GENERIC_INTERNAL_ERROR: io.airlift.bytecode.CompilationException: Error compiling class:...
0
answers
0
votes
113
views
asked 2 months agolg...
The files in the bucket have json arrays in a single line separated by comma like below:
[{"key" : 20}, {"key" : 30}, {"key" : 40}]
When i create table with this, only the first record is being...
0
answers
0
votes
109
views
asked 2 months agolg...
Hi all,
I want to protect the connection between Power BI and Amazon Athena. I gave the end users IAM credentials, so they can setup their DSN in their local machines and start creating reports in...
0
answers
0
votes
71
views
asked 2 months agolg...