blob: bd3bfcf1cc31f928a3d06402a10a400c08decf7b [file] [log] [blame]
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