[GitHub] [incubator-doris] qzsee commented on issue #9034: [Bug] The is-null predicate in the where statement cannot be pushed down to the storage layer

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

qzsee commented on issue #9034:
URL: https://github.com/apache/incubator-doris/issues/9034#issuecomment-1099987525

   > Can you please give the create table stmt of `tbla`, Thank you.
   
   CREATE TABLE `tbla` (
     `dt` int(11) NULL,
     `k1` int(11) NULL,
     `k2` bigint(20) NULL,
     `k3` bigint(20) NULL,
     `k4` bigint(20) NULL,
     `k5` bigint(20) NULL,
     `k6` bigint(20) NULL,
     `k7` bigint(20) NULL,
     `k8` bigint(20) NULL,
     `k9` bigint(20) NULL,
     `k10` bigint(20) NULL,
     `k11` bigint(20) NULL,
     `k12` bigint(20) NULL,
     `k13` bigint(20) NULL,
     `k14` bigint(20) NULL,
     `k15` bigint(20) NULL,
     `k16` varchar(128) NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`, `k6`)
   PARTITION BY RANGE(`k1`)
   (PARTITION p20220410 VALUES [("20220409"), ("20220410")),
   PARTITION p20220411 VALUES [("20220410"), ("20220411")),
   PARTITION p20220412 VALUES [("20220411"), ("20220412")))
   DISTRIBUTED BY HASH(`k3`) BUCKETS 5
   PROPERTIES (
   "replication_num" = "3",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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