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 hope this message finds you well. I'm reaching out because I require assistance with enabling embedding and anonymous access for the Amazon Grafana dashboard. My goal is to integrate the live Amazon...
1
answers
0
votes
183
views
asked a month agolg...
SELECT *
FROM tvseso_h
WHERE DATE(tvseso_h.call_creation_date) BETWEEN ? AND ?;
the call_creation_date datatype in source table is in TIMESTAMP and when i created the view as tvseso_h for the same...
1
answers
0
votes
95
views
asked a month agolg...
Hello, so I have my script that runs an Athena query and sends an email,
When I was testing in my machine in the terminal, running 'python3 name-file.py'. The script works fine, the query is run and...
0
answers
0
votes
131
views
asked a month agolg...
Hi I have created an external table on AWS Glue catalog db .
The table points to a lz4 compressed file on an s3.
the table definition looks like this
```
CREATE EXTERNAL TABLE `myapplogs`(
...
1
answers
0
votes
286
views
asked a month agolg...
Hi, I'm trying to build a quite complex query that runs on some views and if i get a couple of join it ends in this error
[HY000][100071] [Simba][AthenaJDBC](100071) An error has been thrown from the...
0
answers
0
votes
60
views
asked a month agolg...
GENERIC_INTERNAL_ERROR
This query ran against the "synergy_mysql_prod" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id:...
1
answers
0
votes
77
views
asked a month agolg...
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
60
views
asked a month 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
193
views
asked a month agolg...
When trying to add an Athena dataset (pointing to an Iceberg table on S3 created with Glue), I get the following error message:
![Error...
1
answers
0
votes
99
views
asked a month agolg...
Getting this while i am querying document db using lambda function using Athena for specific tables only
TYPE_NOT_FOUND: Unknown type: row
This query ran against the "sample" database, unless...
1
answers
0
votes
101
views
asked a month agolg...
Hi all,
Does anyone know if Athena supports a SPLIT function? Are the Athena functions available limited to only those on this page https://docs.aws.amazon.com/athena/latest/ug/functions.html or do...
Accepted AnswerAmazon Athena
1
answers
0
votes
144
views
asked a month agolg...
In java getting Error:
java.sql.SQLException: [Simba][AthenaJDBC](100123) An error has occurred. Exception during column initialization .Details: select columns from "schema"."table" where filter...
1
answers
0
votes
107
views
asked a month agolg...