hbase-handler/src/test/results/positive/external_table_ppd.q.out

PREHOOK: query: DROP TABLE t_hbase
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE t_hbase
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE EXTERNAL TABLE t_hbase(key STRING,
                     tinyint_col TINYINT,
                     smallint_col SMALLINT,
                     int_col INT,
                     bigint_col BIGINT,
                     float_col FLOAT,
                     double_col DOUBLE,
                     boolean_col BOOLEAN)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = "cf:binarykey#-,cf:binarybyte#-,cf:binaryshort#-,:key#-,cf:binarylong#-,cf:binaryfloat#-,cf:binarydouble#-,cf:binaryboolean#-")
TBLPROPERTIES ("hbase.table.name" = "t_hive",
               "hbase.table.default.storage.type" = "binary",
               "external.table.purge" = "true")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@t_hbase
POSTHOOK: query: CREATE EXTERNAL TABLE t_hbase(key STRING,
                     tinyint_col TINYINT,
                     smallint_col SMALLINT,
                     int_col INT,
                     bigint_col BIGINT,
                     float_col FLOAT,
                     double_col DOUBLE,
                     boolean_col BOOLEAN)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = "cf:binarykey#-,cf:binarybyte#-,cf:binaryshort#-,:key#-,cf:binarylong#-,cf:binaryfloat#-,cf:binarydouble#-,cf:binaryboolean#-")
TBLPROPERTIES ("hbase.table.name" = "t_hive",
               "hbase.table.default.storage.type" = "binary",
               "external.table.purge" = "true")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@t_hbase
PREHOOK: query: DESCRIBE FORMATTED t_hbase
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@t_hbase
POSTHOOK: query: DESCRIBE FORMATTED t_hbase
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@t_hbase
# col_name            	data_type           	comment             
key                 	string              	                    
tinyint_col         	tinyint             	                    
smallint_col        	smallint            	                    
int_col             	int                 	                    
bigint_col          	bigint              	                    
float_col           	float               	                    
double_col          	double              	                    
boolean_col         	boolean             	                    
	 	 
# Detailed Table Information	 	 
Database:           	default             	 
#### A masked pattern was here ####
Retention:          	0                   	 
#### A masked pattern was here ####
Table Type:         	EXTERNAL_TABLE      	 
Table Parameters:	 	 
	COLUMN_STATS_ACCURATE	{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"bigint_col\":\"true\",\"boolean_col\":\"true\",\"double_col\":\"true\",\"float_col\":\"true\",\"int_col\":\"true\",\"key\":\"true\",\"smallint_col\":\"true\",\"tinyint_col\":\"true\"}}
	EXTERNAL            	TRUE                
	bucketing_version   	2                   
	external.table.purge	true                
	hbase.table.default.storage.type	binary              
	hbase.table.name    	t_hive              
	numFiles            	0                   
	numRows             	0                   
	rawDataSize         	0                   
	storage_handler     	org.apache.hadoop.hive.hbase.HBaseStorageHandler
	totalSize           	0                   
#### A masked pattern was here ####
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.hbase.HBaseSerDe	 
InputFormat:        	null                	 
OutputFormat:       	null                	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	hbase.columns.mapping	cf:binarykey#-,cf:binarybyte#-,cf:binaryshort#-,:key#-,cf:binarylong#-,cf:binaryfloat#-,cf:binarydouble#-,cf:binaryboolean#-
	serialization.format	1                   
PREHOOK: query: INSERT OVERWRITE TABLE t_hbase
SELECT 'user1', 1, 11, 10, 1, 1.0, 1.0, true
FROM src
WHERE key=100 OR key=125 OR key=126
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@t_hbase
POSTHOOK: query: INSERT OVERWRITE TABLE t_hbase
SELECT 'user1', 1, 11, 10, 1, 1.0, 1.0, true
FROM src
WHERE key=100 OR key=125 OR key=126
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@t_hbase
PREHOOK: query: INSERT OVERWRITE TABLE t_hbase
SELECT 'user2', 127, 327, 2147, 9223372036854775807, 211.31, 268746532.0571, false
FROM src
WHERE key=100 OR key=125 OR key=126
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@t_hbase
POSTHOOK: query: INSERT OVERWRITE TABLE t_hbase
SELECT 'user2', 127, 327, 2147, 9223372036854775807, 211.31, 268746532.0571, false
FROM src
WHERE key=100 OR key=125 OR key=126
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@t_hbase
PREHOOK: query: INSERT OVERWRITE TABLE t_hbase
SELECT 'user3', -128, -327, -214748, -9223372036854775808, -201.17, -2110789.37145, true
FROM src
WHERE key=100 OR key=125 OR key=126
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@t_hbase
POSTHOOK: query: INSERT OVERWRITE TABLE t_hbase
SELECT 'user3', -128, -327, -214748, -9223372036854775808, -201.17, -2110789.37145, true
FROM src
WHERE key=100 OR key=125 OR key=126
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@t_hbase
PREHOOK: query: explain SELECT * FROM t_hbase where int_col > 0
PREHOOK: type: QUERY
PREHOOK: Input: default@t_hbase
#### A masked pattern was here ####
POSTHOOK: query: explain SELECT * FROM t_hbase where int_col > 0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_hbase
#### A masked pattern was here ####
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: t_hbase
            Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: (int_col > 0) (type: boolean)
              Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: key (type: string), tinyint_col (type: tinyint), smallint_col (type: smallint), int_col (type: int), bigint_col (type: bigint), float_col (type: float), double_col (type: double), boolean_col (type: boolean)
                outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
                Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
                  Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
                  table:
                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
      Execution mode: vectorized

  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        ListSink

PREHOOK: query: SELECT * FROM t_hbase where int_col > 0
PREHOOK: type: QUERY
PREHOOK: Input: default@t_hbase
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM t_hbase where int_col > 0
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_hbase
#### A masked pattern was here ####
user1	1	11	10	1	1.0	1.0	true
user2	127	327	2147	9223372036854775807	211.31	2.687465320571E8	false
PREHOOK: query: DROP TABLE t_hbase
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@t_hbase
PREHOOK: Output: default@t_hbase
POSTHOOK: query: DROP TABLE t_hbase
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@t_hbase
POSTHOOK: Output: default@t_hbase