incubator-doris [Query] Questions about hash distribution prunner.

c9qzyr3d  于 2022-04-22  发布在  Java
关注(0)|答案(0)|浏览(155)

Describe the bug

  1. First to create a table with distribution key type DATE
create table tbl5 (k1 date, k2 int) distributed by hash(k1) buckets 3;
  1. Insert one row
insert into tbl5 values("2020-03-20", 1);
  1. Query like
select * from tbl5 where k1 = "2020-03-20";

This query will hit only bucket, which is expected.

And the following query:

select * from tbl5 where k1 = "2020-03-20 10:12:35";

Will also hit one bucket. Although it seems not results in wrong result.
But does it make sense?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题