PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_1_n0
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_1_n0
POSTHOOK: type: DROPTABLE
PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_2_n0
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_2_n0
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE DECIMAL_4_1_n0(key decimal(35,25), value int) 
ROW FORMAT DELIMITED
   FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@DECIMAL_4_1_n0
POSTHOOK: query: CREATE TABLE DECIMAL_4_1_n0(key decimal(35,25), value int) 
ROW FORMAT DELIMITED
   FIELDS TERMINATED BY ' '
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DECIMAL_4_1_n0
PREHOOK: query: CREATE TABLE DECIMAL_4_2_n0(key decimal(35,25), value decimal(35,25)) 
STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@DECIMAL_4_2_n0
POSTHOOK: query: CREATE TABLE DECIMAL_4_2_n0(key decimal(35,25), value decimal(35,25)) 
STORED AS ORC
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@DECIMAL_4_2_n0
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_4_1_n0
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@decimal_4_1_n0
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_4_1_n0
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@decimal_4_1_n0
PREHOOK: query: INSERT OVERWRITE TABLE DECIMAL_4_2_n0 SELECT key, key * 3 FROM DECIMAL_4_1_n0
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_4_1_n0
PREHOOK: Output: default@decimal_4_2_n0
POSTHOOK: query: INSERT OVERWRITE TABLE DECIMAL_4_2_n0 SELECT key, key * 3 FROM DECIMAL_4_1_n0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_1_n0
POSTHOOK: Output: default@decimal_4_2_n0
POSTHOOK: Lineage: decimal_4_2_n0.key SIMPLE [(decimal_4_1_n0)decimal_4_1_n0.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
POSTHOOK: Lineage: decimal_4_2_n0.value EXPRESSION [(decimal_4_1_n0)decimal_4_1_n0.FieldSchema(name:key, type:decimal(35,25), comment:null), ]
PREHOOK: query: SELECT * FROM DECIMAL_4_1_n0 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_4_1_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM DECIMAL_4_1_n0 ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_1_n0
#### A masked pattern was here ####
-1234567890.1234567890000000000000000	-1234567890
-4400.0000000000000000000000000	4400
-1255.4900000000000000000000000	-1255
-1.1220000000000000000000000	-11
-1.1200000000000000000000000	-1
-1.1200000000000000000000000	-1
-0.3330000000000000000000000	0
-0.3300000000000000000000000	0
-0.3000000000000000000000000	0
0.0000000000000000000000000	0
0.0000000000000000000000000	0
0.0000000000000000000000000	0
0.0100000000000000000000000	0
0.0200000000000000000000000	0
0.1000000000000000000000000	0
0.2000000000000000000000000	0
0.3000000000000000000000000	0
0.3300000000000000000000000	0
0.3330000000000000000000000	0
0.9999999999999999999999999	1
1.0000000000000000000000000	1
1.0000000000000000000000000	1
1.1200000000000000000000000	1
1.1220000000000000000000000	1
2.0000000000000000000000000	2
2.0000000000000000000000000	2
3.1400000000000000000000000	3
3.1400000000000000000000000	3
3.1400000000000000000000000	3
3.1400000000000000000000000	4
10.0000000000000000000000000	10
20.0000000000000000000000000	20
100.0000000000000000000000000	100
124.0000000000000000000000000	124
125.2000000000000000000000000	125
200.0000000000000000000000000	200
1234567890.1234567800000000000000000	1234567890
NULL	0
PREHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_4_2_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_2_n0
#### A masked pattern was here ####
-1234567890.1234567890000000000000000	-3703703670.3703703670000000000000000
-4400.0000000000000000000000000	-13200.0000000000000000000000000
-1255.4900000000000000000000000	-3766.4700000000000000000000000
-1.1220000000000000000000000	-3.3660000000000000000000000
-1.1200000000000000000000000	-3.3600000000000000000000000
-1.1200000000000000000000000	-3.3600000000000000000000000
-0.3330000000000000000000000	-0.9990000000000000000000000
-0.3300000000000000000000000	-0.9900000000000000000000000
-0.3000000000000000000000000	-0.9000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0100000000000000000000000	0.0300000000000000000000000
0.0200000000000000000000000	0.0600000000000000000000000
0.1000000000000000000000000	0.3000000000000000000000000
0.2000000000000000000000000	0.6000000000000000000000000
0.3000000000000000000000000	0.9000000000000000000000000
0.3300000000000000000000000	0.9900000000000000000000000
0.3330000000000000000000000	0.9990000000000000000000000
0.9999999999999999999999999	2.9999999999999999999999997
1.0000000000000000000000000	3.0000000000000000000000000
1.0000000000000000000000000	3.0000000000000000000000000
1.1200000000000000000000000	3.3600000000000000000000000
1.1220000000000000000000000	3.3660000000000000000000000
2.0000000000000000000000000	6.0000000000000000000000000
2.0000000000000000000000000	6.0000000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
10.0000000000000000000000000	30.0000000000000000000000000
20.0000000000000000000000000	60.0000000000000000000000000
100.0000000000000000000000000	300.0000000000000000000000000
124.0000000000000000000000000	372.0000000000000000000000000
125.2000000000000000000000000	375.6000000000000000000000000
200.0000000000000000000000000	600.0000000000000000000000000
1234567890.1234567800000000000000000	3703703670.3703703400000000000000000
NULL	NULL
PREHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_4_2_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_2_n0
#### A masked pattern was here ####
-1234567890.1234567890000000000000000	-3703703670.3703703670000000000000000
-4400.0000000000000000000000000	-13200.0000000000000000000000000
-1255.4900000000000000000000000	-3766.4700000000000000000000000
-1.1220000000000000000000000	-3.3660000000000000000000000
-1.1200000000000000000000000	-3.3600000000000000000000000
-1.1200000000000000000000000	-3.3600000000000000000000000
-0.3330000000000000000000000	-0.9990000000000000000000000
-0.3300000000000000000000000	-0.9900000000000000000000000
-0.3000000000000000000000000	-0.9000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0100000000000000000000000	0.0300000000000000000000000
0.0200000000000000000000000	0.0600000000000000000000000
0.1000000000000000000000000	0.3000000000000000000000000
0.2000000000000000000000000	0.6000000000000000000000000
0.3000000000000000000000000	0.9000000000000000000000000
0.3300000000000000000000000	0.9900000000000000000000000
0.3330000000000000000000000	0.9990000000000000000000000
0.9999999999999999999999999	2.9999999999999999999999997
1.0000000000000000000000000	3.0000000000000000000000000
1.0000000000000000000000000	3.0000000000000000000000000
1.1200000000000000000000000	3.3600000000000000000000000
1.1220000000000000000000000	3.3660000000000000000000000
2.0000000000000000000000000	6.0000000000000000000000000
2.0000000000000000000000000	6.0000000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
10.0000000000000000000000000	30.0000000000000000000000000
20.0000000000000000000000000	60.0000000000000000000000000
100.0000000000000000000000000	300.0000000000000000000000000
124.0000000000000000000000000	372.0000000000000000000000000
125.2000000000000000000000000	375.6000000000000000000000000
200.0000000000000000000000000	600.0000000000000000000000000
1234567890.1234567800000000000000000	3703703670.3703703400000000000000000
NULL	NULL
PREHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_4_2_n0
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM DECIMAL_4_2_n0 ORDER BY key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_2_n0
#### A masked pattern was here ####
-1234567890.1234567890000000000000000	-3703703670.3703703670000000000000000
-4400.0000000000000000000000000	-13200.0000000000000000000000000
-1255.4900000000000000000000000	-3766.4700000000000000000000000
-1.1220000000000000000000000	-3.3660000000000000000000000
-1.1200000000000000000000000	-3.3600000000000000000000000
-1.1200000000000000000000000	-3.3600000000000000000000000
-0.3330000000000000000000000	-0.9990000000000000000000000
-0.3300000000000000000000000	-0.9900000000000000000000000
-0.3000000000000000000000000	-0.9000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0000000000000000000000000	0.0000000000000000000000000
0.0100000000000000000000000	0.0300000000000000000000000
0.0200000000000000000000000	0.0600000000000000000000000
0.1000000000000000000000000	0.3000000000000000000000000
0.2000000000000000000000000	0.6000000000000000000000000
0.3000000000000000000000000	0.9000000000000000000000000
0.3300000000000000000000000	0.9900000000000000000000000
0.3330000000000000000000000	0.9990000000000000000000000
0.9999999999999999999999999	2.9999999999999999999999997
1.0000000000000000000000000	3.0000000000000000000000000
1.0000000000000000000000000	3.0000000000000000000000000
1.1200000000000000000000000	3.3600000000000000000000000
1.1220000000000000000000000	3.3660000000000000000000000
2.0000000000000000000000000	6.0000000000000000000000000
2.0000000000000000000000000	6.0000000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
3.1400000000000000000000000	9.4200000000000000000000000
10.0000000000000000000000000	30.0000000000000000000000000
20.0000000000000000000000000	60.0000000000000000000000000
100.0000000000000000000000000	300.0000000000000000000000000
124.0000000000000000000000000	372.0000000000000000000000000
125.2000000000000000000000000	375.6000000000000000000000000
200.0000000000000000000000000	600.0000000000000000000000000
1234567890.1234567800000000000000000	3703703670.3703703400000000000000000
NULL	NULL
PREHOOK: query: DROP TABLE DECIMAL_4_1_n0
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_4_1_n0
PREHOOK: Output: default@decimal_4_1_n0
POSTHOOK: query: DROP TABLE DECIMAL_4_1_n0
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@decimal_4_1_n0
POSTHOOK: Output: default@decimal_4_1_n0
PREHOOK: query: DROP TABLE DECIMAL_4_2_n0
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_4_2_n0
PREHOOK: Output: default@decimal_4_2_n0
POSTHOOK: query: DROP TABLE DECIMAL_4_2_n0
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@decimal_4_2_n0
POSTHOOK: Output: default@decimal_4_2_n0