PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_1 PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_1 POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_2 PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_4_2 POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE DECIMAL_4_1(key decimal, value int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE DECIMAL_4_1(key decimal, value int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@DECIMAL_4_1 PREHOOK: query: CREATE TABLE DECIMAL_4_2(key decimal, value decimal) STORED AS ORC PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE DECIMAL_4_2(key decimal, value decimal) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@DECIMAL_4_2 PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_4_1 PREHOOK: type: LOAD PREHOOK: Output: default@decimal_4_1 POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv7.txt' INTO TABLE DECIMAL_4_1 POSTHOOK: type: LOAD POSTHOOK: Output: default@decimal_4_1 PREHOOK: query: INSERT OVERWRITE TABLE DECIMAL_4_2 SELECT key, key * 3 FROM DECIMAL_4_1 PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_1 PREHOOK: Output: default@decimal_4_2 POSTHOOK: query: INSERT OVERWRITE TABLE DECIMAL_4_2 SELECT key, key * 3 FROM DECIMAL_4_1 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_1 POSTHOOK: Output: default@decimal_4_2 POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] PREHOOK: query: SELECT * FROM DECIMAL_4_1 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_1 #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM DECIMAL_4_1 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_1 #### A masked pattern was here #### POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] NULL 0 NULL 0 -1234567890.123456789 -1234567890 -4400 4400 -1255.49 -1255 -1.122 -11 -1.12 -1 -1.12 -1 -0.333 0 -0.33 0 -0.3 0 0 0 0 0 0.01 0 0.02 0 0.1 0 0.2 0 0.3 0 0.33 0 0.333 0 0.9999999999999999999999999 1 1 1 1 1 1.12 1 1.122 1 2 2 2 2 3.14 3 3.14 3 3.14 3 3.14 4 10 10 20 20 100 100 124 124 125.2 125 200 200 1234567890.12345678 1234567890 PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2 #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2 #### A masked pattern was here #### POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] NULL NULL NULL NULL -1234567890.123456789 -3703703670.370370367 -4400 -13200 -1255.49 -3766.47 -1.122 -3.366 -1.12 -3.36 -1.12 -3.36 -0.333 -0.999 -0.33 -0.99 -0.3 -0.9 0 0 0 0 0.01 0.03 0.02 0.06 0.1 0.3 0.2 0.6 0.3 0.9 0.33 0.99 0.333 0.999 0.9999999999999999999999999 2.9999999999999999999999997 1 3 1 3 1.12 3.36 1.122 3.366 2 6 2 6 3.14 9.42 3.14 9.42 3.14 9.42 3.14 9.42 10 30 20 60 100 300 124 372 125.2 375.6 200 600 1234567890.12345678 3703703670.37037034 PREHOOK: query: DROP TABLE DECIMAL_4_1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_4_1 PREHOOK: Output: default@decimal_4_1 POSTHOOK: query: DROP TABLE DECIMAL_4_1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_4_1 POSTHOOK: Output: default@decimal_4_1 POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] PREHOOK: query: DROP TABLE DECIMAL_4_2 PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_4_2 PREHOOK: Output: default@decimal_4_2 POSTHOOK: query: DROP TABLE DECIMAL_4_2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_4_2 POSTHOOK: Output: default@decimal_4_2 POSTHOOK: Lineage: decimal_4_2.key SIMPLE [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ] POSTHOOK: Lineage: decimal_4_2.value EXPRESSION [(decimal_4_1)decimal_4_1.FieldSchema(name:key, type:decimal, comment:null), ]