hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sze...@apache.org
Subject svn commit: r1641510 [2/2] - in /hive/branches/branch-0.14: metastore/src/java/org/apache/hadoop/hive/metastore/parser/ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Date Tue, 25 Nov 2014 00:09:33 GMT
Added: hive/branches/branch-0.14/ql/src/test/results/clientpositive/partition_multilevels.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/partition_multilevels.q.out?rev=1641510&view=auto
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/partition_multilevels.q.out (added)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/partition_multilevels.q.out Tue Nov 25 00:09:33 2014
@@ -0,0 +1,1624 @@
+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
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: partition_test_multilevel
+            Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
+            Select Operator
+              expressions: '2222' (type: string), level2 (type: string), level3 (type: string)
+              outputColumnNames: level1, level2, level3
+              Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
+              Group By Operator
+                aggregations: count()
+                keys: level1 (type: string), level2 (type: string), level3 (type: string)
+                mode: hash
+                outputColumnNames: _col0, _col1, _col2, _col3
+                Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
+                Reduce Output Operator
+                  key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+                  sort order: +++
+                  Map-reduce partition columns: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+                  Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
+                  value expressions: _col3 (type: bigint)
+      Reduce Operator Tree:
+        Group By Operator
+          aggregations: count(VALUE._col0)
+          keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string)
+          mode: mergepartial
+          outputColumnNames: _col0, _col1, _col2, _col3
+          Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
+          Select Operator
+            expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: bigint)
+            outputColumnNames: _col0, _col1, _col2, _col3
+            Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
+            File Output Operator
+              compressed: false
+              Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  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_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

[... 292 lines stripped ...]


Mime
View raw message