Skip to content

[Query] Questions about hash distribution prunner. #3185

@morningman

Description

@morningman

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?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions