Shohei Okumiya created HIVE-28207:
-------------------------------------
Summary: NullPointerException is thrown when checking column
uniqueness
Key: HIVE-28207
URL: https://issues.apache.org/jira/browse/HIVE-28207
Project: Hive
Issue Type: Bug
Components: CBO
Affects Versions: 4.0.0
Reporter: Shohei Okumiya
Assignee: Shohei Okumiya
In some cases, we skip checking null. For example, the last statement in the
following set of queries fails with NPE.
{code:java}
CREATE TABLE `store_sales` (`ss_item_sk` bigint);
CREATE TABLE `household_demographics` (`hd_demo_sk` bigint);
CREATE TABLE `item` (`i_item_sk` bigint);
ALTER TABLE `store_sales` ADD CONSTRAINT `pk_ss` PRIMARY KEY (`ss_item_sk`)
DISABLE NOVALIDATE RELY;
ALTER TABLE `item` ADD CONSTRAINT `pk_i` PRIMARY KEY (`i_item_sk`) DISABLE
NOVALIDATE RELY;
ALTER TABLE `store_sales` ADD CONSTRAINT `ss_i` FOREIGN KEY (`ss_item_sk`)
REFERENCES `item`(`i_item_sk`) DISABLE NOVALIDATE RELY;
EXPLAIN
SELECT i_item_sk
FROM store_sales, household_demographics, item
WHERE ss_item_sk = i_item_sk {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
