| PREHOOK: query: drop table if exists hht |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table if exists hht |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: CREATE EXTERNAL TABLE hht (key string, value int) |
| STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' |
| WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val") |
| TBLPROPERTIES ("hbase.table.name" = "hht", "hbase.mapred.output.outputtable" = "hht", "external.table.purge" = "true") |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@hht |
| POSTHOOK: query: CREATE EXTERNAL TABLE hht (key string, value int) |
| STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' |
| WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val") |
| TBLPROPERTIES ("hbase.table.name" = "hht", "hbase.mapred.output.outputtable" = "hht", "external.table.purge" = "true") |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@hht |
| PREHOOK: query: insert into hht values ('a', 1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@hht |
| POSTHOOK: query: insert into hht values ('a', 1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@hht |
| PREHOOK: query: insert into hht values ('b', 1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@hht |
| POSTHOOK: query: insert into hht values ('b', 1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@hht |
| PREHOOK: query: insert into hht values ('c', 1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@hht |
| POSTHOOK: query: insert into hht values ('c', 1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@hht |
| PREHOOK: query: select * from hht limit 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@hht |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from hht limit 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@hht |
| #### A masked pattern was here #### |
| a 1 |
| b 1 |
| c 1 |
| PREHOOK: query: drop table hht |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@hht |
| PREHOOK: Output: default@hht |
| POSTHOOK: query: drop table hht |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@hht |
| POSTHOOK: Output: default@hht |