hbase-handler/src/test/results/positive/hbase_ppd_join.q.out

PREHOOK: query: drop table if exists hive1_tbl_data_hbase1
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table if exists hive1_tbl_data_hbase1
POSTHOOK: type: DROPTABLE
PREHOOK: query: drop table if exists hive1_tbl_data_hbase2
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table if exists hive1_tbl_data_hbase2
POSTHOOK: type: DROPTABLE
PREHOOK: query: drop view if exists hive1_view_data_hbase1
PREHOOK: type: DROPVIEW
POSTHOOK: query: drop view if exists hive1_view_data_hbase1
POSTHOOK: type: DROPVIEW
PREHOOK: query: drop view if exists hive1_view_data_hbase2
PREHOOK: type: DROPVIEW
POSTHOOK: query: drop view if exists hive1_view_data_hbase2
POSTHOOK: type: DROPVIEW
PREHOOK: query: CREATE EXTERNAL TABLE hive1_tbl_data_hbase1 (COLUMID string,COLUMN_FN string,COLUMN_LN string,EMAIL string,COL_UPDATED_DATE timestamp, PK_COLUM string) 
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
WITH SERDEPROPERTIES("hbase.columns.mapping" = "default:COLUMID,default:COLUMN_FN,default:COLUMN_LN,default:EMAIL,default:COL_UPDATED_DATE,:key" 
)
TBLPROPERTIES ("external.table.purge" = "true")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@hive1_tbl_data_hbase1
POSTHOOK: query: CREATE EXTERNAL TABLE hive1_tbl_data_hbase1 (COLUMID string,COLUMN_FN string,COLUMN_LN string,EMAIL string,COL_UPDATED_DATE timestamp, PK_COLUM string) 
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
WITH SERDEPROPERTIES("hbase.columns.mapping" = "default:COLUMID,default:COLUMN_FN,default:COLUMN_LN,default:EMAIL,default:COL_UPDATED_DATE,:key" 
)
TBLPROPERTIES ("external.table.purge" = "true")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@hive1_tbl_data_hbase1
PREHOOK: query: CREATE VIEW hive1_view_data_hbase1 
AS 
SELECT * 
FROM hive1_tbl_data_hbase1
WHERE PK_COLUM >='4000-00000'
and PK_COLUM <='4000-99999'
AND COL_UPDATED_DATE IS NOT NULL
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@hive1_tbl_data_hbase1
PREHOOK: Output: database:default
PREHOOK: Output: default@hive1_view_data_hbase1
POSTHOOK: query: CREATE VIEW hive1_view_data_hbase1 
AS 
SELECT * 
FROM hive1_tbl_data_hbase1
WHERE PK_COLUM >='4000-00000'
and PK_COLUM <='4000-99999'
AND COL_UPDATED_DATE IS NOT NULL
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@hive1_tbl_data_hbase1
POSTHOOK: Output: database:default
POSTHOOK: Output: default@hive1_view_data_hbase1
POSTHOOK: Lineage: hive1_view_data_hbase1.col_updated_date SIMPLE [(hive1_tbl_data_hbase1)hive1_tbl_data_hbase1.FieldSchema(name:col_updated_date, type:timestamp, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase1.columid SIMPLE [(hive1_tbl_data_hbase1)hive1_tbl_data_hbase1.FieldSchema(name:columid, type:string, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase1.column_fn SIMPLE [(hive1_tbl_data_hbase1)hive1_tbl_data_hbase1.FieldSchema(name:column_fn, type:string, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase1.column_ln SIMPLE [(hive1_tbl_data_hbase1)hive1_tbl_data_hbase1.FieldSchema(name:column_ln, type:string, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase1.email SIMPLE [(hive1_tbl_data_hbase1)hive1_tbl_data_hbase1.FieldSchema(name:email, type:string, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase1.pk_colum SIMPLE [(hive1_tbl_data_hbase1)hive1_tbl_data_hbase1.FieldSchema(name:pk_colum, type:string, comment:), ]
PREHOOK: query: insert into table hive1_tbl_data_hbase1 select '00001','john','doe','john@hotmail.com','2014-01-01 12:01:02','4000-10000' from src where key = 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@hive1_tbl_data_hbase1
POSTHOOK: query: insert into table hive1_tbl_data_hbase1 select '00001','john','doe','john@hotmail.com','2014-01-01 12:01:02','4000-10000' from src where key = 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@hive1_tbl_data_hbase1
PREHOOK: query: CREATE EXTERNAL TABLE hive1_tbl_data_hbase2 (COLUMID string,COLUMN_FN string,COLUMN_LN string,EMAIL string,COL_UPDATED_DATE timestamp, PK_COLUM string) 
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
WITH SERDEPROPERTIES("hbase.columns.mapping" = "default:COLUMID,default:COLUMN_FN,default:COLUMN_LN,default:EMAIL,default:COL_UPDATED_DATE,:key" 
)
TBLPROPERTIES ("external.table.purge" = "true")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@hive1_tbl_data_hbase2
POSTHOOK: query: CREATE EXTERNAL TABLE hive1_tbl_data_hbase2 (COLUMID string,COLUMN_FN string,COLUMN_LN string,EMAIL string,COL_UPDATED_DATE timestamp, PK_COLUM string) 
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
WITH SERDEPROPERTIES("hbase.columns.mapping" = "default:COLUMID,default:COLUMN_FN,default:COLUMN_LN,default:EMAIL,default:COL_UPDATED_DATE,:key" 
)
TBLPROPERTIES ("external.table.purge" = "true")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@hive1_tbl_data_hbase2
PREHOOK: query: CREATE VIEW hive1_view_data_hbase2 
AS 
SELECT * 
FROM hive1_tbl_data_hbase2 
where COL_UPDATED_DATE IS NOT NULL
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@hive1_tbl_data_hbase2
PREHOOK: Output: database:default
PREHOOK: Output: default@hive1_view_data_hbase2
POSTHOOK: query: CREATE VIEW hive1_view_data_hbase2 
AS 
SELECT * 
FROM hive1_tbl_data_hbase2 
where COL_UPDATED_DATE IS NOT NULL
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@hive1_tbl_data_hbase2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@hive1_view_data_hbase2
POSTHOOK: Lineage: hive1_view_data_hbase2.col_updated_date SIMPLE [(hive1_tbl_data_hbase2)hive1_tbl_data_hbase2.FieldSchema(name:col_updated_date, type:timestamp, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase2.columid SIMPLE [(hive1_tbl_data_hbase2)hive1_tbl_data_hbase2.FieldSchema(name:columid, type:string, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase2.column_fn SIMPLE [(hive1_tbl_data_hbase2)hive1_tbl_data_hbase2.FieldSchema(name:column_fn, type:string, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase2.column_ln SIMPLE [(hive1_tbl_data_hbase2)hive1_tbl_data_hbase2.FieldSchema(name:column_ln, type:string, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase2.email SIMPLE [(hive1_tbl_data_hbase2)hive1_tbl_data_hbase2.FieldSchema(name:email, type:string, comment:), ]
POSTHOOK: Lineage: hive1_view_data_hbase2.pk_colum SIMPLE [(hive1_tbl_data_hbase2)hive1_tbl_data_hbase2.FieldSchema(name:pk_colum, type:string, comment:), ]
PREHOOK: query: insert into table hive1_tbl_data_hbase2 select '00001','john','doe','john@hotmail.com','2014-01-01 12:01:02','00001' from src where key = 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@hive1_tbl_data_hbase2
POSTHOOK: query: insert into table hive1_tbl_data_hbase2 select '00001','john','doe','john@hotmail.com','2014-01-01 12:01:02','00001' from src where key = 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@hive1_tbl_data_hbase2
PREHOOK: query: select x.FIRST_NAME1, x.EMAIL1 from (
select p.COLUMN_FN as first_name1, a.EMAIL as email1 from hive1_view_data_hbase2 p inner join hive1_view_data_hbase1 a on p.COLUMID =a.COLUMID) x
PREHOOK: type: QUERY
PREHOOK: Input: default@hive1_tbl_data_hbase1
PREHOOK: Input: default@hive1_tbl_data_hbase2
PREHOOK: Input: default@hive1_view_data_hbase1
PREHOOK: Input: default@hive1_view_data_hbase2
#### A masked pattern was here ####
POSTHOOK: query: select x.FIRST_NAME1, x.EMAIL1 from (
select p.COLUMN_FN as first_name1, a.EMAIL as email1 from hive1_view_data_hbase2 p inner join hive1_view_data_hbase1 a on p.COLUMID =a.COLUMID) x
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive1_tbl_data_hbase1
POSTHOOK: Input: default@hive1_tbl_data_hbase2
POSTHOOK: Input: default@hive1_view_data_hbase1
POSTHOOK: Input: default@hive1_view_data_hbase2
#### A masked pattern was here ####
john	john@hotmail.com
PREHOOK: query: select x.FIRST_NAME1, x.EMAIL1 from (
select p.COLUMN_FN as first_name1, a.EMAIL as email1 from hive1_view_data_hbase2 p inner join hive1_view_data_hbase1 a on p.COLUMID =a.COLUMID) x
PREHOOK: type: QUERY
PREHOOK: Input: default@hive1_tbl_data_hbase1
PREHOOK: Input: default@hive1_tbl_data_hbase2
PREHOOK: Input: default@hive1_view_data_hbase1
PREHOOK: Input: default@hive1_view_data_hbase2
#### A masked pattern was here ####
POSTHOOK: query: select x.FIRST_NAME1, x.EMAIL1 from (
select p.COLUMN_FN as first_name1, a.EMAIL as email1 from hive1_view_data_hbase2 p inner join hive1_view_data_hbase1 a on p.COLUMID =a.COLUMID) x
POSTHOOK: type: QUERY
POSTHOOK: Input: default@hive1_tbl_data_hbase1
POSTHOOK: Input: default@hive1_tbl_data_hbase2
POSTHOOK: Input: default@hive1_view_data_hbase1
POSTHOOK: Input: default@hive1_view_data_hbase2
#### A masked pattern was here ####
john	john@hotmail.com