PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_TEXT PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_TEXT POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_RC PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_RC POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_LAZY_COL PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_LAZY_COL POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_SEQUENCE PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_SEQUENCE POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE DECIMAL_TEXT (key decimal, value int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@DECIMAL_TEXT POSTHOOK: query: CREATE TABLE DECIMAL_TEXT (key decimal, value int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_TEXT PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_TEXT PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@decimal_text POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv7.txt' INTO TABLE DECIMAL_TEXT POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@decimal_text PREHOOK: query: SELECT * FROM DECIMAL_TEXT ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_text #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM DECIMAL_TEXT ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_text #### A masked pattern was here #### NULL 0 -1234567890 -1234567890 -4400 4400 -1255 -1255 -1 -11 -1 -1 -1 -1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 2 2 2 2 3 3 3 3 3 3 3 4 10 10 20 20 100 100 124 124 125 125 200 200 1234567890 1234567890 PREHOOK: query: CREATE TABLE DECIMAL_RC STORED AS RCFile AS SELECT * FROM DECIMAL_TEXT PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@decimal_text PREHOOK: Output: database:default PREHOOK: Output: default@DECIMAL_RC POSTHOOK: query: CREATE TABLE DECIMAL_RC STORED AS RCFile AS SELECT * FROM DECIMAL_TEXT POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@decimal_text POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_RC PREHOOK: query: CREATE TABLE DECIMAL_LAZY_COL ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" STORED AS RCFile AS SELECT * FROM DECIMAL_RC PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@decimal_rc PREHOOK: Output: database:default PREHOOK: Output: default@DECIMAL_LAZY_COL POSTHOOK: query: CREATE TABLE DECIMAL_LAZY_COL ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" STORED AS RCFile AS SELECT * FROM DECIMAL_RC POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@decimal_rc POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_LAZY_COL PREHOOK: query: CREATE TABLE DECIMAL_SEQUENCE ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY '\002' MAP KEYS TERMINATED BY '\003' STORED AS SEQUENCEFILE AS SELECT * FROM DECIMAL_LAZY_COL ORDER BY key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@decimal_lazy_col PREHOOK: Output: database:default PREHOOK: Output: default@DECIMAL_SEQUENCE POSTHOOK: query: CREATE TABLE DECIMAL_SEQUENCE ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY '\002' MAP KEYS TERMINATED BY '\003' STORED AS SEQUENCEFILE AS SELECT * FROM DECIMAL_LAZY_COL ORDER BY key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@decimal_lazy_col POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_SEQUENCE PREHOOK: query: SELECT * FROM DECIMAL_SEQUENCE ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_sequence #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM DECIMAL_SEQUENCE ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_sequence #### A masked pattern was here #### NULL 0 -1234567890 -1234567890 -4400 4400 -1255 -1255 -1 -11 -1 -1 -1 -1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 2 2 2 2 3 3 3 3 3 3 3 4 10 10 20 20 100 100 124 124 125 125 200 200 1234567890 1234567890 PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_TEXT PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_text PREHOOK: Output: default@decimal_text POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_TEXT POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_text POSTHOOK: Output: default@decimal_text PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_RC PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_rc PREHOOK: Output: default@decimal_rc POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_RC POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_rc POSTHOOK: Output: default@decimal_rc PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_LAZY_COL PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_lazy_col PREHOOK: Output: default@decimal_lazy_col POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_LAZY_COL POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_lazy_col POSTHOOK: Output: default@decimal_lazy_col PREHOOK: query: DROP TABLE IF EXISTS DECIMAL_SEQUENCE PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_sequence PREHOOK: Output: default@decimal_sequence POSTHOOK: query: DROP TABLE IF EXISTS DECIMAL_SEQUENCE POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@decimal_sequence POSTHOOK: Output: default@decimal_sequence