PREHOOK: query: -- 1. testLeadUDAF select p_mfgr, p_retailprice, lead(p_retailprice) over (partition by p_mfgr order by p_name) as l1, lead(p_retailprice,1) over (partition by p_mfgr order by p_name) as l2, lead(p_retailprice,1,10) over (partition by p_mfgr order by p_name) as l3, lead(p_retailprice,1, p_retailprice) over (partition by p_mfgr order by p_name) as l4, p_retailprice - lead(p_retailprice,1,p_retailprice) over (partition by p_mfgr order by p_name) from part PREHOOK: type: QUERY PREHOOK: Input: default@part #### A masked pattern was here #### POSTHOOK: query: -- 1. testLeadUDAF select p_mfgr, p_retailprice, lead(p_retailprice) over (partition by p_mfgr order by p_name) as l1, lead(p_retailprice,1) over (partition by p_mfgr order by p_name) as l2, lead(p_retailprice,1,10) over (partition by p_mfgr order by p_name) as l3, lead(p_retailprice,1, p_retailprice) over (partition by p_mfgr order by p_name) as l4, p_retailprice - lead(p_retailprice,1,p_retailprice) over (partition by p_mfgr order by p_name) from part POSTHOOK: type: QUERY POSTHOOK: Input: default@part #### A masked pattern was here #### Manufacturer#1 1173.15 1173.15 1173.15 1173.15 1173.15 0.0 Manufacturer#1 1173.15 1753.76 1753.76 1753.76 1753.76 -580.6099999999999 Manufacturer#1 1753.76 1602.59 1602.59 1602.59 1602.59 151.17000000000007 Manufacturer#1 1602.59 1414.42 1414.42 1414.42 1414.42 188.16999999999985 Manufacturer#1 1414.42 1632.66 1632.66 1632.66 1632.66 -218.24 Manufacturer#1 1632.66 NULL NULL 10.0 1632.66 0.0 Manufacturer#2 1690.68 1800.7 1800.7 1800.7 1800.7 -110.01999999999998 Manufacturer#2 1800.7 2031.98 2031.98 2031.98 2031.98 -231.27999999999997 Manufacturer#2 2031.98 1698.66 1698.66 1698.66 1698.66 333.31999999999994 Manufacturer#2 1698.66 1701.6 1701.6 1701.6 1701.6 -2.939999999999827 Manufacturer#2 1701.6 NULL NULL 10.0 1701.6 0.0 Manufacturer#3 1671.68 1190.27 1190.27 1190.27 1190.27 481.4100000000001 Manufacturer#3 1190.27 1410.39 1410.39 1410.39 1410.39 -220.12000000000012 Manufacturer#3 1410.39 1922.98 1922.98 1922.98 1922.98 -512.5899999999999 Manufacturer#3 1922.98 1337.29 1337.29 1337.29 1337.29 585.69 Manufacturer#3 1337.29 NULL NULL 10.0 1337.29 0.0 Manufacturer#4 1620.67 1375.42 1375.42 1375.42 1375.42 245.25 Manufacturer#4 1375.42 1206.26 1206.26 1206.26 1206.26 169.16000000000008 Manufacturer#4 1206.26 1844.92 1844.92 1844.92 1844.92 -638.6600000000001 Manufacturer#4 1844.92 1290.35 1290.35 1290.35 1290.35 554.5700000000002 Manufacturer#4 1290.35 NULL NULL 10.0 1290.35 0.0 Manufacturer#5 1789.69 1611.66 1611.66 1611.66 1611.66 178.02999999999997 Manufacturer#5 1611.66 1788.73 1788.73 1788.73 1788.73 -177.06999999999994 Manufacturer#5 1788.73 1018.1 1018.1 1018.1 1018.1 770.63 Manufacturer#5 1018.1 1464.48 1464.48 1464.48 1464.48 -446.38 Manufacturer#5 1464.48 NULL NULL 10.0 1464.48 0.0 PREHOOK: query: -- 2.testLeadUDAFPartSz1 select p_mfgr, p_name, p_retailprice, lead(p_retailprice,1) over (partition by p_mfgr, p_name ), p_retailprice - lead(p_retailprice,1,p_retailprice) over (partition by p_mfgr, p_name) from part PREHOOK: type: QUERY PREHOOK: Input: default@part #### A masked pattern was here #### POSTHOOK: query: -- 2.testLeadUDAFPartSz1 select p_mfgr, p_name, p_retailprice, lead(p_retailprice,1) over (partition by p_mfgr, p_name ), p_retailprice - lead(p_retailprice,1,p_retailprice) over (partition by p_mfgr, p_name) from part POSTHOOK: type: QUERY POSTHOOK: Input: default@part #### A masked pattern was here #### Manufacturer#1 almond antique burnished rose metallic 1173.15 1173.15 0.0 Manufacturer#1 almond antique burnished rose metallic 1173.15 NULL 0.0 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 NULL 0.0 Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 NULL 0.0 Manufacturer#1 almond aquamarine burnished black steel 1414.42 NULL 0.0 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 NULL 0.0 Manufacturer#2 almond antique violet chocolate turquoise 1690.68 NULL 0.0 Manufacturer#2 almond antique violet turquoise frosted 1800.7 NULL 0.0 Manufacturer#2 almond aquamarine midnight light salmon 2031.98 NULL 0.0 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 NULL 0.0 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1701.6 NULL 0.0 Manufacturer#3 almond antique chartreuse khaki white 1671.68 NULL 0.0 Manufacturer#3 almond antique forest lavender goldenrod 1190.27 NULL 0.0 Manufacturer#3 almond antique metallic orange dim 1410.39 NULL 0.0 Manufacturer#3 almond antique misty red olive 1922.98 NULL 0.0 Manufacturer#3 almond antique olive coral navajo 1337.29 NULL 0.0 Manufacturer#4 almond antique gainsboro frosted violet 1620.67 NULL 0.0 Manufacturer#4 almond antique violet mint lemon 1375.42 NULL 0.0 Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 NULL 0.0 Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 NULL 0.0 Manufacturer#4 almond azure aquamarine papaya violet 1290.35 NULL 0.0 Manufacturer#5 almond antique blue firebrick mint 1789.69 NULL 0.0 Manufacturer#5 almond antique medium spring khaki 1611.66 NULL 0.0 Manufacturer#5 almond antique sky peru orange 1788.73 NULL 0.0 Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 NULL 0.0 Manufacturer#5 almond azure blanched chiffon midnight 1464.48 NULL 0.0 PREHOOK: query: -- 3.testLagUDAF select p_mfgr, p_retailprice, lag(p_retailprice,1) over (partition by p_mfgr order by p_name) as l1, lag(p_retailprice) over (partition by p_mfgr order by p_name) as l2, lag(p_retailprice,1, p_retailprice) over (partition by p_mfgr order by p_name) as l3, lag(p_retailprice,1,10) over (partition by p_mfgr order by p_name) as l4, p_retailprice - lag(p_retailprice,1,p_retailprice) over (partition by p_mfgr order by p_name) from part PREHOOK: type: QUERY PREHOOK: Input: default@part #### A masked pattern was here #### POSTHOOK: query: -- 3.testLagUDAF select p_mfgr, p_retailprice, lag(p_retailprice,1) over (partition by p_mfgr order by p_name) as l1, lag(p_retailprice) over (partition by p_mfgr order by p_name) as l2, lag(p_retailprice,1, p_retailprice) over (partition by p_mfgr order by p_name) as l3, lag(p_retailprice,1,10) over (partition by p_mfgr order by p_name) as l4, p_retailprice - lag(p_retailprice,1,p_retailprice) over (partition by p_mfgr order by p_name) from part POSTHOOK: type: QUERY POSTHOOK: Input: default@part #### A masked pattern was here #### Manufacturer#1 1173.15 NULL NULL 1173.15 10.0 0.0 Manufacturer#1 1173.15 1173.15 1173.15 1173.15 1173.15 0.0 Manufacturer#1 1753.76 1173.15 1173.15 1173.15 1173.15 580.6099999999999 Manufacturer#1 1602.59 1753.76 1753.76 1753.76 1753.76 -151.17000000000007 Manufacturer#1 1414.42 1602.59 1602.59 1602.59 1602.59 -188.16999999999985 Manufacturer#1 1632.66 1414.42 1414.42 1414.42 1414.42 218.24 Manufacturer#2 1690.68 NULL NULL 1690.68 10.0 0.0 Manufacturer#2 1800.7 1690.68 1690.68 1690.68 1690.68 110.01999999999998 Manufacturer#2 2031.98 1800.7 1800.7 1800.7 1800.7 231.27999999999997 Manufacturer#2 1698.66 2031.98 2031.98 2031.98 2031.98 -333.31999999999994 Manufacturer#2 1701.6 1698.66 1698.66 1698.66 1698.66 2.939999999999827 Manufacturer#3 1671.68 NULL NULL 1671.68 10.0 0.0 Manufacturer#3 1190.27 1671.68 1671.68 1671.68 1671.68 -481.4100000000001 Manufacturer#3 1410.39 1190.27 1190.27 1190.27 1190.27 220.12000000000012 Manufacturer#3 1922.98 1410.39 1410.39 1410.39 1410.39 512.5899999999999 Manufacturer#3 1337.29 1922.98 1922.98 1922.98 1922.98 -585.69 Manufacturer#4 1620.67 NULL NULL 1620.67 10.0 0.0 Manufacturer#4 1375.42 1620.67 1620.67 1620.67 1620.67 -245.25 Manufacturer#4 1206.26 1375.42 1375.42 1375.42 1375.42 -169.16000000000008 Manufacturer#4 1844.92 1206.26 1206.26 1206.26 1206.26 638.6600000000001 Manufacturer#4 1290.35 1844.92 1844.92 1844.92 1844.92 -554.5700000000002 Manufacturer#5 1789.69 NULL NULL 1789.69 10.0 0.0 Manufacturer#5 1611.66 1789.69 1789.69 1789.69 1789.69 -178.02999999999997 Manufacturer#5 1788.73 1611.66 1611.66 1611.66 1611.66 177.06999999999994 Manufacturer#5 1018.1 1788.73 1788.73 1788.73 1788.73 -770.63 Manufacturer#5 1464.48 1018.1 1018.1 1018.1 1018.1 446.38 PREHOOK: query: -- 4.testLagUDAFPartSz1 select p_mfgr, p_name, p_retailprice, lag(p_retailprice,1) over (partition by p_mfgr, p_name ), p_retailprice - lag(p_retailprice,1,p_retailprice) over (partition by p_mfgr, p_name) from part PREHOOK: type: QUERY PREHOOK: Input: default@part #### A masked pattern was here #### POSTHOOK: query: -- 4.testLagUDAFPartSz1 select p_mfgr, p_name, p_retailprice, lag(p_retailprice,1) over (partition by p_mfgr, p_name ), p_retailprice - lag(p_retailprice,1,p_retailprice) over (partition by p_mfgr, p_name) from part POSTHOOK: type: QUERY POSTHOOK: Input: default@part #### A masked pattern was here #### Manufacturer#1 almond antique burnished rose metallic 1173.15 NULL 0.0 Manufacturer#1 almond antique burnished rose metallic 1173.15 1173.15 0.0 Manufacturer#1 almond antique chartreuse lavender yellow 1753.76 NULL 0.0 Manufacturer#1 almond antique salmon chartreuse burlywood 1602.59 NULL 0.0 Manufacturer#1 almond aquamarine burnished black steel 1414.42 NULL 0.0 Manufacturer#1 almond aquamarine pink moccasin thistle 1632.66 NULL 0.0 Manufacturer#2 almond antique violet chocolate turquoise 1690.68 NULL 0.0 Manufacturer#2 almond antique violet turquoise frosted 1800.7 NULL 0.0 Manufacturer#2 almond aquamarine midnight light salmon 2031.98 NULL 0.0 Manufacturer#2 almond aquamarine rose maroon antique 1698.66 NULL 0.0 Manufacturer#2 almond aquamarine sandy cyan gainsboro 1701.6 NULL 0.0 Manufacturer#3 almond antique chartreuse khaki white 1671.68 NULL 0.0 Manufacturer#3 almond antique forest lavender goldenrod 1190.27 NULL 0.0 Manufacturer#3 almond antique metallic orange dim 1410.39 NULL 0.0 Manufacturer#3 almond antique misty red olive 1922.98 NULL 0.0 Manufacturer#3 almond antique olive coral navajo 1337.29 NULL 0.0 Manufacturer#4 almond antique gainsboro frosted violet 1620.67 NULL 0.0 Manufacturer#4 almond antique violet mint lemon 1375.42 NULL 0.0 Manufacturer#4 almond aquamarine floral ivory bisque 1206.26 NULL 0.0 Manufacturer#4 almond aquamarine yellow dodger mint 1844.92 NULL 0.0 Manufacturer#4 almond azure aquamarine papaya violet 1290.35 NULL 0.0 Manufacturer#5 almond antique blue firebrick mint 1789.69 NULL 0.0 Manufacturer#5 almond antique medium spring khaki 1611.66 NULL 0.0 Manufacturer#5 almond antique sky peru orange 1788.73 NULL 0.0 Manufacturer#5 almond aquamarine dodger light gainsboro 1018.1 NULL 0.0 Manufacturer#5 almond azure blanched chiffon midnight 1464.48 NULL 0.0 PREHOOK: query: -- 5.testLeadLagUDAF select p_mfgr, p_retailprice, lead(p_retailprice,1) over (partition by p_mfgr order by p_name) as l1, lead(p_retailprice,1, p_retailprice) over (partition by p_mfgr order by p_name) as l2, p_retailprice - lead(p_retailprice,1,p_retailprice) over (partition by p_mfgr order by p_name), lag(p_retailprice,1) over (partition by p_mfgr order by p_name) as l3, lag(p_retailprice,1, p_retailprice) over (partition by p_mfgr order by p_name) as l4 from part PREHOOK: type: QUERY PREHOOK: Input: default@part #### A masked pattern was here #### POSTHOOK: query: -- 5.testLeadLagUDAF select p_mfgr, p_retailprice, lead(p_retailprice,1) over (partition by p_mfgr order by p_name) as l1, lead(p_retailprice,1, p_retailprice) over (partition by p_mfgr order by p_name) as l2, p_retailprice - lead(p_retailprice,1,p_retailprice) over (partition by p_mfgr order by p_name), lag(p_retailprice,1) over (partition by p_mfgr order by p_name) as l3, lag(p_retailprice,1, p_retailprice) over (partition by p_mfgr order by p_name) as l4 from part POSTHOOK: type: QUERY POSTHOOK: Input: default@part #### A masked pattern was here #### Manufacturer#1 1173.15 1173.15 1173.15 0.0 NULL 1173.15 Manufacturer#1 1173.15 1753.76 1753.76 -580.6099999999999 1173.15 1173.15 Manufacturer#1 1753.76 1602.59 1602.59 151.17000000000007 1173.15 1173.15 Manufacturer#1 1602.59 1414.42 1414.42 188.16999999999985 1753.76 1753.76 Manufacturer#1 1414.42 1632.66 1632.66 -218.24 1602.59 1602.59 Manufacturer#1 1632.66 NULL 1632.66 0.0 1414.42 1414.42 Manufacturer#2 1690.68 1800.7 1800.7 -110.01999999999998 NULL 1690.68 Manufacturer#2 1800.7 2031.98 2031.98 -231.27999999999997 1690.68 1690.68 Manufacturer#2 2031.98 1698.66 1698.66 333.31999999999994 1800.7 1800.7 Manufacturer#2 1698.66 1701.6 1701.6 -2.939999999999827 2031.98 2031.98 Manufacturer#2 1701.6 NULL 1701.6 0.0 1698.66 1698.66 Manufacturer#3 1671.68 1190.27 1190.27 481.4100000000001 NULL 1671.68 Manufacturer#3 1190.27 1410.39 1410.39 -220.12000000000012 1671.68 1671.68 Manufacturer#3 1410.39 1922.98 1922.98 -512.5899999999999 1190.27 1190.27 Manufacturer#3 1922.98 1337.29 1337.29 585.69 1410.39 1410.39 Manufacturer#3 1337.29 NULL 1337.29 0.0 1922.98 1922.98 Manufacturer#4 1620.67 1375.42 1375.42 245.25 NULL 1620.67 Manufacturer#4 1375.42 1206.26 1206.26 169.16000000000008 1620.67 1620.67 Manufacturer#4 1206.26 1844.92 1844.92 -638.6600000000001 1375.42 1375.42 Manufacturer#4 1844.92 1290.35 1290.35 554.5700000000002 1206.26 1206.26 Manufacturer#4 1290.35 NULL 1290.35 0.0 1844.92 1844.92 Manufacturer#5 1789.69 1611.66 1611.66 178.02999999999997 NULL 1789.69 Manufacturer#5 1611.66 1788.73 1788.73 -177.06999999999994 1789.69 1789.69 Manufacturer#5 1788.73 1018.1 1018.1 770.63 1611.66 1611.66 Manufacturer#5 1018.1 1464.48 1464.48 -446.38 1788.73 1788.73 Manufacturer#5 1464.48 NULL 1464.48 0.0 1018.1 1018.1