[ https://issues.apache.org/jira/browse/HIVE-20749?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gopal V updated HIVE-20749: --------------------------- Affects Version/s: 4.0.0 > Constraints: Null scan optimizer does not remove entire TableScan > ----------------------------------------------------------------- > > Key: HIVE-20749 > URL: https://issues.apache.org/jira/browse/HIVE-20749 > Project: Hive > Issue Type: Bug > Components: CBO, Logical Optimizer > Affects Versions: 4.0.0 > Reporter: Gopal V > Priority: Major > > With PK constraints on store table, the following query fails to remove the > entire join (and cut the query short). > {code} > explain select count(1) from store_sales, store where ss_store_sk = > s_store_sk and s_store_sk is null and ss_sold_date_sk between 2450816 and > 2450816+365; > {code} > Calcite generates the following optimized query, but the NullScan optimizer > does not kick in for the query. > {code} > SELECT COUNT(*) AS `$f0` > FROM (SELECT * > FROM (SELECT 0 AS `DUMMY` > FROM `tpcds_bin_partitioned_orc_10000`.`store_sales`) AS `t` > WHERE FALSE) AS `t0`, > (SELECT * > FROM (SELECT 0 AS `DUMMY` > FROM `tpcds_bin_partitioned_orc_10000`.`store`) AS `t1` > WHERE FALSE) AS `t2` > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)