PREHOOK: query: CREATE TABLE hbase_ppd_keyrange(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key#binary,cf:string") PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@hbase_ppd_keyrange POSTHOOK: query: CREATE TABLE hbase_ppd_keyrange(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key#binary,cf:string") POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@hbase_ppd_keyrange PREHOOK: query: INSERT OVERWRITE TABLE hbase_ppd_keyrange SELECT * FROM src PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@hbase_ppd_keyrange POSTHOOK: query: INSERT OVERWRITE TABLE hbase_ppd_keyrange SELECT * FROM src POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@hbase_ppd_keyrange PREHOOK: query: explain select * from hbase_ppd_keyrange where key > 8 and key < 21 PREHOOK: type: QUERY POSTHOOK: query: explain select * from hbase_ppd_keyrange where key > 8 and key < 21 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: hbase_ppd_keyrange filterExpr: ((key > 8) and (key < 21)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator predicate: ((key > 8) and (key < 21)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: key (type: int), value (type: string) outputColumnNames: _col0, _col1 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 hbase_ppd_keyrange where key > 8 and key < 21 PREHOOK: type: QUERY PREHOOK: Input: default@hbase_ppd_keyrange #### A masked pattern was here #### POSTHOOK: query: select * from hbase_ppd_keyrange where key > 8 and key < 21 POSTHOOK: type: QUERY POSTHOOK: Input: default@hbase_ppd_keyrange #### A masked pattern was here #### 9 val_9 10 val_10 11 val_11 12 val_12 15 val_15 17 val_17 18 val_18 19 val_19 20 val_20 PREHOOK: query: explain select * from hbase_ppd_keyrange where key > 8 and key <= 17 PREHOOK: type: QUERY POSTHOOK: query: explain select * from hbase_ppd_keyrange where key > 8 and key <= 17 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: hbase_ppd_keyrange filterExpr: ((key > 8) and (key <= 17)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator predicate: ((key > 8) and (key <= 17)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: key (type: int), value (type: string) outputColumnNames: _col0, _col1 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 hbase_ppd_keyrange where key > 8 and key <= 17 PREHOOK: type: QUERY PREHOOK: Input: default@hbase_ppd_keyrange #### A masked pattern was here #### POSTHOOK: query: select * from hbase_ppd_keyrange where key > 8 and key <= 17 POSTHOOK: type: QUERY POSTHOOK: Input: default@hbase_ppd_keyrange #### A masked pattern was here #### 9 val_9 10 val_10 11 val_11 12 val_12 15 val_15 17 val_17 PREHOOK: query: explain select * from hbase_ppd_keyrange where key > 8 and key <= 17 and value like '%11%' PREHOOK: type: QUERY POSTHOOK: query: explain select * from hbase_ppd_keyrange where key > 8 and key <= 17 and value like '%11%' 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: hbase_ppd_keyrange filterExpr: ((key > 8) and (key <= 17)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator predicate: (value like '%11%') (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: key (type: int), value (type: string) outputColumnNames: _col0, _col1 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 hbase_ppd_keyrange where key > 8 and key <= 17 and value like '%11%' PREHOOK: type: QUERY PREHOOK: Input: default@hbase_ppd_keyrange #### A masked pattern was here #### POSTHOOK: query: select * from hbase_ppd_keyrange where key > 8 and key <= 17 and value like '%11%' POSTHOOK: type: QUERY POSTHOOK: Input: default@hbase_ppd_keyrange #### A masked pattern was here #### 11 val_11 PREHOOK: query: explain select * from hbase_ppd_keyrange where key >= 9 and key < 17 and key = 11 PREHOOK: type: QUERY POSTHOOK: query: explain select * from hbase_ppd_keyrange where key >= 9 and key < 17 and key = 11 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: hbase_ppd_keyrange Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator predicate: (((key >= 9) and (key < 17)) and (key = 11)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: 11 (type: int), value (type: string) outputColumnNames: _col0, _col1 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 hbase_ppd_keyrange where key >=9 and key < 17 and key = 11 PREHOOK: type: QUERY PREHOOK: Input: default@hbase_ppd_keyrange #### A masked pattern was here #### POSTHOOK: query: select * from hbase_ppd_keyrange where key >=9 and key < 17 and key = 11 POSTHOOK: type: QUERY POSTHOOK: Input: default@hbase_ppd_keyrange #### A masked pattern was here #### 11 val_11 PREHOOK: query: drop table hbase_ppd_keyrange PREHOOK: type: DROPTABLE PREHOOK: Input: default@hbase_ppd_keyrange PREHOOK: Output: default@hbase_ppd_keyrange POSTHOOK: query: drop table hbase_ppd_keyrange POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@hbase_ppd_keyrange POSTHOOK: Output: default@hbase_ppd_keyrange