PREHOOK: query: DROP TABLE part
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE part
POSTHOOK: type: DROPTABLE
PREHOOK: query: -- data setup
CREATE TABLE part( 
    p_partkey INT,
    p_name STRING,
    p_mfgr STRING,
    p_brand STRING,
    p_type STRING,
    p_size INT,
    p_container STRING,
    p_retailprice DOUBLE,
    p_comment STRING
)
PREHOOK: type: CREATETABLE
POSTHOOK: query: -- data setup
CREATE TABLE part( 
    p_partkey INT,
    p_name STRING,
    p_mfgr STRING,
    p_brand STRING,
    p_type STRING,
    p_size INT,
    p_container STRING,
    p_retailprice DOUBLE,
    p_comment STRING
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
PREHOOK: Output: default@part
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
POSTHOOK: Output: default@part
PREHOOK: query: -- 1. testQueryLevelPartitionColsNotInSelect
select p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 1. testQueryLevelPartitionColsNotInSelect
select p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
from part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
2	1173.15
2	2346.3
34	4100.06
6	5702.650000000001
28	7117.070000000001
42	8749.730000000001
14	1690.68
40	3491.38
2	5523.360000000001
25	7222.02
18	8923.62
17	1671.68
14	2861.95
19	4272.34
1	6195.32
45	7532.61
10	1620.67
39	2996.09
27	4202.35
7	6047.27
12	7337.620000000001
31	1789.69
6	3401.3500000000004
2	5190.08
46	6208.18
23	7672.66
PREHOOK: query: -- 2. testWindowPartitionColsNotInSelect
select p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 2. testWindowPartitionColsNotInSelect
select p_size,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
from part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
2	1173.15
2	2346.3
34	4100.06
6	5702.650000000001
28	7117.070000000001
42	8749.730000000001
14	1690.68
40	3491.38
2	5523.360000000001
25	7222.02
18	8923.62
17	1671.68
14	2861.95
19	4272.34
1	6195.32
45	7532.61
10	1620.67
39	2996.09
27	4202.35
7	6047.27
12	7337.620000000001
31	1789.69
6	3401.3500000000004
2	5190.08
46	6208.18
23	7672.66
PREHOOK: query: -- 3. testHavingColNotInSelect
select p_mfgr,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
POSTHOOK: query: -- 3. testHavingColNotInSelect
select p_mfgr,
sum(p_retailprice) over (distribute by p_mfgr sort by p_name rows between unbounded preceding and current row) as s1
from part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
Manufacturer#1	1173.15
Manufacturer#1	2346.3
Manufacturer#1	4100.06
Manufacturer#1	5702.650000000001
Manufacturer#1	7117.070000000001
Manufacturer#1	8749.730000000001
Manufacturer#2	1690.68
Manufacturer#2	3491.38
Manufacturer#2	5523.360000000001
Manufacturer#2	7222.02
Manufacturer#2	8923.62
Manufacturer#3	1671.68
Manufacturer#3	2861.95
Manufacturer#3	4272.34
Manufacturer#3	6195.32
Manufacturer#3	7532.61
Manufacturer#4	1620.67
Manufacturer#4	2996.09
Manufacturer#4	4202.35
Manufacturer#4	6047.27
Manufacturer#4	7337.620000000001
Manufacturer#5	1789.69
Manufacturer#5	3401.3500000000004
Manufacturer#5	5190.08
Manufacturer#5	6208.18
Manufacturer#5	7672.66