Describe the bug
- First to create a table with distribution key type
DATE
create table tbl5 (k1 date, k2 int) distributed by hash(k1) buckets 3;
- Insert one row
insert into tbl5 values("2020-03-20", 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?
暂无答案!
目前还没有任何答案,快来回答吧!