| PREHOOK: query: CREATE EXTERNAL TABLE hbase_ck_1(key struct<col1:string,col2:string,col3:string>, value string) |
| STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' |
| WITH SERDEPROPERTIES ( |
| "hbase.table.name" = "hbase_custom", |
| "hbase.columns.mapping" = ":key,cf:string", |
| "hbase.composite.key.factory"="org.apache.hadoop.hive.hbase.SampleHBaseKeyFactory") |
| TBLPROPERTIES ("external.table.purge" = "true") |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@hbase_ck_1 |
| POSTHOOK: query: CREATE EXTERNAL TABLE hbase_ck_1(key struct<col1:string,col2:string,col3:string>, value string) |
| STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' |
| WITH SERDEPROPERTIES ( |
| "hbase.table.name" = "hbase_custom", |
| "hbase.columns.mapping" = ":key,cf:string", |
| "hbase.composite.key.factory"="org.apache.hadoop.hive.hbase.SampleHBaseKeyFactory") |
| TBLPROPERTIES ("external.table.purge" = "true") |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@hbase_ck_1 |
| PREHOOK: query: CREATE EXTERNAL TABLE hbase_ck_2(key string, value string) |
| STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' |
| WITH SERDEPROPERTIES ( |
| "hbase.table.name" = "hbase_custom", |
| "hbase.columns.mapping" = ":key,cf:string") |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@hbase_ck_2 |
| POSTHOOK: query: CREATE EXTERNAL TABLE hbase_ck_2(key string, value string) |
| STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' |
| WITH SERDEPROPERTIES ( |
| "hbase.table.name" = "hbase_custom", |
| "hbase.columns.mapping" = ":key,cf:string") |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@hbase_ck_2 |
| PREHOOK: query: from src tablesample (1 rows) |
| insert into table hbase_ck_1 select struct('1000','2000','3000'),'value' |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Output: default@hbase_ck_1 |
| POSTHOOK: query: from src tablesample (1 rows) |
| insert into table hbase_ck_1 select struct('1000','2000','3000'),'value' |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: default@hbase_ck_1 |
| PREHOOK: query: select * from hbase_ck_1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@hbase_ck_1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from hbase_ck_1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@hbase_ck_1 |
| #### A masked pattern was here #### |
| {"col1":"1000","col2":"2000","col3":"3000"} value |
| PREHOOK: query: select * from hbase_ck_2 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@hbase_ck_2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from hbase_ck_2 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@hbase_ck_2 |
| #### A masked pattern was here #### |
| 1000$$2000$$3000 value |