http://git-wip-us.apache.org/repos/asf/hive/blob/1f258e96/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
----------------------------------------------------------------------
diff --git 
a/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out 
b/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
new file mode 100644
index 0000000..30957b7
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
@@ -0,0 +1,1644 @@
+PREHOOK: query: create table partition_test_multilevel (key string, value 
string) partitioned by (level1 string, level2 string, level3 string)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_multilevel
+POSTHOOK: query: create table partition_test_multilevel (key string, value 
string) partitioned by (level1 string, level2 string, level3 string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@partition_test_multilevel
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='111', level3='11') select key, value from 
srcpart tablesample (11 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='111', level3='11') select key, value from 
srcpart tablesample (11 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=111,level3=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=111,level3=11).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='111', level3='22') select key, value from 
srcpart tablesample (12 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='111', level3='22') select key, value from 
srcpart tablesample (12 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=111,level3=22).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=111,level3=22).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='111', level3='33') select key, value from 
srcpart tablesample (13 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='111', level3='33') select key, value from 
srcpart tablesample (13 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=111,level3=33).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=111,level3=33).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='111', level3='44') select key, value from 
srcpart tablesample (14 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='111', level3='44') select key, value from 
srcpart tablesample (14 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=111,level3=44).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=111,level3=44).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='222', level3='11') select key, value from 
srcpart tablesample (15 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='222', level3='11') select key, value from 
srcpart tablesample (15 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=222,level3=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=222,level3=11).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='222', level3='22') select key, value from 
srcpart tablesample (16 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='222', level3='22') select key, value from 
srcpart tablesample (16 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=222,level3=22).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=222,level3=22).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='222', level3='33') select key, value from 
srcpart tablesample (17 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='222', level3='33') select key, value from 
srcpart tablesample (17 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=222,level3=33).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=222,level3=33).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='222', level3='44') select key, value from 
srcpart tablesample (18 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='222', level3='44') select key, value from 
srcpart tablesample (18 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=222,level3=44).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=222,level3=44).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='333', level3='11') select key, value from 
srcpart tablesample (19 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='333', level3='11') select key, value from 
srcpart tablesample (19 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=333,level3=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=333,level3=11).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='333', level3='22') select key, value from 
srcpart tablesample (20 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='333', level3='22') select key, value from 
srcpart tablesample (20 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=333,level3=22).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=333,level3=22).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='333', level3='33') select key, value from 
srcpart tablesample (21 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='333', level3='33') select key, value from 
srcpart tablesample (21 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=333,level3=33).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=333,level3=33).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='333', level3='44') select key, value from 
srcpart tablesample (22 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='1111', level2='333', level3='44') select key, value from 
srcpart tablesample (22 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=333,level3=44).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=1111,level2=333,level3=44).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='111', level3='11') select key, value from 
srcpart tablesample (11 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='111', level3='11') select key, value from 
srcpart tablesample (11 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=111,level3=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=111,level3=11).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='111', level3='22') select key, value from 
srcpart tablesample (12 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='111', level3='22') select key, value from 
srcpart tablesample (12 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=111,level3=22).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=111,level3=22).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='111', level3='33') select key, value from 
srcpart tablesample (13 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='111', level3='33') select key, value from 
srcpart tablesample (13 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=111,level3=33).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=111,level3=33).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='111', level3='44') select key, value from 
srcpart tablesample (14 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='111', level3='44') select key, value from 
srcpart tablesample (14 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=111,level3=44).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=111,level3=44).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='222', level3='11') select key, value from 
srcpart tablesample (15 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='222', level3='11') select key, value from 
srcpart tablesample (15 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=222,level3=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=222,level3=11).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='222', level3='22') select key, value from 
srcpart tablesample (16 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='222', level3='22') select key, value from 
srcpart tablesample (16 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=222,level3=22).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=222,level3=22).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='222', level3='33') select key, value from 
srcpart tablesample (17 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='222', level3='33') select key, value from 
srcpart tablesample (17 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=222,level3=33).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=222,level3=33).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='222', level3='44') select key, value from 
srcpart tablesample (18 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='222', level3='44') select key, value from 
srcpart tablesample (18 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=222,level3=44).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=222,level3=44).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='333', level3='11') select key, value from 
srcpart tablesample (19 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='333', level3='11') select key, value from 
srcpart tablesample (19 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=333,level3=11).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=333,level3=11).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='333', level3='22') select key, value from 
srcpart tablesample (20 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='333', level3='22') select key, value from 
srcpart tablesample (20 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=333,level3=22).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=333,level3=22).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='333', level3='33') select key, value from 
srcpart tablesample (21 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='333', level3='33') select key, value from 
srcpart tablesample (21 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=333,level3=33).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=333,level3=33).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='333', level3='44') select key, value from 
srcpart tablesample (22 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+PREHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+POSTHOOK: query: insert overwrite table partition_test_multilevel 
partition(level1='2222', level2='333', level3='44') select key, value from 
srcpart tablesample (22 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
+POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=333,level3=44).key SIMPLE 
[(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_test_multilevel 
PARTITION(level1=2222,level2=333,level3=44).value SIMPLE 
[(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: -- beginning level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level1 = '2222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: -- beginning level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level1 = '2222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+2222   111     11      11
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+2222   333     11      19
+2222   333     22      20
+2222   333     33      21
+2222   333     44      22
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 >= '2222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 >= '2222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+2222   111     11      11
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+2222   333     11      19
+2222   333     22      20
+2222   333     33      21
+2222   333     44      22
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 !='2222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 !='2222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+#### A masked pattern was here ####
+1111   111     11      11
+1111   111     22      12
+1111   111     33      13
+1111   111     44      14
+1111   222     11      15
+1111   222     22      16
+1111   222     33      17
+1111   222     44      18
+1111   333     11      19
+1111   333     22      20
+1111   333     33      21
+1111   333     44      22
+PREHOOK: query: -- middle level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level2 = '222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: -- middle level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level2 = '222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+#### A masked pattern was here ####
+1111   222     11      15
+1111   222     22      16
+1111   222     33      17
+1111   222     44      18
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level2 <= '222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level2 <= '222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+#### A masked pattern was here ####
+1111   111     11      11
+1111   111     22      12
+1111   111     33      13
+1111   111     44      14
+1111   222     11      15
+1111   222     22      16
+1111   222     33      17
+1111   222     44      18
+2222   111     11      11
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level2 != '222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level2 != '222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+1111   111     11      11
+1111   111     22      12
+1111   111     33      13
+1111   111     44      14
+1111   333     11      19
+1111   333     22      20
+1111   333     33      21
+1111   333     44      22
+2222   111     11      11
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   333     11      19
+2222   333     22      20
+2222   333     33      21
+2222   333     44      22
+PREHOOK: query: -- ending level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level3 = '22' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+#### A masked pattern was here ####
+POSTHOOK: query: -- ending level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level3 = '22' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+#### A masked pattern was here ####
+1111   111     22      12
+1111   222     22      16
+1111   333     22      20
+2222   111     22      12
+2222   222     22      16
+2222   333     22      20
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level3 >= '22' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level3 >= '22' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+1111   111     22      12
+1111   111     33      13
+1111   111     44      14
+1111   222     22      16
+1111   222     33      17
+1111   222     44      18
+1111   333     22      20
+1111   333     33      21
+1111   333     44      22
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+2222   333     22      20
+2222   333     33      21
+2222   333     44      22
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level3 != '22' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level3 != '22' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+1111   111     11      11
+1111   111     33      13
+1111   111     44      14
+1111   222     11      15
+1111   222     33      17
+1111   222     44      18
+1111   333     11      19
+1111   333     33      21
+1111   333     44      22
+2222   111     11      11
+2222   111     33      13
+2222   111     44      14
+2222   222     11      15
+2222   222     33      17
+2222   222     44      18
+2222   333     11      19
+2222   333     33      21
+2222   333     44      22
+PREHOOK: query: -- two different levels of partitions in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level2 >= '222' and level3 = '33' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+#### A masked pattern was here ####
+POSTHOOK: query: -- two different levels of partitions in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level2 >= '222' and level3 = '33' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+#### A masked pattern was here ####
+1111   222     33      17
+1111   333     33      21
+2222   222     33      17
+2222   333     33      21
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 <= '1111' and level3 >= '33' group by 
level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 <= '1111' and level3 >= '33' group by 
level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+#### A masked pattern was here ####
+1111   111     33      13
+1111   111     44      14
+1111   222     33      17
+1111   222     44      18
+1111   333     33      21
+1111   333     44      22
+PREHOOK: query: -- all levels of partitions in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level1 = '2222' and level2 >= '222' and level3 <= '33' group by level1, level2, 
level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+#### A masked pattern was here ####
+POSTHOOK: query: -- all levels of partitions in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level1 = '2222' and level2 >= '222' and level3 <= '33' group by level1, level2, 
level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+#### A masked pattern was here ####
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   333     11      19
+2222   333     22      20
+2222   333     33      21
+PREHOOK: query: -- between
+select level1, level2, level3, count(*) from partition_test_multilevel where 
(level1 = '2222') and (level2 between '222' and '333') and (level3 between '11' 
and '33') group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+#### A masked pattern was here ####
+POSTHOOK: query: -- between
+select level1, level2, level3, count(*) from partition_test_multilevel where 
(level1 = '2222') and (level2 between '222' and '333') and (level3 between '11' 
and '33') group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+#### A masked pattern was here ####
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   333     11      19
+2222   333     22      20
+2222   333     33      21
+PREHOOK: query: explain select level1, level2, level3, count(*) from 
partition_test_multilevel where (level1 = '2222') and (level2 between '222' and 
'333') and (level3 between '11' and '33') group by level1, level2, level3
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select level1, level2, level3, count(*) from 
partition_test_multilevel where (level1 = '2222') and (level2 between '222' and 
'333') and (level3 between '11' and '33') group by level1, level2, level3
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Tez
+#### A masked pattern was here ####
+      Edges:
+        Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: partition_test_multilevel
+                  Statistics: Num rows: 108 Data size: 40890 Basic stats: 
COMPLETE Column stats: COMPLETE
+                  Select Operator
+                    expressions: level2 (type: string), level3 (type: string)
+                    outputColumnNames: level2, level3
+                    Statistics: Num rows: 108 Data size: 40890 Basic stats: 
COMPLETE Column stats: COMPLETE
+                    Group By Operator
+                      aggregations: count()
+                      keys: level2 (type: string), level3 (type: string)
+                      mode: hash
+                      outputColumnNames: _col0, _col1, _col2
+                      Statistics: Num rows: 6 Data size: 2256 Basic stats: 
COMPLETE Column stats: COMPLETE
+                      Reduce Output Operator
+                        key expressions: _col0 (type: string), _col1 (type: 
string)
+                        sort order: ++
+                        Map-reduce partition columns: _col0 (type: string), 
_col1 (type: string)
+                        Statistics: Num rows: 6 Data size: 2256 Basic stats: 
COMPLETE Column stats: COMPLETE
+                        value expressions: _col2 (type: bigint)
+            Execution mode: llap
+            LLAP IO: no inputs
+        Reducer 2 
+            Execution mode: llap
+            Reduce Operator Tree:
+              Group By Operator
+                aggregations: count(VALUE._col0)
+                keys: KEY._col0 (type: string), KEY._col1 (type: string)
+                mode: mergepartial
+                outputColumnNames: _col0, _col1, _col2
+                Statistics: Num rows: 6 Data size: 2256 Basic stats: COMPLETE 
Column stats: COMPLETE
+                Select Operator
+                  expressions: '2222' (type: string), _col0 (type: string), 
_col1 (type: string), _col2 (type: bigint)
+                  outputColumnNames: _col0, _col1, _col2, _col3
+                  Statistics: Num rows: 6 Data size: 2784 Basic stats: 
COMPLETE Column stats: COMPLETE
+                  File Output Operator
+                    compressed: false
+                    Statistics: Num rows: 6 Data size: 2784 Basic stats: 
COMPLETE Column stats: COMPLETE
+                    table:
+                        input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                        output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                        serde: 
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: -- beginning level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level1 = '2222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: -- beginning level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level1 = '2222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+2222   111     11      11
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+2222   333     11      19
+2222   333     22      20
+2222   333     33      21
+2222   333     44      22
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 >= '2222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 >= '2222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+2222   111     11      11
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+2222   333     11      19
+2222   333     22      20
+2222   333     33      21
+2222   333     44      22
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 !='2222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level1 !='2222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+#### A masked pattern was here ####
+1111   111     11      11
+1111   111     22      12
+1111   111     33      13
+1111   111     44      14
+1111   222     11      15
+1111   222     22      16
+1111   222     33      17
+1111   222     44      18
+1111   333     11      19
+1111   333     22      20
+1111   333     33      21
+1111   333     44      22
+PREHOOK: query: -- middle level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level2 = '222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: -- middle level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level2 = '222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+#### A masked pattern was here ####
+1111   222     11      15
+1111   222     22      16
+1111   222     33      17
+1111   222     44      18
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level2 <= '222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level2 <= '222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=44
+#### A masked pattern was here ####
+1111   111     11      11
+1111   111     22      12
+1111   111     33      13
+1111   111     44      14
+1111   222     11      15
+1111   222     22      16
+1111   222     33      17
+1111   222     44      18
+2222   111     11      11
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   222     11      15
+2222   222     22      16
+2222   222     33      17
+2222   222     44      18
+PREHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level2 != '222' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+POSTHOOK: query: select level1, level2, level3, count(*) from 
partition_test_multilevel where level2 != '222' group by level1, level2, level3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_test_multilevel
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=44
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=11
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=22
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=33
+POSTHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=333/level3=44
+#### A masked pattern was here ####
+1111   111     11      11
+1111   111     22      12
+1111   111     33      13
+1111   111     44      14
+1111   333     11      19
+1111   333     22      20
+1111   333     33      21
+1111   333     44      22
+2222   111     11      11
+2222   111     22      12
+2222   111     33      13
+2222   111     44      14
+2222   333     11      19
+2222   333     22      20
+2222   333     33      21
+2222   333     44      22
+PREHOOK: query: -- ending level partition in predicate
+select level1, level2, level3, count(*) from partition_test_multilevel where 
level3 = '22' group by level1, level2, level3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_test_multilevel
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=222/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=1111/level2=333/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=111/level3=22
+PREHOOK: Input: 
default@partition_test_multilevel@level1=2222/level2=222/level3=22
+PREHOOK: Input: default@partition_test_m

<TRUNCATED>

Reply via email to