PREHOOK: query: DROP TABLE t_hbase PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE t_hbase POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE 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") PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@t_hbase POSTHOOK: query: CREATE 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") 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 from deserializer tinyint_col tinyint from deserializer smallint_col smallint from deserializer int_col int from deserializer bigint_col bigint from deserializer float_col float from deserializer double_col double from deserializer boolean_col boolean from deserializer # 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: hbase.table.default.storage.type binary hbase.table.name t_hive storage_handler org.apache.hadoop.hive.hbase.HBaseStorageHandler #### 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 POSTHOOK: query: explain SELECT * FROM t_hbase where int_col > 0 POSTHOOK: type: QUERY 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 filterExpr: (int_col > 0) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator predicate: (int_col > 0) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe 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