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: _col0, _col1, _col2 Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() keys: _col0 (type: string), _col1 (type: string), _col2 (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 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: _col0, _col1, _col2 Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() keys: _col0 (type: string), _col1 (type: string), _col2 (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