You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by sz...@apache.org on 2014/11/12 00:46:35 UTC
svn commit: r1638597 [2/2] - in /hive/trunk:
metastore/src/java/org/apache/hadoop/hive/metastore/parser/ExpressionTree.java
ql/src/test/queries/clientpositive/partition_multilevels.q
ql/src/test/results/clientpositive/partition_multilevels.q.out
Added: hive/trunk/ql/src/test/results/clientpositive/partition_multilevels.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_multilevels.q.out?rev=1638597&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_multilevels.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_multilevels.q.out Tue Nov 11 23:46:34 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
+#### A masked pattern was here ####
+1111 111 22 12
[... 290 lines stripped ...]