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 have crawled the schema of my DynamoDB table using AWS Glue crawler and the table is now shown under the tables section in AWS Glue. However, the table is not being shown under Athena database...
1
answers
0
votes
267
views
asked 4 months agolg...
Query Timing Outlg...
I have a rather complex query that is timing out more than 50% of the time in Quicksight. Is there a way that AWS can prevent the time out without changing the query? I'm adding rows through the use...
1
answers
0
votes
176
views
asked 4 months agolg...
I have a table in Athena which has multiple arrays of structs within it, i.e.
`column:bigint
column2:double
column3:array:struct<
$id:bigint
subcolumn1:string>>
column4:array:struct<
$id:bigint
...
1
answers
0
votes
206
views
asked 4 months agolg...
I have a **Databricks** pipeline set up to create **Delta tables**, using **Glue Catalog as the Metastore**. I was able to query the Delta table via Athena successfully. However, starting from...
1
answers
0
votes
168
views
asked 4 months agolg...
Hi!
I have several thousand CloudWatch log files accumulated over the years and I have set up an Athena connection to query them.
Q: Is there a way to limit the query to - say the last month - so...
1
answers
0
votes
269
views
asked 4 months agolg...
I am trying to merge two iceberg tables using Athena but ran into error: "NOT_SUPPORTED: Iceberg table updates require at least format version 2". However, according to...
Accepted AnswerAmazon Athena
1
answers
0
votes
473
views
asked 4 months agolg...
When trying to insert data into an Athena/Iceberg table, using Java Athena JDBC Driver 3.0.0, getting error "Member must have length less than or equal to 1024".
# The table:
CREATE TABLE IF NOT...
0
answers
0
votes
213
views
asked 4 months agolg...
Getting below error while querying a Glue Table using Athena
com.amazonaws.services.s3.model.AmazonS3Exception: Access Denied (Service: Amazon S3; Status Code: 403; Error Code: AccessDenied; Request...
1
answers
0
votes
385
views
asked 4 months agolg...
![Reference table](/media/postImages/original/IMC_LZPd3JRsS-H1eO9mS9Fg)
Hello, I’ve a problem with the ordering generated by row_number, I have two STRING type columns (str_dt,str_ts) I need to order...
0
answers
0
votes
200
views
asked 4 months agolg...
Hi,
We send our database old data into S3 in this format:
{table}/year/month/day/asset_id.parquet
so we have a lot of files like...
1
answers
0
votes
379
views
asked 4 months agolg...
I am using below terraform script to create Athena Iceberg table,
resource "aws_glue_catalog_table" "athena_threshold_table" {
name = "my_config_table"
database_name =...
1
answers
0
votes
358
views
asked 4 months agolg...
I have json-per-line files in S3 that look like this:
{ "eventTimestamp": "...", "eventType": "...", "eventPayload": { complex object of unknown schema } }
How can I define an Athena table that...
1
answers
0
votes
463
views
asked 4 months agolg...