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.
Hi Aws team,
Getting error after running query and selecting default table also. Any solution.
![Enter image description here](/media/postImages/original/IM5LqYwCEAQcGJZ1hR2mxMHQ)
2
answers
0
votes
481
views
asked 3 months agolg...
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
582
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
506
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
570
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
651
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
598
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
595
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
555
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
561
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
1026
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
550
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
584
views
asked 3 months agolg...