HIVE-14917: explainanalyze_2.q fails after HIVE-14861
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/18767237 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/18767237 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/18767237 Branch: refs/heads/master Commit: 1876723702bbad67a43f1ce80b4902c0c426b1ba Parents: 66f1f9b Author: Pengcheng Xiong <pxi...@apache.org> Authored: Mon Oct 10 10:07:40 2016 -0700 Committer: Pengcheng Xiong <pxi...@apache.org> Committed: Mon Oct 10 10:07:40 2016 -0700 ---------------------------------------------------------------------- .../queries/clientpositive/explainanalyze_2.q | 162 - .../clientpositive/tez/explainanalyze_2.q.out | 3706 +++--------------- 2 files changed, 562 insertions(+), 3306 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/18767237/ql/src/test/queries/clientpositive/explainanalyze_2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/explainanalyze_2.q b/ql/src/test/queries/clientpositive/explainanalyze_2.q index dfee826..8b3df87 100644 --- a/ql/src/test/queries/clientpositive/explainanalyze_2.q +++ b/ql/src/test/queries/clientpositive/explainanalyze_2.q @@ -1,140 +1,4 @@ set hive.explain.user=true; -set hive.metastore.aggregate.stats.cache.enabled=false; - --- SORT_QUERY_RESULTS - -CREATE TABLE dest_j1(key STRING, value STRING, val2 STRING) STORED AS TEXTFILE; - -CREATE TABLE ss(k1 STRING,v1 STRING,k2 STRING,v2 STRING,k3 STRING,v3 STRING) STORED AS TEXTFILE; - -CREATE TABLE sr(k1 STRING,v1 STRING,k2 STRING,v2 STRING,k3 STRING,v3 STRING) STORED AS TEXTFILE; - -CREATE TABLE cs(k1 STRING,v1 STRING,k2 STRING,v2 STRING,k3 STRING,v3 STRING) STORED AS TEXTFILE; - -INSERT OVERWRITE TABLE ss -SELECT x.key,x.value,y.key,y.value,z.key,z.value -FROM src1 x -JOIN src y ON (x.key = y.key) -JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11); - -INSERT OVERWRITE TABLE sr -SELECT x.key,x.value,y.key,y.value,z.key,z.value -FROM src1 x -JOIN src y ON (x.key = y.key) -JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=12); - -INSERT OVERWRITE TABLE cs -SELECT x.key,x.value,y.key,y.value,z.key,z.value -FROM src1 x -JOIN src y ON (x.key = y.key) -JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08'); - - -ANALYZE TABLE ss COMPUTE STATISTICS; -ANALYZE TABLE ss COMPUTE STATISTICS FOR COLUMNS k1,v1,k2,v2,k3,v3; - -ANALYZE TABLE sr COMPUTE STATISTICS; -ANALYZE TABLE sr COMPUTE STATISTICS FOR COLUMNS k1,v1,k2,v2,k3,v3; - -ANALYZE TABLE cs COMPUTE STATISTICS; -ANALYZE TABLE cs COMPUTE STATISTICS FOR COLUMNS k1,v1,k2,v2,k3,v3; - -set hive.auto.convert.join=false; - -explain analyze -SELECT x.key, z.value, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11); - -explain analyze -select -ss.k1,sr.k2,cs.k3,count(ss.v1),count(sr.v2),count(cs.v3) -FROM -ss,sr,cs,src d1,src d2,src d3,src1,srcpart -where - ss.k1 = d1.key -and sr.k1 = d2.key -and cs.k1 = d3.key -and ss.k2 = sr.k2 -and ss.k3 = sr.k3 -and ss.v1 = src1.value -and ss.v2 = srcpart.value -and sr.v2 = cs.v2 -and sr.v3 = cs.v3 -and ss.v3='ssv3' -and sr.v1='srv1' -and src1.key = 'src1key' -and srcpart.key = 'srcpartkey' -and d1.value = 'd1value' -and d2.value in ('2000Q1','2000Q2','2000Q3') -and d3.value in ('2000Q1','2000Q2','2000Q3') -group by -ss.k1,sr.k2,cs.k3 -order by -ss.k1,sr.k2,cs.k3 -limit 100; - -explain analyze -SELECT x.key, z.value, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN (select * from src1 union select * from src)z ON (x.value = z.value) -union -SELECT x.key, z.value, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN (select * from src1 union select * from src)z ON (x.value = z.value); - -explain analyze -SELECT x.key, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN (select * from src1 union select * from src)z ON (x.value = z.value) -union -SELECT x.key, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN (select key, value from src1 union select key, value from src union select key, value from src)z ON (x.value = z.value) -union -SELECT x.key, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN (select key, value from src1 union select key, value from src union select key, value from src union select key, value from src)z ON (x.value = z.value); - - -set hive.auto.convert.join=true; -set hive.auto.convert.join.noconditionaltask=true; -set hive.auto.convert.join.noconditionaltask.size=10000; -set hive.stats.fetch.column.stats=false; - - -explain analyze -SELECT x.key, z.value, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11); - -explain analyze -select -ss.k1,sr.k2,cs.k3,count(ss.v1),count(sr.v2),count(cs.v3) -FROM -ss,sr,cs,src d1,src d2,src d3,src1,srcpart -where - ss.k1 = d1.key -and sr.k1 = d2.key -and cs.k1 = d3.key -and ss.k2 = sr.k2 -and ss.k3 = sr.k3 -and ss.v1 = src1.value -and ss.v2 = srcpart.value -and sr.v2 = cs.v2 -and sr.v3 = cs.v3 -and ss.v3='ssv3' -and sr.v1='srv1' -and src1.key = 'src1key' -and srcpart.key = 'srcpartkey' -and d1.value = 'd1value' -and d2.value in ('2000Q1','2000Q2','2000Q3') -and d3.value in ('2000Q1','2000Q2','2000Q3') -group by -ss.k1,sr.k2,cs.k3 -order by -ss.k1,sr.k2,cs.k3 -limit 100; explain analyze SELECT x.key, z.value, y.value @@ -219,32 +83,6 @@ UNION ALL select s2.key as key, s2.value as value from tab s2 ) a join tab_part b on (a.key = b.key); -explain analyze -SELECT x.key, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN (select * from src1 union all select * from src)z ON (x.value = z.value) -union all -SELECT x.key, y.value -FROM src x JOIN src y ON (x.key = y.key) -JOIN (select key, value from src1 union all select key, value from src union all select key, value from src)z ON (x.value = z.value) -union all -SELECT x.key, y.value -FROM src1 x JOIN src1 y ON (x.key = y.key) -JOIN (select key, value from src1 union all select key, value from src union all select key, value from src union all select key, value from src)z ON (x.value = z.value); - -explain analyze -SELECT x.key, y.value -FROM src1 x JOIN src y ON (x.key = y.key) -JOIN (select * from src1 union select * from src)z ON (x.value = z.value) -union -SELECT x.key, y.value -FROM src x JOIN src y ON (x.key = y.key) -JOIN (select key, value from src1 union select key, value from src union select key, value from src)z ON (x.value = z.value) -union -SELECT x.key, y.value -FROM src1 x JOIN src1 y ON (x.key = y.key) -JOIN (select key, value from src1 union select key, value from src union select key, value from src union select key, value from src)z ON (x.value = z.value); - CREATE TABLE a(key STRING, value STRING) STORED AS TEXTFILE; CREATE TABLE b(key STRING, value STRING) STORED AS TEXTFILE; CREATE TABLE c(key STRING, value STRING) STORED AS TEXTFILE;