You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by am...@apache.org on 2013/04/26 06:59:58 UTC
svn commit: r1476039 [20/22] - in /hive/branches/HIVE-4115: ./ beeline/
beeline/src/java/org/apache/hive/beeline/ bin/ builtins/ cli/
common/src/java/org/apache/hadoop/hive/conf/ conf/ data/files/
eclipse-templates/ hbase-handler/ hbase-handler/src/jav...
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing.q.out?rev=1476039&r1=1476038&r2=1476039&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing.q.out Fri Apr 26 04:59:50 2013
@@ -497,40 +497,40 @@ Manufacturer#5 almond aquamarine dodger
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 7672.66
PREHOOK: query: -- 11. testFirstLast
select p_mfgr,p_name, p_size,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2,
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2,
first_value(p_size) over w1 as f,
last_value(p_size, false) over w1 as l
from part
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 11. testFirstLast
select p_mfgr,p_name, p_size,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2,
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2,
first_value(p_size) over w1 as f,
last_value(p_size, false) over w1 as l
from part
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 2 2 2
-Manufacturer#1 almond antique chartreuse lavender yellow 34 34 2 6
-Manufacturer#1 almond antique burnished rose metallic 2 2 2 28
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 6 34 42
-Manufacturer#1 almond aquamarine burnished black steel 28 28 2 42
+Manufacturer#1 almond antique burnished rose metallic 2 2 2 34
+Manufacturer#1 almond antique burnished rose metallic 2 2 2 6
+Manufacturer#1 almond antique chartreuse lavender yellow 34 34 2 28
+Manufacturer#1 almond antique salmon chartreuse burlywood 6 6 2 42
+Manufacturer#1 almond aquamarine burnished black steel 28 28 34 42
Manufacturer#1 almond aquamarine pink moccasin thistle 42 42 6 42
Manufacturer#2 almond antique violet chocolate turquoise 14 14 14 2
Manufacturer#2 almond antique violet turquoise frosted 40 40 14 25
Manufacturer#2 almond aquamarine midnight light salmon 2 2 14 18
Manufacturer#2 almond aquamarine rose maroon antique 25 25 40 18
Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 18 2 18
-Manufacturer#3 almond antique metallic orange dim 19 19 19 14
-Manufacturer#3 almond antique chartreuse khaki white 17 17 19 1
-Manufacturer#3 almond antique forest lavender goldenrod 14 14 19 45
-Manufacturer#3 almond antique misty red olive 1 1 17 45
-Manufacturer#3 almond antique olive coral navajo 45 45 14 45
+Manufacturer#3 almond antique chartreuse khaki white 17 17 17 19
+Manufacturer#3 almond antique forest lavender goldenrod 14 14 17 1
+Manufacturer#3 almond antique metallic orange dim 19 19 17 45
+Manufacturer#3 almond antique misty red olive 1 1 14 45
+Manufacturer#3 almond antique olive coral navajo 45 45 19 45
Manufacturer#4 almond antique gainsboro frosted violet 10 10 10 27
Manufacturer#4 almond antique violet mint lemon 39 39 10 7
Manufacturer#4 almond aquamarine floral ivory bisque 27 27 10 12
@@ -543,67 +543,67 @@ Manufacturer#5 almond aquamarine dodger
Manufacturer#5 almond azure blanched chiffon midnight 23 23 2 23
PREHOOK: query: -- 12. testFirstLastWithWhere
select p_mfgr,p_name, p_size,
-rank() over(distribute by p_mfgr sort by p_mfgr) as r,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2,
+rank() over(distribute by p_mfgr sort by p_name) as r,
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2,
first_value(p_size) over w1 as f,
last_value(p_size, false) over w1 as l
from part
where p_mfgr = 'Manufacturer#3'
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 12. testFirstLastWithWhere
select p_mfgr,p_name, p_size,
-rank() over(distribute by p_mfgr sort by p_mfgr) as r,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2,
+rank() over(distribute by p_mfgr sort by p_name) as r,
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2,
first_value(p_size) over w1 as f,
last_value(p_size, false) over w1 as l
from part
where p_mfgr = 'Manufacturer#3'
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
Manufacturer#3 almond antique chartreuse khaki white 17 1 17 17 19
-Manufacturer#3 almond antique forest lavender goldenrod 14 1 14 17 1
-Manufacturer#3 almond antique metallic orange dim 19 1 19 17 45
-Manufacturer#3 almond antique misty red olive 1 1 1 14 45
-Manufacturer#3 almond antique olive coral navajo 45 1 45 19 45
+Manufacturer#3 almond antique forest lavender goldenrod 14 2 14 17 1
+Manufacturer#3 almond antique metallic orange dim 19 3 19 17 45
+Manufacturer#3 almond antique misty red olive 1 4 1 14 45
+Manufacturer#3 almond antique olive coral navajo 45 5 45 19 45
PREHOOK: query: -- 13. testSumWindow
select p_mfgr,p_name, p_size,
sum(p_size) over w1 as s1,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2
from part
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 13. testSumWindow
select p_mfgr,p_name, p_size,
sum(p_size) over w1 as s1,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr rows between current row and current row) as s2
+sum(p_size) over (distribute by p_mfgr sort by p_name rows between current row and current row) as s2
from part
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
Manufacturer#1 almond antique burnished rose metallic 2 38 2
-Manufacturer#1 almond antique chartreuse lavender yellow 34 44 34
-Manufacturer#1 almond antique burnished rose metallic 2 72 2
+Manufacturer#1 almond antique burnished rose metallic 2 44 2
+Manufacturer#1 almond antique chartreuse lavender yellow 34 72 34
Manufacturer#1 almond antique salmon chartreuse burlywood 6 112 6
-Manufacturer#1 almond aquamarine burnished black steel 28 78 28
+Manufacturer#1 almond aquamarine burnished black steel 28 110 28
Manufacturer#1 almond aquamarine pink moccasin thistle 42 76 42
Manufacturer#2 almond antique violet chocolate turquoise 14 56 14
Manufacturer#2 almond antique violet turquoise frosted 40 81 40
Manufacturer#2 almond aquamarine midnight light salmon 2 99 2
Manufacturer#2 almond aquamarine rose maroon antique 25 85 25
Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 45 18
-Manufacturer#3 almond antique metallic orange dim 19 50 19
-Manufacturer#3 almond antique chartreuse khaki white 17 51 17
-Manufacturer#3 almond antique forest lavender goldenrod 14 96 14
-Manufacturer#3 almond antique misty red olive 1 77 1
-Manufacturer#3 almond antique olive coral navajo 45 60 45
+Manufacturer#3 almond antique chartreuse khaki white 17 50 17
+Manufacturer#3 almond antique forest lavender goldenrod 14 51 14
+Manufacturer#3 almond antique metallic orange dim 19 96 19
+Manufacturer#3 almond antique misty red olive 1 79 1
+Manufacturer#3 almond antique olive coral navajo 45 65 45
Manufacturer#4 almond antique gainsboro frosted violet 10 76 10
Manufacturer#4 almond antique violet mint lemon 39 83 39
Manufacturer#4 almond aquamarine floral ivory bisque 27 95 27
@@ -616,58 +616,58 @@ Manufacturer#5 almond aquamarine dodger
Manufacturer#5 almond azure blanched chiffon midnight 23 71 23
PREHOOK: query: -- 14. testNoSortClause
select p_mfgr,p_name, p_size,
-rank() over(distribute by p_mfgr) as r, dense_rank() over(distribute by p_mfgr) as dr
+rank() over(distribute by p_mfgr sort by p_name) as r, dense_rank() over(distribute by p_mfgr sort by p_name) as dr
from part
-window w1 as (distribute by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 14. testNoSortClause
select p_mfgr,p_name, p_size,
-rank() over(distribute by p_mfgr) as r, dense_rank() over(distribute by p_mfgr) as dr
+rank() over(distribute by p_mfgr sort by p_name) as r, dense_rank() over(distribute by p_mfgr sort by p_name) as dr
from part
-window w1 as (distribute by p_mfgr rows between 2 preceding and 2 following)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
Manufacturer#1 almond antique burnished rose metallic 2 1 1
-Manufacturer#1 almond antique chartreuse lavender yellow 34 1 1
Manufacturer#1 almond antique burnished rose metallic 2 1 1
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 1 1
-Manufacturer#1 almond aquamarine burnished black steel 28 1 1
-Manufacturer#1 almond aquamarine pink moccasin thistle 42 1 1
+Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2
+Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3
+Manufacturer#1 almond aquamarine burnished black steel 28 5 4
+Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5
Manufacturer#2 almond antique violet chocolate turquoise 14 1 1
-Manufacturer#2 almond antique violet turquoise frosted 40 1 1
-Manufacturer#2 almond aquamarine midnight light salmon 2 1 1
-Manufacturer#2 almond aquamarine rose maroon antique 25 1 1
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 1 1
-Manufacturer#3 almond antique metallic orange dim 19 1 1
+Manufacturer#2 almond antique violet turquoise frosted 40 2 2
+Manufacturer#2 almond aquamarine midnight light salmon 2 3 3
+Manufacturer#2 almond aquamarine rose maroon antique 25 4 4
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5
Manufacturer#3 almond antique chartreuse khaki white 17 1 1
-Manufacturer#3 almond antique forest lavender goldenrod 14 1 1
-Manufacturer#3 almond antique misty red olive 1 1 1
-Manufacturer#3 almond antique olive coral navajo 45 1 1
+Manufacturer#3 almond antique forest lavender goldenrod 14 2 2
+Manufacturer#3 almond antique metallic orange dim 19 3 3
+Manufacturer#3 almond antique misty red olive 1 4 4
+Manufacturer#3 almond antique olive coral navajo 45 5 5
Manufacturer#4 almond antique gainsboro frosted violet 10 1 1
-Manufacturer#4 almond antique violet mint lemon 39 1 1
-Manufacturer#4 almond aquamarine floral ivory bisque 27 1 1
-Manufacturer#4 almond aquamarine yellow dodger mint 7 1 1
-Manufacturer#4 almond azure aquamarine papaya violet 12 1 1
+Manufacturer#4 almond antique violet mint lemon 39 2 2
+Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3
+Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4
+Manufacturer#4 almond azure aquamarine papaya violet 12 5 5
Manufacturer#5 almond antique blue firebrick mint 31 1 1
-Manufacturer#5 almond antique medium spring khaki 6 1 1
-Manufacturer#5 almond antique sky peru orange 2 1 1
-Manufacturer#5 almond aquamarine dodger light gainsboro 46 1 1
-Manufacturer#5 almond azure blanched chiffon midnight 23 1 1
+Manufacturer#5 almond antique medium spring khaki 6 2 2
+Manufacturer#5 almond antique sky peru orange 2 3 3
+Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4
+Manufacturer#5 almond azure blanched chiffon midnight 23 5 5
PREHOOK: query: -- 15. testExpressions
select p_mfgr,p_name, p_size,
-rank() over(distribute by p_mfgr sort by p_mfgr) as r,
-dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
-percent_rank() over(distribute by p_mfgr sort by p_mfgr) as pr,
-ntile(3) over(distribute by p_mfgr sort by p_mfgr) as nt,
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca,
-avg(p_size) over(distribute by p_mfgr sort by p_mfgr) as avg,
-stddev(p_size) over(distribute by p_mfgr sort by p_mfgr) as st,
-first_value(p_size % 5) over(distribute by p_mfgr sort by p_mfgr) as fv,
-last_value(p_size) over(distribute by p_mfgr sort by p_mfgr) as lv,
+rank() over(distribute by p_mfgr sort by p_name) as r,
+dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud,
+percent_rank() over(distribute by p_mfgr sort by p_name) as pr,
+ntile(3) over(distribute by p_mfgr sort by p_name) as nt,
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca,
+avg(p_size) over(distribute by p_mfgr sort by p_name) as avg,
+stddev(p_size) over(distribute by p_mfgr sort by p_name) as st,
+first_value(p_size % 5) over(distribute by p_mfgr sort by p_name) as fv,
+last_value(p_size) over(distribute by p_mfgr sort by p_name) as lv,
first_value(p_size) over w1 as fvW1
from part
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
@@ -676,54 +676,54 @@ PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 15. testExpressions
select p_mfgr,p_name, p_size,
-rank() over(distribute by p_mfgr sort by p_mfgr) as r,
-dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
-percent_rank() over(distribute by p_mfgr sort by p_mfgr) as pr,
-ntile(3) over(distribute by p_mfgr sort by p_mfgr) as nt,
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca,
-avg(p_size) over(distribute by p_mfgr sort by p_mfgr) as avg,
-stddev(p_size) over(distribute by p_mfgr sort by p_mfgr) as st,
-first_value(p_size % 5) over(distribute by p_mfgr sort by p_mfgr) as fv,
-last_value(p_size) over(distribute by p_mfgr sort by p_mfgr) as lv,
+rank() over(distribute by p_mfgr sort by p_name) as r,
+dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud,
+percent_rank() over(distribute by p_mfgr sort by p_name) as pr,
+ntile(3) over(distribute by p_mfgr sort by p_name) as nt,
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca,
+avg(p_size) over(distribute by p_mfgr sort by p_name) as avg,
+stddev(p_size) over(distribute by p_mfgr sort by p_name) as st,
+first_value(p_size % 5) over(distribute by p_mfgr sort by p_name) as fv,
+last_value(p_size) over(distribute by p_mfgr sort by p_name) as lv,
first_value(p_size) over w1 as fvW1
from part
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 1 1 1.0 0.0 2 6 19.0 16.237815945091466 2 42 2
-Manufacturer#1 almond antique burnished rose metallic 2 1 1 1.0 0.0 1 6 19.0 16.237815945091466 2 42 2
-Manufacturer#1 almond antique chartreuse lavender yellow 34 1 1 1.0 0.0 1 6 19.0 16.237815945091466 2 42 2
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 1 1 1.0 0.0 2 6 19.0 16.237815945091466 2 42 2
-Manufacturer#1 almond aquamarine burnished black steel 28 1 1 1.0 0.0 3 6 19.0 16.237815945091466 2 42 34
-Manufacturer#1 almond aquamarine pink moccasin thistle 42 1 1 1.0 0.0 3 6 19.0 16.237815945091466 2 42 6
-Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 1.0 0.0 1 5 19.8 12.560254774486067 4 18 14
-Manufacturer#2 almond antique violet turquoise frosted 40 1 1 1.0 0.0 1 5 19.8 12.560254774486067 4 18 14
-Manufacturer#2 almond aquamarine midnight light salmon 2 1 1 1.0 0.0 2 5 19.8 12.560254774486067 4 18 14
-Manufacturer#2 almond aquamarine rose maroon antique 25 1 1 1.0 0.0 2 5 19.8 12.560254774486067 4 18 40
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 1 1 1.0 0.0 3 5 19.8 12.560254774486067 4 18 2
-Manufacturer#3 almond antique chartreuse khaki white 17 1 1 1.0 0.0 1 5 19.2 14.344336861632886 4 45 17
-Manufacturer#3 almond antique forest lavender goldenrod 14 1 1 1.0 0.0 2 5 19.2 14.344336861632886 4 45 17
-Manufacturer#3 almond antique metallic orange dim 19 1 1 1.0 0.0 1 5 19.2 14.344336861632886 4 45 17
-Manufacturer#3 almond antique misty red olive 1 1 1 1.0 0.0 2 5 19.2 14.344336861632886 4 45 14
-Manufacturer#3 almond antique olive coral navajo 45 1 1 1.0 0.0 3 5 19.2 14.344336861632886 4 45 19
-Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 1.0 0.0 1 5 19.0 12.149074038789951 0 12 10
-Manufacturer#4 almond antique violet mint lemon 39 1 1 1.0 0.0 1 5 19.0 12.149074038789951 0 12 10
-Manufacturer#4 almond aquamarine floral ivory bisque 27 1 1 1.0 0.0 2 5 19.0 12.149074038789951 0 12 10
-Manufacturer#4 almond aquamarine yellow dodger mint 7 1 1 1.0 0.0 2 5 19.0 12.149074038789951 0 12 39
-Manufacturer#4 almond azure aquamarine papaya violet 12 1 1 1.0 0.0 3 5 19.0 12.149074038789951 0 12 27
-Manufacturer#5 almond antique blue firebrick mint 31 1 1 1.0 0.0 1 5 21.6 16.206171663906314 1 23 31
-Manufacturer#5 almond antique medium spring khaki 6 1 1 1.0 0.0 1 5 21.6 16.206171663906314 1 23 31
-Manufacturer#5 almond antique sky peru orange 2 1 1 1.0 0.0 2 5 21.6 16.206171663906314 1 23 31
-Manufacturer#5 almond aquamarine dodger light gainsboro 46 1 1 1.0 0.0 2 5 21.6 16.206171663906314 1 23 6
-Manufacturer#5 almond azure blanched chiffon midnight 23 1 1 1.0 0.0 3 5 21.6 16.206171663906314 1 23 2
+Manufacturer#1 almond antique burnished rose metallic 2 1 1 0.3333333333333333 0.0 1 2 2.0 0.0 2 2 2
+Manufacturer#1 almond antique burnished rose metallic 2 1 1 0.3333333333333333 0.0 1 2 2.0 0.0 2 2 2
+Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2 0.5 0.4 2 3 12.666666666666666 15.084944665313014 2 34 2
+Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3 0.6666666666666666 0.6 2 4 11.0 13.379088160259652 2 6 2
+Manufacturer#1 almond aquamarine burnished black steel 28 5 4 0.8333333333333334 0.8 3 5 14.4 13.763720427268202 2 28 34
+Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 1.0 1.0 3 6 19.0 16.237815945091466 2 42 6
+Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 0.2 0.0 1 1 14.0 0.0 4 14 14
+Manufacturer#2 almond antique violet turquoise frosted 40 2 2 0.4 0.25 1 2 27.0 13.0 4 40 14
+Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 0.6 0.5 2 3 18.666666666666668 15.86050300449376 4 2 14
+Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 0.8 0.75 2 4 20.25 14.00669482783144 4 25 40
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 1.0 1.0 3 5 19.8 12.560254774486067 4 18 2
+Manufacturer#3 almond antique chartreuse khaki white 17 1 1 0.2 0.0 1 1 17.0 0.0 2 17 17
+Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 0.4 0.25 1 2 15.5 1.5 2 14 17
+Manufacturer#3 almond antique metallic orange dim 19 3 3 0.6 0.5 2 3 16.666666666666668 2.0548046676563256 2 19 17
+Manufacturer#3 almond antique misty red olive 1 4 4 0.8 0.75 2 4 12.75 7.013380069552769 2 1 14
+Manufacturer#3 almond antique olive coral navajo 45 5 5 1.0 1.0 3 5 19.2 14.344336861632886 2 45 19
+Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 0.2 0.0 1 1 10.0 0.0 0 10 10
+Manufacturer#4 almond antique violet mint lemon 39 2 2 0.4 0.25 1 2 24.5 14.5 0 39 10
+Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 0.6 0.5 2 3 25.333333333333332 11.897712198383164 0 27 10
+Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 0.8 0.75 2 4 20.75 13.007209539328564 0 7 39
+Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 1.0 1.0 3 5 19.0 12.149074038789951 0 12 27
+Manufacturer#5 almond antique blue firebrick mint 31 1 1 0.2 0.0 1 1 31.0 0.0 1 31 31
+Manufacturer#5 almond antique medium spring khaki 6 2 2 0.4 0.25 1 2 18.5 12.5 1 6 31
+Manufacturer#5 almond antique sky peru orange 2 3 3 0.6 0.5 2 3 13.0 12.832251036613439 1 2 31
+Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 0.8 0.75 2 4 21.25 18.102140757380052 1 46 6
+Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 1.0 1.0 3 5 21.6 16.206171663906314 1 23 2
PREHOOK: query: -- 16. testMultipleWindows
select p_mfgr,p_name, p_size,
- rank() over(distribute by p_mfgr sort by p_mfgr) as r,
- dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr, p_name rows between unbounded preceding and current row) as s1,
+ rank() over(distribute by p_mfgr sort by p_name) as r,
+ dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud,
+sum(p_size) over (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) as s1,
sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2,
first_value(p_size) over w1 as fv1
from part
@@ -733,10 +733,10 @@ PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 16. testMultipleWindows
select p_mfgr,p_name, p_size,
- rank() over(distribute by p_mfgr sort by p_mfgr) as r,
- dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr, p_name rows between unbounded preceding and current row) as s1,
+ rank() over(distribute by p_mfgr sort by p_name) as r,
+ dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud,
+sum(p_size) over (distribute by p_mfgr sort by p_name range between unbounded preceding and current row) as s1,
sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2,
first_value(p_size) over w1 as fv1
from part
@@ -744,36 +744,36 @@ window w1 as (distribute by p_mfgr sort
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 1 1 1.0 4 4 2
-Manufacturer#1 almond antique burnished rose metallic 2 1 1 1.0 2 4 2
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 1 1 1.0 44 10 2
-Manufacturer#1 almond aquamarine burnished black steel 28 1 1 1.0 72 28 34
-Manufacturer#1 almond antique chartreuse lavender yellow 34 1 1 1.0 38 34 2
-Manufacturer#1 almond aquamarine pink moccasin thistle 42 1 1 1.0 114 42 6
-Manufacturer#2 almond aquamarine midnight light salmon 2 1 1 1.0 56 2 14
-Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 1.0 14 14 14
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 1 1 1.0 99 32 2
-Manufacturer#2 almond aquamarine rose maroon antique 25 1 1 1.0 81 25 40
-Manufacturer#2 almond antique violet turquoise frosted 40 1 1 1.0 54 40 14
-Manufacturer#3 almond antique misty red olive 1 1 1 1.0 51 1 14
-Manufacturer#3 almond antique forest lavender goldenrod 14 1 1 1.0 31 14 17
-Manufacturer#3 almond antique chartreuse khaki white 17 1 1 1.0 17 31 17
-Manufacturer#3 almond antique metallic orange dim 19 1 1 1.0 50 50 17
-Manufacturer#3 almond antique olive coral navajo 45 1 1 1.0 96 45 19
-Manufacturer#4 almond aquamarine yellow dodger mint 7 1 1 1.0 83 7 39
-Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 1.0 10 17 10
-Manufacturer#4 almond azure aquamarine papaya violet 12 1 1 1.0 95 29 27
-Manufacturer#4 almond aquamarine floral ivory bisque 27 1 1 1.0 76 27 10
-Manufacturer#4 almond antique violet mint lemon 39 1 1 1.0 49 39 10
-Manufacturer#5 almond antique sky peru orange 2 1 1 1.0 39 2 31
-Manufacturer#5 almond antique medium spring khaki 6 1 1 1.0 37 8 31
-Manufacturer#5 almond azure blanched chiffon midnight 23 1 1 1.0 108 23 2
-Manufacturer#5 almond antique blue firebrick mint 31 1 1 1.0 31 31 31
-Manufacturer#5 almond aquamarine dodger light gainsboro 46 1 1 1.0 85 46 6
+Manufacturer#1 almond antique burnished rose metallic 2 1 1 0.3333333333333333 4 4 2
+Manufacturer#1 almond antique burnished rose metallic 2 1 1 0.3333333333333333 4 4 2
+Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2 0.5 38 34 2
+Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3 0.6666666666666666 44 10 2
+Manufacturer#1 almond aquamarine burnished black steel 28 5 4 0.8333333333333334 72 28 34
+Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 1.0 114 42 6
+Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 0.2 14 14 14
+Manufacturer#2 almond antique violet turquoise frosted 40 2 2 0.4 54 40 14
+Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 0.6 56 2 14
+Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 0.8 81 25 40
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 1.0 99 32 2
+Manufacturer#3 almond antique chartreuse khaki white 17 1 1 0.2 17 31 17
+Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 0.4 31 14 17
+Manufacturer#3 almond antique metallic orange dim 19 3 3 0.6 50 50 17
+Manufacturer#3 almond antique misty red olive 1 4 4 0.8 51 1 14
+Manufacturer#3 almond antique olive coral navajo 45 5 5 1.0 96 45 19
+Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 0.2 10 17 10
+Manufacturer#4 almond antique violet mint lemon 39 2 2 0.4 49 39 10
+Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 0.6 76 27 10
+Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 0.8 83 7 39
+Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 1.0 95 29 27
+Manufacturer#5 almond antique blue firebrick mint 31 1 1 0.2 31 31 31
+Manufacturer#5 almond antique medium spring khaki 6 2 2 0.4 37 8 31
+Manufacturer#5 almond antique sky peru orange 2 3 3 0.6 39 2 31
+Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 0.8 85 46 6
+Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 1.0 108 23 2
PREHOOK: query: -- 17. testCountStar
select p_mfgr,p_name, p_size,
-count(*) over(distribute by p_mfgr sort by p_mfgr ) as c,
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca,
+count(*) over(distribute by p_mfgr sort by p_name ) as c,
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca,
first_value(p_size) over w1 as fvW1
from part
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
@@ -782,39 +782,39 @@ PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 17. testCountStar
select p_mfgr,p_name, p_size,
-count(*) over(distribute by p_mfgr sort by p_mfgr ) as c,
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca,
+count(*) over(distribute by p_mfgr sort by p_name ) as c,
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca,
first_value(p_size) over w1 as fvW1
from part
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 6 6 2
-Manufacturer#1 almond antique burnished rose metallic 2 6 6 2
-Manufacturer#1 almond antique chartreuse lavender yellow 34 6 6 2
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 6 6 2
-Manufacturer#1 almond aquamarine burnished black steel 28 6 6 34
+Manufacturer#1 almond antique burnished rose metallic 2 2 2 2
+Manufacturer#1 almond antique burnished rose metallic 2 2 2 2
+Manufacturer#1 almond antique chartreuse lavender yellow 34 3 3 2
+Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 4 2
+Manufacturer#1 almond aquamarine burnished black steel 28 5 5 34
Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 6 6
-Manufacturer#2 almond antique violet chocolate turquoise 14 5 5 14
-Manufacturer#2 almond antique violet turquoise frosted 40 5 5 14
-Manufacturer#2 almond aquamarine midnight light salmon 2 5 5 14
-Manufacturer#2 almond aquamarine rose maroon antique 25 5 5 40
+Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 14
+Manufacturer#2 almond antique violet turquoise frosted 40 2 2 14
+Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 14
+Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 40
Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 2
-Manufacturer#3 almond antique chartreuse khaki white 17 5 5 17
-Manufacturer#3 almond antique forest lavender goldenrod 14 5 5 17
-Manufacturer#3 almond antique metallic orange dim 19 5 5 17
-Manufacturer#3 almond antique misty red olive 1 5 5 14
+Manufacturer#3 almond antique chartreuse khaki white 17 1 1 17
+Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 17
+Manufacturer#3 almond antique metallic orange dim 19 3 3 17
+Manufacturer#3 almond antique misty red olive 1 4 4 14
Manufacturer#3 almond antique olive coral navajo 45 5 5 19
-Manufacturer#4 almond antique gainsboro frosted violet 10 5 5 10
-Manufacturer#4 almond antique violet mint lemon 39 5 5 10
-Manufacturer#4 almond aquamarine floral ivory bisque 27 5 5 10
-Manufacturer#4 almond aquamarine yellow dodger mint 7 5 5 39
+Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 10
+Manufacturer#4 almond antique violet mint lemon 39 2 2 10
+Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 10
+Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 39
Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 27
-Manufacturer#5 almond antique blue firebrick mint 31 5 5 31
-Manufacturer#5 almond antique medium spring khaki 6 5 5 31
-Manufacturer#5 almond antique sky peru orange 2 5 5 31
-Manufacturer#5 almond aquamarine dodger light gainsboro 46 5 5 6
+Manufacturer#5 almond antique blue firebrick mint 31 1 1 31
+Manufacturer#5 almond antique medium spring khaki 6 2 2 31
+Manufacturer#5 almond antique sky peru orange 2 3 3 31
+Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 2
PREHOOK: query: -- 18. testUDAFs
select p_mfgr,p_name, p_size,
@@ -969,7 +969,7 @@ PREHOOK: query: -- 21. testDISTs
select p_mfgr,p_name, p_size,
histogram_numeric(p_retailprice, 5) over w1 as hist,
percentile(p_partkey, 0.5) over w1 as per,
-row_number() over(distribute by p_mfgr sort by p_mfgr) as rn
+row_number() over(distribute by p_mfgr sort by p_name) as rn
from part
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
@@ -979,15 +979,15 @@ POSTHOOK: query: -- 21. testDISTs
select p_mfgr,p_name, p_size,
histogram_numeric(p_retailprice, 5) over w1 as hist,
percentile(p_partkey, 0.5) over w1 as per,
-row_number() over(distribute by p_mfgr sort by p_mfgr) as rn
+row_number() over(distribute by p_mfgr sort by p_name) as rn
from part
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 [{"x":1173.15,"y":2.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}] 115872.0 1
-Manufacturer#1 almond antique chartreuse lavender yellow 34 [{"x":1173.15,"y":2.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}] 110592.0 2
-Manufacturer#1 almond antique burnished rose metallic 2 [{"x":1173.15,"y":2.0},{"x":1753.76,"y":1.0}] 121152.0 3
+Manufacturer#1 almond antique burnished rose metallic 2 [{"x":1173.15,"y":2.0},{"x":1753.76,"y":1.0}] 121152.0 1
+Manufacturer#1 almond antique burnished rose metallic 2 [{"x":1173.15,"y":2.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}] 115872.0 2
+Manufacturer#1 almond antique chartreuse lavender yellow 34 [{"x":1173.15,"y":2.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1753.76,"y":1.0}] 110592.0 3
Manufacturer#1 almond antique salmon chartreuse burlywood 6 [{"x":1173.15,"y":1.0},{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0},{"x":1753.76,"y":1.0}] 86428.0 4
Manufacturer#1 almond aquamarine burnished black steel 28 [{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0},{"x":1753.76,"y":1.0}] 86098.0 5
Manufacturer#1 almond aquamarine pink moccasin thistle 42 [{"x":1414.42,"y":1.0},{"x":1602.59,"y":1.0},{"x":1632.66,"y":1.0}] 86428.0 6
@@ -996,9 +996,9 @@ Manufacturer#2 almond antique violet tur
Manufacturer#2 almond aquamarine midnight light salmon 2 [{"x":1690.68,"y":1.0},{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":1800.7,"y":1.0},{"x":2031.98,"y":1.0}] 146985.0 3
Manufacturer#2 almond aquamarine rose maroon antique 25 [{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":1800.7,"y":1.0},{"x":2031.98,"y":1.0}] 169347.0 4
Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 [{"x":1698.66,"y":1.0},{"x":1701.6,"y":1.0},{"x":2031.98,"y":1.0}] 146985.0 5
-Manufacturer#3 almond antique metallic orange dim 19 [{"x":1190.27,"y":1.0},{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}] 90681.0 1
-Manufacturer#3 almond antique chartreuse khaki white 17 [{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0}] 90681.0 2
-Manufacturer#3 almond antique forest lavender goldenrod 14 [{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}] 65831.5 3
+Manufacturer#3 almond antique chartreuse khaki white 17 [{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0}] 90681.0 1
+Manufacturer#3 almond antique forest lavender goldenrod 14 [{"x":1190.27,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}] 65831.5 2
+Manufacturer#3 almond antique metallic orange dim 19 [{"x":1190.27,"y":1.0},{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1671.68,"y":1.0},{"x":1922.98,"y":1.0}] 90681.0 3
Manufacturer#3 almond antique misty red olive 1 [{"x":1190.27,"y":1.0},{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1922.98,"y":1.0}] 76690.0 4
Manufacturer#3 almond antique olive coral navajo 45 [{"x":1337.29,"y":1.0},{"x":1410.39,"y":1.0},{"x":1922.98,"y":1.0}] 112398.0 5
Manufacturer#4 almond antique gainsboro frosted violet 10 [{"x":1206.26,"y":1.0},{"x":1375.42,"y":1.0},{"x":1620.67,"y":1.0}] 48427.0 1
@@ -1014,47 +1014,87 @@ Manufacturer#5 almond azure blanched chi
PREHOOK: query: -- 22. testViewAsTableInputWithWindowing
create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
-sum(p_retailprice) as s
+round(sum(p_retailprice),2) as s
from part
group by p_mfgr, p_brand
PREHOOK: type: CREATEVIEW
POSTHOOK: query: -- 22. testViewAsTableInputWithWindowing
create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
-sum(p_retailprice) as s
+round(sum(p_retailprice),2) as s
from part
group by p_mfgr, p_brand
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@mfgr_price_view
+PREHOOK: query: select *
+from (
+select p_mfgr, p_brand, s,
+round(sum(s),2) over w1 as s1
+from mfgr_price_view
+window w1 as (distribute by p_mfgr sort by p_mfgr )
+) sq
+order by p_mfgr, p_brand
+PREHOOK: type: QUERY
+PREHOOK: Input: default@mfgr_price_view
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: select *
+from (
+select p_mfgr, p_brand, s,
+round(sum(s),2) over w1 as s1
+from mfgr_price_view
+window w1 as (distribute by p_mfgr sort by p_mfgr )
+) sq
+order by p_mfgr, p_brand
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@mfgr_price_view
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+Manufacturer#1 Brand#12 4800.84 8749.73
+Manufacturer#1 Brand#14 2346.3 8749.73
+Manufacturer#1 Brand#15 1602.59 8749.73
+Manufacturer#2 Brand#22 3491.38 8923.62
+Manufacturer#2 Brand#23 2031.98 8923.62
+Manufacturer#2 Brand#24 1698.66 8923.62
+Manufacturer#2 Brand#25 1701.6 8923.62
+Manufacturer#3 Brand#31 1671.68 7532.61
+Manufacturer#3 Brand#32 3333.37 7532.61
+Manufacturer#3 Brand#34 1337.29 7532.61
+Manufacturer#3 Brand#35 1190.27 7532.61
+Manufacturer#4 Brand#41 4755.94 7337.62
+Manufacturer#4 Brand#42 2581.68 7337.62
+Manufacturer#5 Brand#51 1611.66 7672.66
+Manufacturer#5 Brand#52 3254.17 7672.66
+Manufacturer#5 Brand#53 2806.83 7672.66
PREHOOK: query: select p_mfgr, p_brand, s,
-sum(s) over w1 as s1
+round(sum(s),2) over w1 as s1
from mfgr_price_view
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_brand rows between 2 preceding and current row)
PREHOOK: type: QUERY
PREHOOK: Input: default@mfgr_price_view
PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: select p_mfgr, p_brand, s,
-sum(s) over w1 as s1
+round(sum(s),2) over w1 as s1
from mfgr_price_view
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_brand rows between 2 preceding and current row)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mfgr_price_view
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 Brand#14 2346.3 2346.3
-Manufacturer#1 Brand#12 4800.84 7147.14
+Manufacturer#1 Brand#12 4800.84 4800.84
+Manufacturer#1 Brand#14 2346.3 7147.14
Manufacturer#1 Brand#15 1602.59 8749.73
Manufacturer#2 Brand#22 3491.38 3491.38
-Manufacturer#2 Brand#23 2031.98 5523.360000000001
+Manufacturer#2 Brand#23 2031.98 5523.36
Manufacturer#2 Brand#24 1698.66 7222.02
Manufacturer#2 Brand#25 1701.6 5432.24
-Manufacturer#3 Brand#32 3333.37 3333.37
-Manufacturer#3 Brand#31 1671.68 5005.05
+Manufacturer#3 Brand#31 1671.68 1671.68
+Manufacturer#3 Brand#32 3333.37 5005.05
Manufacturer#3 Brand#34 1337.29 6342.34
-Manufacturer#3 Brand#35 1190.27 4199.24
-Manufacturer#4 Brand#41 4755.9400000000005 4755.9400000000005
-Manufacturer#4 Brand#42 2581.6800000000003 7337.620000000001
+Manufacturer#3 Brand#35 1190.27 5860.93
+Manufacturer#4 Brand#41 4755.94 4755.94
+Manufacturer#4 Brand#42 2581.68 7337.62
Manufacturer#5 Brand#51 1611.66 1611.66
Manufacturer#5 Brand#52 3254.17 4865.83
Manufacturer#5 Brand#53 2806.83 7672.66
@@ -1063,14 +1103,14 @@ create view IF NOT EXISTS mfgr_brand_pri
select p_mfgr, p_brand,
sum(p_retailprice) over w1 as s
from part
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
PREHOOK: type: CREATEVIEW
POSTHOOK: query: -- 23. testCreateViewWithWindowingQuery
create view IF NOT EXISTS mfgr_brand_price_view as
select p_mfgr, p_brand,
sum(p_retailprice) over w1 as s
from part
-window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@mfgr_brand_price_view
PREHOOK: query: select * from mfgr_brand_price_view
@@ -1084,21 +1124,21 @@ POSTHOOK: Input: default@mfgr_brand_pric
POSTHOOK: Input: default@part
#### A masked pattern was here ####
Manufacturer#1 Brand#14 1173.15
-Manufacturer#1 Brand#12 2926.91
-Manufacturer#1 Brand#14 4100.0599999999995
+Manufacturer#1 Brand#14 2346.3
+Manufacturer#1 Brand#12 4100.06
Manufacturer#1 Brand#15 4529.5
-Manufacturer#1 Brand#12 4190.16
+Manufacturer#1 Brand#12 4770.77
Manufacturer#1 Brand#12 4649.67
Manufacturer#2 Brand#22 1690.68
Manufacturer#2 Brand#22 3491.38
Manufacturer#2 Brand#23 5523.360000000001
Manufacturer#2 Brand#24 5531.34
Manufacturer#2 Brand#25 5432.24
-Manufacturer#3 Brand#32 1410.39
-Manufacturer#3 Brand#31 3082.07
-Manufacturer#3 Brand#35 4272.34
-Manufacturer#3 Brand#32 4784.93
-Manufacturer#3 Brand#34 4450.54
+Manufacturer#3 Brand#31 1671.68
+Manufacturer#3 Brand#35 2861.95
+Manufacturer#3 Brand#32 4272.34
+Manufacturer#3 Brand#32 4523.639999999999
+Manufacturer#3 Brand#34 4670.66
Manufacturer#4 Brand#41 1620.67
Manufacturer#4 Brand#42 2996.09
Manufacturer#4 Brand#42 4202.35
@@ -1114,7 +1154,7 @@ select p_mfgr, p_name,
lv_col, p_size, sum(p_size) over w1 as s
from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p
lateral view explode(arr) part_lv as lv_col
-window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_size, lv_col rows between 2 preceding and current row)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
@@ -1123,88 +1163,88 @@ select p_mfgr, p_name,
lv_col, p_size, sum(p_size) over w1 as s
from (select p_mfgr, p_name, p_size, array(1,2,3) arr from part) p
lateral view explode(arr) part_lv as lv_col
-window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
+window w1 as (distribute by p_mfgr sort by p_size, lv_col rows between 2 preceding and current row)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#1 almond antique burnished rose metallic 2 2 2
+Manufacturer#1 almond antique burnished rose metallic 1 2 2
Manufacturer#1 almond antique burnished rose metallic 1 2 4
-Manufacturer#1 almond antique burnished rose metallic 3 2 6
-Manufacturer#1 almond antique burnished rose metallic 1 2 6
+Manufacturer#1 almond antique burnished rose metallic 2 2 6
Manufacturer#1 almond antique burnished rose metallic 2 2 6
Manufacturer#1 almond antique burnished rose metallic 3 2 6
-Manufacturer#1 almond antique chartreuse lavender yellow 1 34 38
-Manufacturer#1 almond antique chartreuse lavender yellow 2 34 70
-Manufacturer#1 almond antique chartreuse lavender yellow 3 34 102
-Manufacturer#1 almond antique salmon chartreuse burlywood 1 6 74
-Manufacturer#1 almond antique salmon chartreuse burlywood 2 6 46
+Manufacturer#1 almond antique burnished rose metallic 3 2 6
+Manufacturer#1 almond antique salmon chartreuse burlywood 1 6 10
+Manufacturer#1 almond antique salmon chartreuse burlywood 2 6 14
Manufacturer#1 almond antique salmon chartreuse burlywood 3 6 18
Manufacturer#1 almond aquamarine burnished black steel 1 28 40
Manufacturer#1 almond aquamarine burnished black steel 2 28 62
Manufacturer#1 almond aquamarine burnished black steel 3 28 84
-Manufacturer#1 almond aquamarine pink moccasin thistle 1 42 98
-Manufacturer#1 almond aquamarine pink moccasin thistle 2 42 112
+Manufacturer#1 almond antique chartreuse lavender yellow 1 34 90
+Manufacturer#1 almond antique chartreuse lavender yellow 2 34 96
+Manufacturer#1 almond antique chartreuse lavender yellow 3 34 102
+Manufacturer#1 almond aquamarine pink moccasin thistle 1 42 110
+Manufacturer#1 almond aquamarine pink moccasin thistle 2 42 118
Manufacturer#1 almond aquamarine pink moccasin thistle 3 42 126
-Manufacturer#2 almond antique violet chocolate turquoise 2 14 14
-Manufacturer#2 almond antique violet chocolate turquoise 1 14 28
-Manufacturer#2 almond antique violet chocolate turquoise 3 14 42
-Manufacturer#2 almond antique violet turquoise frosted 1 40 68
-Manufacturer#2 almond antique violet turquoise frosted 2 40 94
-Manufacturer#2 almond antique violet turquoise frosted 3 40 120
-Manufacturer#2 almond aquamarine midnight light salmon 1 2 82
-Manufacturer#2 almond aquamarine midnight light salmon 2 2 44
+Manufacturer#2 almond aquamarine midnight light salmon 1 2 2
+Manufacturer#2 almond aquamarine midnight light salmon 2 2 4
Manufacturer#2 almond aquamarine midnight light salmon 3 2 6
-Manufacturer#2 almond aquamarine rose maroon antique 1 25 29
-Manufacturer#2 almond aquamarine rose maroon antique 2 25 52
-Manufacturer#2 almond aquamarine rose maroon antique 3 25 75
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 1 18 68
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 2 18 61
+Manufacturer#2 almond antique violet chocolate turquoise 1 14 18
+Manufacturer#2 almond antique violet chocolate turquoise 2 14 30
+Manufacturer#2 almond antique violet chocolate turquoise 3 14 42
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 1 18 46
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 2 18 50
Manufacturer#2 almond aquamarine sandy cyan gainsboro 3 18 54
-Manufacturer#3 almond antique chartreuse khaki white 1 17 17
-Manufacturer#3 almond antique chartreuse khaki white 2 17 34
-Manufacturer#3 almond antique chartreuse khaki white 3 17 51
-Manufacturer#3 almond antique forest lavender goldenrod 1 14 48
-Manufacturer#3 almond antique forest lavender goldenrod 2 14 45
+Manufacturer#2 almond aquamarine rose maroon antique 1 25 61
+Manufacturer#2 almond aquamarine rose maroon antique 2 25 68
+Manufacturer#2 almond aquamarine rose maroon antique 3 25 75
+Manufacturer#2 almond antique violet turquoise frosted 1 40 90
+Manufacturer#2 almond antique violet turquoise frosted 2 40 105
+Manufacturer#2 almond antique violet turquoise frosted 3 40 120
+Manufacturer#3 almond antique misty red olive 1 1 1
+Manufacturer#3 almond antique misty red olive 2 1 2
+Manufacturer#3 almond antique misty red olive 3 1 3
+Manufacturer#3 almond antique forest lavender goldenrod 1 14 16
+Manufacturer#3 almond antique forest lavender goldenrod 2 14 29
Manufacturer#3 almond antique forest lavender goldenrod 3 14 42
-Manufacturer#3 almond antique metallic orange dim 1 19 47
-Manufacturer#3 almond antique metallic orange dim 2 19 52
+Manufacturer#3 almond antique chartreuse khaki white 1 17 45
+Manufacturer#3 almond antique chartreuse khaki white 2 17 48
+Manufacturer#3 almond antique chartreuse khaki white 3 17 51
+Manufacturer#3 almond antique metallic orange dim 1 19 53
+Manufacturer#3 almond antique metallic orange dim 2 19 55
Manufacturer#3 almond antique metallic orange dim 3 19 57
-Manufacturer#3 almond antique misty red olive 1 1 39
-Manufacturer#3 almond antique misty red olive 2 1 21
-Manufacturer#3 almond antique misty red olive 3 1 3
-Manufacturer#3 almond antique olive coral navajo 1 45 47
-Manufacturer#3 almond antique olive coral navajo 2 45 91
+Manufacturer#3 almond antique olive coral navajo 1 45 83
+Manufacturer#3 almond antique olive coral navajo 2 45 109
Manufacturer#3 almond antique olive coral navajo 3 45 135
-Manufacturer#4 almond antique gainsboro frosted violet 1 10 10
-Manufacturer#4 almond antique gainsboro frosted violet 2 10 20
-Manufacturer#4 almond antique gainsboro frosted violet 3 10 30
-Manufacturer#4 almond antique violet mint lemon 1 39 59
-Manufacturer#4 almond antique violet mint lemon 2 39 88
-Manufacturer#4 almond antique violet mint lemon 3 39 117
-Manufacturer#4 almond aquamarine floral ivory bisque 1 27 105
-Manufacturer#4 almond aquamarine floral ivory bisque 2 27 93
-Manufacturer#4 almond aquamarine floral ivory bisque 3 27 81
-Manufacturer#4 almond aquamarine yellow dodger mint 1 7 61
-Manufacturer#4 almond aquamarine yellow dodger mint 2 7 41
+Manufacturer#4 almond aquamarine yellow dodger mint 1 7 7
+Manufacturer#4 almond aquamarine yellow dodger mint 2 7 14
Manufacturer#4 almond aquamarine yellow dodger mint 3 7 21
-Manufacturer#4 almond azure aquamarine papaya violet 1 12 26
-Manufacturer#4 almond azure aquamarine papaya violet 2 12 31
+Manufacturer#4 almond antique gainsboro frosted violet 1 10 24
+Manufacturer#4 almond antique gainsboro frosted violet 2 10 27
+Manufacturer#4 almond antique gainsboro frosted violet 3 10 30
+Manufacturer#4 almond azure aquamarine papaya violet 1 12 32
+Manufacturer#4 almond azure aquamarine papaya violet 2 12 34
Manufacturer#4 almond azure aquamarine papaya violet 3 12 36
-Manufacturer#5 almond antique blue firebrick mint 2 31 31
-Manufacturer#5 almond antique blue firebrick mint 1 31 62
-Manufacturer#5 almond antique blue firebrick mint 3 31 93
-Manufacturer#5 almond antique medium spring khaki 1 6 68
-Manufacturer#5 almond antique medium spring khaki 2 6 43
-Manufacturer#5 almond antique medium spring khaki 3 6 18
-Manufacturer#5 almond antique sky peru orange 2 2 14
-Manufacturer#5 almond antique sky peru orange 1 2 10
+Manufacturer#4 almond aquamarine floral ivory bisque 1 27 51
+Manufacturer#4 almond aquamarine floral ivory bisque 2 27 66
+Manufacturer#4 almond aquamarine floral ivory bisque 3 27 81
+Manufacturer#4 almond antique violet mint lemon 1 39 93
+Manufacturer#4 almond antique violet mint lemon 2 39 105
+Manufacturer#4 almond antique violet mint lemon 3 39 117
+Manufacturer#5 almond antique sky peru orange 1 2 2
+Manufacturer#5 almond antique sky peru orange 2 2 4
Manufacturer#5 almond antique sky peru orange 3 2 6
-Manufacturer#5 almond aquamarine dodger light gainsboro 1 46 50
-Manufacturer#5 almond aquamarine dodger light gainsboro 2 46 94
-Manufacturer#5 almond aquamarine dodger light gainsboro 3 46 138
-Manufacturer#5 almond azure blanched chiffon midnight 1 23 115
-Manufacturer#5 almond azure blanched chiffon midnight 2 23 92
+Manufacturer#5 almond antique medium spring khaki 1 6 10
+Manufacturer#5 almond antique medium spring khaki 2 6 14
+Manufacturer#5 almond antique medium spring khaki 3 6 18
+Manufacturer#5 almond azure blanched chiffon midnight 1 23 35
+Manufacturer#5 almond azure blanched chiffon midnight 2 23 52
Manufacturer#5 almond azure blanched chiffon midnight 3 23 69
+Manufacturer#5 almond antique blue firebrick mint 1 31 77
+Manufacturer#5 almond antique blue firebrick mint 2 31 85
+Manufacturer#5 almond antique blue firebrick mint 3 31 93
+Manufacturer#5 almond aquamarine dodger light gainsboro 1 46 108
+Manufacturer#5 almond aquamarine dodger light gainsboro 2 46 123
+Manufacturer#5 almond aquamarine dodger light gainsboro 3 46 138
PREHOOK: query: -- 25. testMultipleInserts3SWQs
CREATE TABLE part_1(
p_mfgr STRING,
@@ -1230,8 +1270,7 @@ p_name STRING,
p_size INT,
r INT,
dr INT,
-cud INT,
-s1 DOUBLE,
+cud INT,
s2 DOUBLE,
fv1 INT)
PREHOOK: type: CREATETABLE
@@ -1241,8 +1280,7 @@ p_name STRING,
p_size INT,
r INT,
dr INT,
-cud INT,
-s1 DOUBLE,
+cud INT,
s2 DOUBLE,
fv1 INT)
POSTHOOK: type: CREATETABLE
@@ -1272,17 +1310,16 @@ dense_rank() over(distribute by p_mfgr s
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s
INSERT OVERWRITE TABLE part_2
select p_mfgr,p_name, p_size,
-rank() over(distribute by p_mfgr sort by p_mfgr) as r,
-dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr, p_name rows between unbounded preceding and current row) as s1,
-sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2,
+rank() over(distribute by p_mfgr sort by p_name) as r,
+dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud,
+round(sum(p_size),1) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2,
first_value(p_size) over w1 as fv1
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
INSERT OVERWRITE TABLE part_3
select p_mfgr,p_name, p_size,
-count(*) over(distribute by p_mfgr sort by p_mfgr) as c,
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca,
+count(*) over(distribute by p_mfgr sort by p_name) as c,
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca,
first_value(p_size) over w1 as fv
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
PREHOOK: type: QUERY
@@ -1298,17 +1335,16 @@ dense_rank() over(distribute by p_mfgr s
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s
INSERT OVERWRITE TABLE part_2
select p_mfgr,p_name, p_size,
-rank() over(distribute by p_mfgr sort by p_mfgr) as r,
-dense_rank() over(distribute by p_mfgr sort by p_mfgr) as dr,
-cume_dist() over(distribute by p_mfgr sort by p_mfgr) as cud,
-sum(p_size) over (distribute by p_mfgr sort by p_mfgr, p_name rows between unbounded preceding and current row) as s1,
-sum(p_size) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2,
+rank() over(distribute by p_mfgr sort by p_name) as r,
+dense_rank() over(distribute by p_mfgr sort by p_name) as dr,
+cume_dist() over(distribute by p_mfgr sort by p_name) as cud,
+round(sum(p_size),1) over (distribute by p_mfgr sort by p_size range between 5 preceding and current row) as s2,
first_value(p_size) over w1 as fv1
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
INSERT OVERWRITE TABLE part_3
select p_mfgr,p_name, p_size,
-count(*) over(distribute by p_mfgr sort by p_mfgr) as c,
-count(p_size) over(distribute by p_mfgr sort by p_mfgr) as ca,
+count(*) over(distribute by p_mfgr sort by p_name) as c,
+count(p_size) over(distribute by p_mfgr sort by p_name) as ca,
first_value(p_size) over w1 as fv
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
@@ -1329,7 +1365,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT
POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.r SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: part_2.s1 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.s2 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.c SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.ca SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -1358,7 +1393,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT
POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.r SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: part_2.s1 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.s2 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.c SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.ca SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -1413,7 +1447,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT
POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.r SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: part_2.s1 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.s2 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.c SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.ca SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -1421,32 +1454,32 @@ POSTHOOK: Lineage: part_3.fv SCRIPT [(pa
POSTHOOK: Lineage: part_3.p_mfgr SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-Manufacturer#1 almond antique burnished rose metallic 2 1 1 1 4.0 4.0 2
-Manufacturer#1 almond antique burnished rose metallic 2 1 1 1 2.0 4.0 2
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 1 1 1 44.0 10.0 2
-Manufacturer#1 almond aquamarine burnished black steel 28 1 1 1 72.0 28.0 34
-Manufacturer#1 almond antique chartreuse lavender yellow 34 1 1 1 38.0 34.0 2
-Manufacturer#1 almond aquamarine pink moccasin thistle 42 1 1 1 114.0 42.0 6
-Manufacturer#2 almond aquamarine midnight light salmon 2 1 1 1 56.0 2.0 14
-Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 1 14.0 14.0 14
-Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 1 1 1 99.0 32.0 2
-Manufacturer#2 almond aquamarine rose maroon antique 25 1 1 1 81.0 25.0 40
-Manufacturer#2 almond antique violet turquoise frosted 40 1 1 1 54.0 40.0 14
-Manufacturer#3 almond antique misty red olive 1 1 1 1 51.0 1.0 14
-Manufacturer#3 almond antique forest lavender goldenrod 14 1 1 1 31.0 14.0 17
-Manufacturer#3 almond antique chartreuse khaki white 17 1 1 1 17.0 31.0 17
-Manufacturer#3 almond antique metallic orange dim 19 1 1 1 50.0 50.0 17
-Manufacturer#3 almond antique olive coral navajo 45 1 1 1 96.0 45.0 19
-Manufacturer#4 almond aquamarine yellow dodger mint 7 1 1 1 83.0 7.0 39
-Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 1 10.0 17.0 10
-Manufacturer#4 almond azure aquamarine papaya violet 12 1 1 1 95.0 29.0 27
-Manufacturer#4 almond aquamarine floral ivory bisque 27 1 1 1 76.0 27.0 10
-Manufacturer#4 almond antique violet mint lemon 39 1 1 1 49.0 39.0 10
-Manufacturer#5 almond antique sky peru orange 2 1 1 1 39.0 2.0 31
-Manufacturer#5 almond antique medium spring khaki 6 1 1 1 37.0 8.0 31
-Manufacturer#5 almond azure blanched chiffon midnight 23 1 1 1 108.0 23.0 2
-Manufacturer#5 almond antique blue firebrick mint 31 1 1 1 31.0 31.0 31
-Manufacturer#5 almond aquamarine dodger light gainsboro 46 1 1 1 85.0 46.0 6
+Manufacturer#1 almond antique burnished rose metallic 2 1 1 0 4.0 2
+Manufacturer#1 almond antique burnished rose metallic 2 1 1 0 4.0 2
+Manufacturer#1 almond antique chartreuse lavender yellow 34 3 2 0 34.0 2
+Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 3 0 10.0 2
+Manufacturer#1 almond aquamarine burnished black steel 28 5 4 0 28.0 34
+Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 5 1 42.0 6
+Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 0 14.0 14
+Manufacturer#2 almond antique violet turquoise frosted 40 2 2 0 40.0 14
+Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 0 2.0 14
+Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 0 25.0 40
+Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 1 32.0 2
+Manufacturer#3 almond antique chartreuse khaki white 17 1 1 0 31.0 17
+Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 0 14.0 17
+Manufacturer#3 almond antique metallic orange dim 19 3 3 0 50.0 17
+Manufacturer#3 almond antique misty red olive 1 4 4 0 1.0 14
+Manufacturer#3 almond antique olive coral navajo 45 5 5 1 45.0 19
+Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 0 17.0 10
+Manufacturer#4 almond antique violet mint lemon 39 2 2 0 39.0 10
+Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 0 27.0 10
+Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 0 7.0 39
+Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 1 29.0 27
+Manufacturer#5 almond antique blue firebrick mint 31 1 1 0 31.0 31
+Manufacturer#5 almond antique medium spring khaki 6 2 2 0 8.0 31
+Manufacturer#5 almond antique sky peru orange 2 3 3 0 2.0 31
+Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 0 46.0 6
+Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 1 23.0 2
PREHOOK: query: select * from part_3
PREHOOK: type: QUERY
PREHOOK: Input: default@part_3
@@ -1468,7 +1501,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT
POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.r SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: part_2.s1 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_2.s2 SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.c SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.ca SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
@@ -1476,31 +1508,31 @@ POSTHOOK: Lineage: part_3.fv SCRIPT [(pa
POSTHOOK: Lineage: part_3.p_mfgr SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: part_3.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-Manufacturer#1 almond antique burnished rose metallic 2 6 6 2
-Manufacturer#1 almond antique burnished rose metallic 2 6 6 2
-Manufacturer#1 almond antique chartreuse lavender yellow 34 6 6 2
-Manufacturer#1 almond antique salmon chartreuse burlywood 6 6 6 2
-Manufacturer#1 almond aquamarine burnished black steel 28 6 6 34
+Manufacturer#1 almond antique burnished rose metallic 2 2 2 2
+Manufacturer#1 almond antique burnished rose metallic 2 2 2 2
+Manufacturer#1 almond antique chartreuse lavender yellow 34 3 3 2
+Manufacturer#1 almond antique salmon chartreuse burlywood 6 4 4 2
+Manufacturer#1 almond aquamarine burnished black steel 28 5 5 34
Manufacturer#1 almond aquamarine pink moccasin thistle 42 6 6 6
-Manufacturer#2 almond antique violet chocolate turquoise 14 5 5 14
-Manufacturer#2 almond antique violet turquoise frosted 40 5 5 14
-Manufacturer#2 almond aquamarine midnight light salmon 2 5 5 14
-Manufacturer#2 almond aquamarine rose maroon antique 25 5 5 40
+Manufacturer#2 almond antique violet chocolate turquoise 14 1 1 14
+Manufacturer#2 almond antique violet turquoise frosted 40 2 2 14
+Manufacturer#2 almond aquamarine midnight light salmon 2 3 3 14
+Manufacturer#2 almond aquamarine rose maroon antique 25 4 4 40
Manufacturer#2 almond aquamarine sandy cyan gainsboro 18 5 5 2
-Manufacturer#3 almond antique chartreuse khaki white 17 5 5 17
-Manufacturer#3 almond antique forest lavender goldenrod 14 5 5 17
-Manufacturer#3 almond antique metallic orange dim 19 5 5 17
-Manufacturer#3 almond antique misty red olive 1 5 5 14
+Manufacturer#3 almond antique chartreuse khaki white 17 1 1 17
+Manufacturer#3 almond antique forest lavender goldenrod 14 2 2 17
+Manufacturer#3 almond antique metallic orange dim 19 3 3 17
+Manufacturer#3 almond antique misty red olive 1 4 4 14
Manufacturer#3 almond antique olive coral navajo 45 5 5 19
-Manufacturer#4 almond antique gainsboro frosted violet 10 5 5 10
-Manufacturer#4 almond antique violet mint lemon 39 5 5 10
-Manufacturer#4 almond aquamarine floral ivory bisque 27 5 5 10
-Manufacturer#4 almond aquamarine yellow dodger mint 7 5 5 39
+Manufacturer#4 almond antique gainsboro frosted violet 10 1 1 10
+Manufacturer#4 almond antique violet mint lemon 39 2 2 10
+Manufacturer#4 almond aquamarine floral ivory bisque 27 3 3 10
+Manufacturer#4 almond aquamarine yellow dodger mint 7 4 4 39
Manufacturer#4 almond azure aquamarine papaya violet 12 5 5 27
-Manufacturer#5 almond antique blue firebrick mint 31 5 5 31
-Manufacturer#5 almond antique medium spring khaki 6 5 5 31
-Manufacturer#5 almond antique sky peru orange 2 5 5 31
-Manufacturer#5 almond aquamarine dodger light gainsboro 46 5 5 6
+Manufacturer#5 almond antique blue firebrick mint 31 1 1 31
+Manufacturer#5 almond antique medium spring khaki 6 2 2 31
+Manufacturer#5 almond antique sky peru orange 2 3 3 31
+Manufacturer#5 almond aquamarine dodger light gainsboro 46 4 4 6
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 2
PREHOOK: query: -- 26. testGroupByHavingWithSWQAndAlias
select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
@@ -1537,7 +1569,6 @@ POSTHOOK: Lineage: part_2.p_mfgr SCRIPT
POSTHOOK: Lineage: part_2.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
[... 629 lines stripped ...]