[GitHub] [incubator-doris] morningman opened a new issue #3185: [Query] Questions about hash distribution prunner.

[GitBox <gi...@apache.org>]

morningman opened a new issue #3185: [Query] Questions about hash distribution prunner.
URL: https://github.com/apache/incubator-doris/issues/3185
 
 
   **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;
   ```
   
   2. Insert one row
   ```
   insert into tbl5 values("2020-03-20", 1);
   ```
   
   3. 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?

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org