--SORT_QUERY_RESULTS | |
set hive.explain.user=false; | |
-- partitioned table | |
create table daysales (customer int) partitioned by (dt string); | |
insert into daysales partition(dt='2001-01-01') values(1); | |
insert into daysales partition(dt='2001-01-03') values(1); | |
explain prepare pPart1 from select count(*) from daysales where dt=? and customer=?; | |
prepare pPart1 from select count(*) from daysales where dt=? and customer=?; | |
explain extended execute pPart1 using '2001-01-01',1; | |
execute pPart1 using '2001-01-01',1; | |