ql/src/test/results/clientpositive/llap/decimal_serde.q.out

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 ####
-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
NULL	0
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
POSTHOOK: Lineage: decimal_rc.key SIMPLE [(decimal_text)decimal_text.FieldSchema(name:key, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: decimal_rc.value SIMPLE [(decimal_text)decimal_text.FieldSchema(name:value, type:int, comment:null), ]
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 ####
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
	COLUMN_STATS_ACCURATE	{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
	bucketing_version   	2                   
	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
POSTHOOK: Lineage: decimal_lazy_col.key SIMPLE [(decimal_rc)decimal_rc.FieldSchema(name:key, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: decimal_lazy_col.value SIMPLE [(decimal_rc)decimal_rc.FieldSchema(name:value, type:int, comment:null), ]
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 ####
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
	COLUMN_STATS_ACCURATE	{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
	bucketing_version   	2                   
	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
POSTHOOK: Lineage: decimal_sequence.key SIMPLE [(decimal_lazy_col)decimal_lazy_col.FieldSchema(name:key, type:decimal(10,0), comment:null), ]
POSTHOOK: Lineage: decimal_sequence.value SIMPLE [(decimal_lazy_col)decimal_lazy_col.FieldSchema(name:value, type:int, comment:null), ]
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 ####
-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
NULL	0
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