[HIVE-24099] unix_timestamp,intersect,except throws NPE

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.1.0
• Component/s: CBO
• Assignee: Unassigned
• Reporter: zhaolong
• Created: 01/Sep/20 02:18
• Updated: 01/Sep/20 06:15
• Resolved: 01/Sep/20 06:15

Description

unix_timestamp,intersect,except throws NPE when cbo is false and optimize.constant.propagation is false

reproduced problems:
1. unix_timestap:
     set hive.cbo.enable=true;
     set hive.optimize.constant.propagation=false;
     create table test_pt(idx string, namex string) partitioned by(pt_dt string) stored as orc;

     explain extended select count(1) from test_pt where pt_dt = unix_timestamp();

2.intersect

create table t1(id int, name string, score int);

create table t2(id int, name string, score int);

insert into t1 values(1,'xiaoming', 98);

insert into t2 values(2,'xiaohong', 95);

select id from t1 intersect select id from t2;

3.except 

select id from t1 except select id from t2;