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: describe formatted DECIMAL_RC PREHOOK: type: DESCTABLE PREHOOK: Input: default@decimal_rc POSTHOOK: query: describe formatted DECIMAL_RC POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@decimal_rc # col_name data_type comment key decimal(10,0) value int # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE true numFiles 1 numRows 38 rawDataSize 157 totalSize 278 #### A masked pattern was here #### # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 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: describe formatted DECIMAL_LAZY_COL PREHOOK: type: DESCTABLE PREHOOK: Input: default@decimal_lazy_col POSTHOOK: query: describe formatted DECIMAL_LAZY_COL POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@decimal_lazy_col # col_name data_type comment key decimal(10,0) value int # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE true numFiles 1 numRows 38 rawDataSize 157 totalSize 278 #### A masked pattern was here #### # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe InputFormat: org.apache.hadoop.hive.ql.io.RCFileInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.RCFileOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 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