PREHOOK: query: drop table partition_date_1 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table partition_date_1 POSTHOOK: type: DROPTABLE PREHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region int) PREHOOK: type: CREATETABLE POSTHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@partition_date_1 PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=1) select * from src limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@partition_date_1@dt=2000-01-01/region=1 POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=1) select * from src limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@partition_date_1@dt=2000-01-01/region=1 POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=2) select * from src limit 5 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@partition_date_1@dt=2000-01-01/region=2 POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=2) select * from src limit 5 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@partition_date_1@dt=2000-01-01/region=2 POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=1) select * from src limit 20 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@partition_date_1@dt=2013-08-08/region=1 POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=1) select * from src limit 20 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@partition_date_1@dt=2013-08-08/region=1 POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=10) select * from src limit 11 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@partition_date_1@dt=2013-08-08/region=10 POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=10) select * from src limit 11 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@partition_date_1@dt=2013-08-08/region=10 POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: select distinct dt from partition_date_1 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10 #### A masked pattern was here #### POSTHOOK: query: select distinct dt from partition_date_1 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 2000-01-01 2013-08-08 PREHOOK: query: select * from partition_date_1 where dt = '2000-01-01' and region = 2 order by key,value PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 #### A masked pattern was here #### POSTHOOK: query: select * from partition_date_1 where dt = '2000-01-01' and region = 2 order by key,value POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 165 val_165 2000-01-01 2 238 val_238 2000-01-01 2 27 val_27 2000-01-01 2 311 val_311 2000-01-01 2 86 val_86 2000-01-01 2 PREHOOK: query: -- 15 select count(*) from partition_date_1 where dt = date '2000-01-01' PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 #### A masked pattern was here #### POSTHOOK: query: -- 15 select count(*) from partition_date_1 where dt = date '2000-01-01' POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 15 PREHOOK: query: -- 15. Also try with string value in predicate select count(*) from partition_date_1 where dt = '2000-01-01' PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 #### A masked pattern was here #### POSTHOOK: query: -- 15. Also try with string value in predicate select count(*) from partition_date_1 where dt = '2000-01-01' POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 15 PREHOOK: query: -- 5 select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 2 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 #### A masked pattern was here #### POSTHOOK: query: -- 5 select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 2 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 5 PREHOOK: query: -- 11 select count(*) from partition_date_1 where dt = date '2013-08-08' and region = 10 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10 #### A masked pattern was here #### POSTHOOK: query: -- 11 select count(*) from partition_date_1 where dt = date '2013-08-08' and region = 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 11 PREHOOK: query: -- 30 select count(*) from partition_date_1 where region = 1 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 #### A masked pattern was here #### POSTHOOK: query: -- 30 select count(*) from partition_date_1 where region = 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 30 PREHOOK: query: -- 0 select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 3 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 #### A masked pattern was here #### POSTHOOK: query: -- 0 select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 3 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 0 PREHOOK: query: -- 0 select count(*) from partition_date_1 where dt = date '1999-01-01' PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 #### A masked pattern was here #### POSTHOOK: query: -- 0 select count(*) from partition_date_1 where dt = date '1999-01-01' POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 0 PREHOOK: query: -- Try other comparison operations -- 20 select count(*) from partition_date_1 where dt > date '2000-01-01' and region = 1 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 #### A masked pattern was here #### POSTHOOK: query: -- Try other comparison operations -- 20 select count(*) from partition_date_1 where dt > date '2000-01-01' and region = 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 20 PREHOOK: query: -- 10 select count(*) from partition_date_1 where dt < date '2000-01-02' and region = 1 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 #### A masked pattern was here #### POSTHOOK: query: -- 10 select count(*) from partition_date_1 where dt < date '2000-01-02' and region = 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 10 PREHOOK: query: -- 20 select count(*) from partition_date_1 where dt >= date '2000-01-02' and region = 1 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 #### A masked pattern was here #### POSTHOOK: query: -- 20 select count(*) from partition_date_1 where dt >= date '2000-01-02' and region = 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 20 PREHOOK: query: -- 10 select count(*) from partition_date_1 where dt <= date '2000-01-01' and region = 1 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 #### A masked pattern was here #### POSTHOOK: query: -- 10 select count(*) from partition_date_1 where dt <= date '2000-01-01' and region = 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 10 PREHOOK: query: -- 20 select count(*) from partition_date_1 where dt <> date '2000-01-01' and region = 1 PREHOOK: type: QUERY PREHOOK: Input: default@partition_date_1 PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 #### A masked pattern was here #### POSTHOOK: query: -- 20 select count(*) from partition_date_1 where dt <> date '2000-01-01' and region = 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@partition_date_1 POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1 #### A masked pattern was here #### POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] 20 PREHOOK: query: drop table partition_date_1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@partition_date_1 PREHOOK: Output: default@partition_date_1 POSTHOOK: query: drop table partition_date_1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@partition_date_1 POSTHOOK: Output: default@partition_date_1 POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]