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 an Iceberg Table which holds constant number of rows.
Every hour I update some of this rows using `MERGE` command.
After *each* `MERGE` I'm executing `VACUUM` command.
Table is created with...
1
answers
0
votes
581
views
asked 3 months agolg...
I have a partitioned table in athena based on
I query the data with this where clause
DATE(year || '-' || month || '-' || day) >= from_iso8601_timestamp('2024-03-18T00:00:00')
does it still make...
2
answers
0
votes
500
views
asked 3 months agolg...
Example s3://bucket1/mytable/ -- > east-2 bucket folder with same schema
s3://bucket2/mytable/ -- > west-2 bucket folder with same schema
can we create a single table from this two...
3
answers
0
votes
568
views
asked 3 months agolg...
# Error while running UNLOAD to PARQUET query using column names with spaces in
## Introduction
I have a table in Athena with the following column names ["column space 1", "column space 2"]. I...
1
answers
0
votes
650
views
asked 3 months agolg...
I managed to use glue crawler to crawled data (parquet file) from s3, however the column with type "boolean" is recognised as "string" when checking the data schema. Although i can edit the schema on...
1
answers
0
votes
595
views
asked 3 months agolg...
I have created a table using AWS Glue crawler and ran a test query:
![Enter image description here](/media/postImages/original/IMmKs6dOu3RR6uSv52EP_Wdw)
As you can see, the first row has the word...
2
answers
0
votes
593
views
asked 3 months agolg...
Querying CSV fileslg...
Hello,
I have CSV files stored in S3 buckets. I run a crawler that crawls in the bucket and creates tables according to the CSV files. When I run these tables in ATHENA AWS the tables are empty...
1
answers
0
votes
553
views
asked 3 months 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
554
views
asked 3 months agolg...
Hi AWS, I was querying Cost and Usage Reports (CURs) using Athena. By default a CloudFormation template gets created and it gets stored inside the bucket where the report is getting stored, however...
1
answers
0
votes
1025
views
asked 3 months agolg...
Is there any way around this?
```
SELECT * FROM event_data
JOIN event_index ON(
event_data.systemid = event_index.systemid AND
event_data.partition_day = event_index.partition_day)
limit...
2
answers
0
votes
548
views
asked 3 months agolg...
I have defined two tables:
```
CREATE EXTERNAL TABLE `event_data`(
`systemid` string COMMENT 'from deserializer',
`eventtime` string COMMENT 'from deserializer',
`eventtype` string COMMENT...
1
answers
0
votes
582
views
asked 3 months agolg...
When other AWS users are trying to access my bucket with their crawler, they are getting the below error.
"Crawler Error:
User does not have access to target s3://test-bucket-mis6389/evdata/"
My s3...
5
answers
0
votes
543
views
asked 3 months agolg...