Questions tagged with Amazon Athena
Start querying data instantly. Get results in seconds. Pay only for the queries you run.
Content language: English
Filter questions
Select tags to filter
Sort by
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
1255 results
Hi All,
Not able to add comment to Athena column if datatype is VARBINARY
This is what I tried
ALTER TABLE <schema>.<table_name> CHANGE COLUMN <col_name> <col_name> VARBINARY COMMENT '<comment_descri...
2
answers
0
votes
43
views
asked 8 days ago
Hello,
I keep getting this error when previewing data in an Athena dataset in Quick. Also tried custom SQL, same behavior. The exact same sql returnes results in Athena query editor so definately no ...
3
answers
0
votes
97
views
asked 2 months ago
CREATE TABLE statement cannot be generated because table has unsupported properties.
This query ran against the "blade_bronze_prod" database, unless qualified by the query. Please post the error messa...
According to the documentation at https://docs.aws.amazon.com/connect/latest/adminguide/data-type-definitions.html
agent_customer_hold_duration_ms – Total time spent by agents and customers on hold, ...
Hello, I'm having an issue deleting data from a specific S3 bucket using a DELETE FROM statement via a Boto3 Athena connection in a Lambda function (will be use to delete old data from an iceberg tabl...
1
answers
0
votes
86
views
asked 2 months ago
as anyone else seen `ICEBERG_CURSOR_ERROR: Failed to read Parquet file` from Athena engine v3 against Apache Iceberg tables managed by Amazon Security Lake (the OCSF v2.0 source tables in `amazon_secu...
2
answers
1
votes
169
views
asked 2 months ago
Hi,
I am using the **Athena Neptune connector** to query an **Amazon Neptune DB** graph from **Athena**.
Regular federated SQL queries against the Neptune-backed tables work correctly. For example, ...
2
answers
0
votes
138
views
asked 3 months ago
I'm trying to create an Iceberg table on S3 using Athena SQL console, and it is working fine if the table is not partitioned. But I want to create a partitioned table.
1. On using the create table sy...
2
answers
0
votes
100
views
asked 3 months ago
Seeking Guidance for JSON ingestion into AURORA?
======================================
I appreciate you looking over my query. This question pertains to the AWS AURORA environment, and I'm asking it...
2
answers
0
votes
94
views
asked 4 months ago
I'm experiencing a significant performance difference between two Athena tables that have identical partition projection configurations but were created differently.
**Setup**
I have two tables poin...
2
answers
0
votes
110
views
asked 4 months ago
The problems I'm having: s3 tables maintenance fails, cannot access s3 tables in Athena
s3 table maintenance fails: I make my s3 tables in a glue etl job, they show up in my s3 table bucket, but if i...
1
answers
0
votes
95
views
asked 5 months ago
Hi,
I'm trying to connect Power BI Desktop to Athena on a Windows ARM device (Surface Laptop). When I try to add a DSN in the ODBC Administrator, I immediately get:
"The setup routines for the Simba ...
1
answers
0
votes
149
views
asked 6 months ago