PREHOOK: query: drop table partition_varchar_1
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table partition_varchar_1
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table partition_varchar_1 (key string, value varchar(20)) partitioned by (dt varchar(10), region int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@partition_varchar_1
POSTHOOK: query: create table partition_varchar_1 (key string, value varchar(20)) partitioned by (dt varchar(10), region int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@partition_varchar_1
PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=1)
  select * from src tablesample (10 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=1
POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=1)
  select * from src tablesample (10 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=1
POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=2)
  select * from src tablesample (5 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=2
POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2000-01-01', region=2)
  select * from src tablesample (5 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_varchar_1@dt=2000-01-01/region=2
POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2000-01-01,region=2).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=1)
  select * from src tablesample (20 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=1
POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=1)
  select * from src tablesample (20 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=1
POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=1).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=10)
  select * from src tablesample (11 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=10
POSTHOOK: query: insert overwrite table partition_varchar_1 partition(dt='2013-08-08', region=10)
  select * from src tablesample (11 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_varchar_1@dt=2013-08-08/region=10
POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_varchar_1 PARTITION(dt=2013-08-08,region=10).value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: select distinct dt from partition_varchar_1
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=10
#### A masked pattern was here ####
POSTHOOK: query: select distinct dt from partition_varchar_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=10
#### A masked pattern was here ####
2000-01-01
2013-08-08
PREHOOK: query: select * from partition_varchar_1 where dt = '2000-01-01' and region = 2 order by key,value
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
#### A masked pattern was here ####
POSTHOOK: query: select * from partition_varchar_1 where dt = '2000-01-01' and region = 2 order by key,value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
#### A masked pattern was here ####
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_varchar_1 where dt = '2000-01-01'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
#### A masked pattern was here ####
POSTHOOK: query: -- 15
select count(*) from partition_varchar_1 where dt = '2000-01-01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
#### A masked pattern was here ####
15
PREHOOK: query: -- 5
select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 2
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
#### A masked pattern was here ####
POSTHOOK: query: -- 5
select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=2
#### A masked pattern was here ####
5
PREHOOK: query: -- 11
select count(*) from partition_varchar_1 where dt = '2013-08-08' and region = 10
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=10
#### A masked pattern was here ####
POSTHOOK: query: -- 11
select count(*) from partition_varchar_1 where dt = '2013-08-08' and region = 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=10
#### A masked pattern was here ####
11
PREHOOK: query: -- 30
select count(*) from partition_varchar_1 where region = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 30
select count(*) from partition_varchar_1 where region = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
30
PREHOOK: query: -- 0
select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
#### A masked pattern was here ####
POSTHOOK: query: -- 0
select count(*) from partition_varchar_1 where dt = '2000-01-01' and region = 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
#### A masked pattern was here ####
0
PREHOOK: query: -- 0
select count(*) from partition_varchar_1 where dt = '1999-01-01'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
#### A masked pattern was here ####
POSTHOOK: query: -- 0
select count(*) from partition_varchar_1 where dt = '1999-01-01'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
#### A masked pattern was here ####
0
PREHOOK: query: -- Try other comparison operations

-- 20
select count(*) from partition_varchar_1 where dt > '2000-01-01' and region = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- Try other comparison operations

-- 20
select count(*) from partition_varchar_1 where dt > '2000-01-01' and region = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
20
PREHOOK: query: -- 10
select count(*) from partition_varchar_1 where dt < '2000-01-02' and region = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 10
select count(*) from partition_varchar_1 where dt < '2000-01-02' and region = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
#### A masked pattern was here ####
10
PREHOOK: query: -- 20
select count(*) from partition_varchar_1 where dt >= '2000-01-02' and region = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 20
select count(*) from partition_varchar_1 where dt >= '2000-01-02' and region = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
20
PREHOOK: query: -- 10
select count(*) from partition_varchar_1 where dt <= '2000-01-01' and region = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 10
select count(*) from partition_varchar_1 where dt <= '2000-01-01' and region = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2000-01-01/region=1
#### A masked pattern was here ####
10
PREHOOK: query: -- 20
select count(*) from partition_varchar_1 where dt <> '2000-01-01' and region = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 20
select count(*) from partition_varchar_1 where dt <> '2000-01-01' and region = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Input: default@partition_varchar_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
20
PREHOOK: query: drop table partition_varchar_1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@partition_varchar_1
PREHOOK: Output: default@partition_varchar_1
POSTHOOK: query: drop table partition_varchar_1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@partition_varchar_1
POSTHOOK: Output: default@partition_varchar_1