AWS雅典娜：如何在特定分区上运行查询

发布于 2025-01-18 20:42:10 字数 489 浏览 1 评论 0原文

我预计“where”语句会减少查询处理量（3.71G）

SELECT  date_diff('day',current_timestamp,insert_time) 
FROM "accessagg"."access_agg" 
WHERE date_diff('day',current_timestamp,insert_time  ) <=2

我的表包含一个“Insert_time”列。该表没有分区，但据我所知，默认情况下所有现有列都已分区，并且没有选项可以按特定列创建分区。该表不是基于 S3 存储桶，我使用 Athena CREATE 查询创建了该表

那么如何减少处理？或按此列创建分区。

原文

I expected that the "where" statement will reduce the query processing amount (3.71G)

SELECT  date_diff('day',current_timestamp,insert_time) 
FROM "accessagg"."access_agg" 
WHERE date_diff('day',current_timestamp,insert_time  ) <=2

My table contains an "Insert_time" column.
The table is not partitioned but from my knowledge, all the existing columns are partitioned by default and there is no option to create a partition by a specific column.
This table is not based on S3 bucket, I created this table using the Athena CREATE query

So how can I reduce the processing? or create a partition by this column.

分享到QQ

分享到微博