| 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 |