Index: metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreUtils.java =================================================================== --- metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreUtils.java (revision 1523883) +++ metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreUtils.java (working copy) @@ -623,10 +623,17 @@ public static Properties getPartitionMetadata( org.apache.hadoop.hive.metastore.api.Partition partition, org.apache.hadoop.hive.metastore.api.Table table) { + Map parameters = partition.getParameters(); + if (table != null && table.getParameters() != null) { + Map overlayed = new HashMap(table.getParameters()); + if (parameters != null) { + overlayed.putAll(parameters); + } + parameters = overlayed; + } return MetaStoreUtils - .getSchema(partition.getSd(), partition.getSd(), partition - .getParameters(), table.getDbName(), table.getTableName(), - table.getPartitionKeys()); + .getSchema(partition.getSd(), partition.getSd(), parameters, table.getDbName(), + table.getTableName(), table.getPartitionKeys()); } public static Properties getSchema( Index: ql/src/test/results/clientpositive/groupby_ppr.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby_ppr.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/groupby_ppr.q.out (working copy) @@ -69,6 +69,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -115,6 +116,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/input_part7.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part7.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/input_part7.q.out (working copy) @@ -149,6 +149,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -195,6 +196,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin5.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin5.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin5.q.out (working copy) @@ -244,6 +244,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -291,6 +292,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -791,6 +793,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -838,6 +841,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/pcr.q.out =================================================================== --- ql/src/test/results/clientpositive/pcr.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/pcr.q.out (working copy) @@ -122,6 +122,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -167,6 +168,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -321,6 +323,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -366,6 +369,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -411,6 +415,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -609,6 +614,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -654,6 +660,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -816,6 +823,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -861,6 +869,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1025,6 +1034,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1070,6 +1080,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1115,6 +1126,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1290,6 +1302,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1335,6 +1348,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1380,6 +1394,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1559,6 +1574,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1604,6 +1620,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1745,6 +1762,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1790,6 +1808,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -1971,6 +1990,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -2016,6 +2036,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -2061,6 +2082,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -2276,6 +2298,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -2321,6 +2344,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -2480,6 +2504,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -2758,6 +2783,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -2803,6 +2829,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 3 numRows 20 partition_columns ds rawDataSize 160 @@ -3096,6 +3123,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -3141,6 +3169,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -3186,6 +3215,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -3231,6 +3261,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -3435,6 +3466,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -3480,6 +3512,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -3525,6 +3558,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -3801,6 +3835,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -4355,6 +4390,7 @@ #### A masked pattern was here #### name default.pcr_t1 numFiles 1 + numPartitions 4 numRows 20 partition_columns ds rawDataSize 160 @@ -4905,6 +4941,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -5078,6 +5115,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -5124,6 +5162,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -5303,6 +5342,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -5349,6 +5389,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/join33.q.out =================================================================== --- ql/src/test/results/clientpositive/join33.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/join33.q.out (working copy) @@ -53,6 +53,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -280,6 +281,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/input_part2.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part2.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/input_part2.q.out (working copy) @@ -144,6 +144,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -190,6 +191,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/alter_partition_coltype.q.out =================================================================== --- ql/src/test/results/clientpositive/alter_partition_coltype.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/alter_partition_coltype.q.out (working copy) @@ -144,6 +144,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 2 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -331,6 +332,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -487,6 +489,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -533,6 +536,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -579,6 +583,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -820,6 +825,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -866,6 +872,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -912,6 +919,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -1053,6 +1061,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -1099,6 +1108,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 @@ -1145,6 +1155,7 @@ #### A masked pattern was here #### name default.alter_coltype numFiles 1 + numPartitions 3 numRows 25 partition_columns dt/ts rawDataSize 191 Index: ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out (working copy) @@ -129,6 +129,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -136,6 +137,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -279,6 +281,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -286,6 +289,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -408,6 +412,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -415,6 +420,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -454,6 +460,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -461,6 +468,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -553,6 +561,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -560,6 +569,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -600,6 +610,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -607,6 +618,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -647,6 +659,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -654,6 +667,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -735,6 +749,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -742,6 +757,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -834,6 +850,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -841,6 +858,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -881,6 +899,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -888,6 +907,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -928,6 +948,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -935,6 +956,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1045,6 +1067,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -1052,6 +1075,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/load_dyn_part8.q.out =================================================================== --- ql/src/test/results/clientpositive/load_dyn_part8.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/load_dyn_part8.q.out (working copy) @@ -154,6 +154,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -200,6 +201,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -246,6 +248,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -292,6 +295,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/groupby_map_ppr.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby_map_ppr.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/groupby_map_ppr.q.out (working copy) @@ -86,6 +86,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -132,6 +133,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/groupby_sort_6.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby_sort_6.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/groupby_sort_6.q.out (working copy) @@ -406,6 +406,7 @@ #### A masked pattern was here #### name default.t1 numFiles 1 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/push_or.q.out =================================================================== --- ql/src/test/results/clientpositive/push_or.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/push_or.q.out (working copy) @@ -98,6 +98,7 @@ #### A masked pattern was here #### name default.push_or numFiles 1 + numPartitions 2 numRows 20 partition_columns ds rawDataSize 160 @@ -143,6 +144,7 @@ #### A masked pattern was here #### name default.push_or numFiles 1 + numPartitions 2 numRows 20 partition_columns ds rawDataSize 160 Index: ql/src/test/results/clientpositive/bucketcontext_7.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketcontext_7.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketcontext_7.q.out (working copy) @@ -112,6 +112,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -119,6 +120,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -158,6 +160,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -165,6 +168,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -265,6 +269,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -272,6 +277,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -313,6 +319,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -320,6 +327,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -466,6 +474,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -473,6 +482,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -514,6 +524,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -521,6 +532,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out (working copy) @@ -109,6 +109,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -207,6 +208,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -254,6 +256,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -301,6 +304,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -432,6 +436,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -530,6 +535,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -577,6 +583,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -624,6 +631,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -748,6 +756,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -854,6 +863,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -901,6 +911,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/combine2_hadoop20.q.out =================================================================== --- ql/src/test/results/clientpositive/combine2_hadoop20.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/combine2_hadoop20.q.out (working copy) @@ -249,6 +249,7 @@ #### A masked pattern was here #### name default.combine2 numFiles 1 + numPartitions 8 numRows 1 partition_columns value rawDataSize 2 @@ -294,6 +295,7 @@ #### A masked pattern was here #### name default.combine2 numFiles 1 + numPartitions 8 numRows 3 partition_columns value rawDataSize 3 @@ -339,6 +341,7 @@ #### A masked pattern was here #### name default.combine2 numFiles 1 + numPartitions 8 numRows 1 partition_columns value rawDataSize 1 @@ -384,6 +387,7 @@ #### A masked pattern was here #### name default.combine2 numFiles 1 + numPartitions 8 numRows 1 partition_columns value rawDataSize 1 @@ -429,6 +433,7 @@ #### A masked pattern was here #### name default.combine2 numFiles 1 + numPartitions 8 numRows 3 partition_columns value rawDataSize 3 @@ -474,6 +479,7 @@ #### A masked pattern was here #### name default.combine2 numFiles 1 + numPartitions 8 numRows 1 partition_columns value rawDataSize 1 @@ -519,6 +525,7 @@ #### A masked pattern was here #### name default.combine2 numFiles 1 + numPartitions 8 numRows 1 partition_columns value rawDataSize 1 @@ -564,6 +571,7 @@ #### A masked pattern was here #### name default.combine2 numFiles 1 + numPartitions 8 numRows 1 partition_columns value rawDataSize 2 Index: ql/src/test/results/clientpositive/bucketcontext_2.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketcontext_2.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketcontext_2.q.out (working copy) @@ -87,6 +87,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -94,6 +95,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -194,6 +196,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -201,6 +204,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -242,6 +246,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -249,6 +254,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -393,6 +399,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -400,6 +407,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -441,6 +449,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -448,6 +457,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out (working copy) @@ -96,6 +96,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -142,6 +143,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/filter_join_breaktask.q.out =================================================================== --- ql/src/test/results/clientpositive/filter_join_breaktask.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/filter_join_breaktask.q.out (working copy) @@ -98,6 +98,7 @@ #### A masked pattern was here #### name default.filter_join_breaktask numFiles 1 + numPartitions 1 numRows 25 partition_columns ds rawDataSize 211 @@ -227,6 +228,7 @@ #### A masked pattern was here #### name default.filter_join_breaktask numFiles 1 + numPartitions 1 numRows 25 partition_columns ds rawDataSize 211 Index: ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out =================================================================== --- ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out (working copy) @@ -116,6 +116,7 @@ partition values: part 1 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 1 bucket_field_name key columns key,value @@ -123,6 +124,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 1 + numPartitions 1 numRows 500 partition_columns part rawDataSize 5312 Index: ql/src/test/results/clientpositive/input_part9.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part9.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/input_part9.q.out (working copy) @@ -70,6 +70,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -116,6 +117,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin7.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin7.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin7.q.out (working copy) @@ -82,6 +82,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -203,6 +204,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 1 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin11.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin11.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin11.q.out (working copy) @@ -149,6 +149,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 4 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -194,6 +195,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -300,6 +302,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -347,6 +350,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 4 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -481,6 +485,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 4 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -526,6 +531,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -632,6 +638,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -679,6 +686,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 4 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 Index: ql/src/test/results/clientpositive/join26.q.out =================================================================== --- ql/src/test/results/clientpositive/join26.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/join26.q.out (working copy) @@ -146,6 +146,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out (working copy) @@ -91,6 +91,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 3 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin2.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin2.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin2.q.out (working copy) @@ -108,6 +108,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -235,6 +236,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -648,6 +650,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -780,6 +783,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -1387,6 +1391,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1432,6 +1437,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1564,6 +1570,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/join_map_ppr.q.out =================================================================== --- ql/src/test/results/clientpositive/join_map_ppr.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/join_map_ppr.q.out (working copy) @@ -148,6 +148,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -698,6 +699,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/join9.q.out =================================================================== --- ql/src/test/results/clientpositive/join9.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/join9.q.out (working copy) @@ -115,6 +115,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/smb_mapjoin_11.q.out =================================================================== --- ql/src/test/results/clientpositive/smb_mapjoin_11.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/smb_mapjoin_11.q.out (working copy) @@ -128,6 +128,7 @@ partition values: ds 1 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 16 bucket_field_name key columns key,value @@ -135,6 +136,7 @@ #### A masked pattern was here #### name default.test_table1 numFiles 16 + numPartitions 1 numRows 500 partition_columns ds rawDataSize 5312 Index: ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out =================================================================== --- ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out (working copy) @@ -79,6 +79,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -125,6 +126,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -270,6 +272,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -316,6 +319,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -362,6 +366,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -408,6 +413,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out (working copy) @@ -133,6 +133,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -140,6 +141,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -181,6 +183,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -188,6 +191,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -332,6 +336,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -339,6 +344,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -380,6 +386,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -387,6 +394,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -510,6 +518,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -517,6 +526,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -609,6 +619,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -616,6 +627,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -657,6 +669,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -664,6 +677,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -704,6 +718,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -711,6 +726,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -793,6 +809,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -800,6 +817,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -840,6 +858,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -847,6 +866,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -939,6 +959,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -946,6 +967,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -987,6 +1009,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -994,6 +1017,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1034,6 +1058,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -1041,6 +1066,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -1150,6 +1176,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1157,6 +1184,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1198,6 +1226,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1205,6 +1234,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/sample1.q.out =================================================================== --- ql/src/test/results/clientpositive/sample1.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/sample1.q.out (working copy) @@ -94,6 +94,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/rand_partitionpruner3.q.out =================================================================== --- ql/src/test/results/clientpositive/rand_partitionpruner3.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/rand_partitionpruner3.q.out (working copy) @@ -73,6 +73,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -200,6 +201,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketcontext_4.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketcontext_4.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketcontext_4.q.out (working copy) @@ -99,6 +99,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -106,6 +107,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -145,6 +147,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -152,6 +155,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -252,6 +256,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -259,6 +264,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -402,6 +408,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -409,6 +416,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/merge3.q.out =================================================================== --- ql/src/test/results/clientpositive/merge3.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/merge3.q.out (working copy) @@ -2437,6 +2437,7 @@ #### A masked pattern was here #### name default.merge_src_part numFiles 2 + numPartitions 2 numRows 1000 partition_columns ds rawDataSize 10624 @@ -2482,6 +2483,7 @@ #### A masked pattern was here #### name default.merge_src_part numFiles 2 + numPartitions 2 numRows 1000 partition_columns ds rawDataSize 10624 @@ -4864,6 +4866,7 @@ #### A masked pattern was here #### name default.merge_src_part numFiles 2 + numPartitions 2 numRows 1000 partition_columns ds rawDataSize 10624 @@ -4909,6 +4912,7 @@ #### A masked pattern was here #### name default.merge_src_part numFiles 2 + numPartitions 2 numRows 1000 partition_columns ds rawDataSize 10624 Index: ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out =================================================================== --- ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out (working copy) @@ -159,6 +159,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 @@ -204,6 +205,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 @@ -302,6 +304,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 @@ -349,6 +352,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 Index: ql/src/test/results/clientpositive/bucketmapjoin9.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin9.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin9.q.out (working copy) @@ -95,6 +95,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 3 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 @@ -193,6 +194,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 @@ -363,6 +365,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -461,6 +464,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin13.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin13.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin13.q.out (working copy) @@ -123,6 +123,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 500 partition_columns part rawDataSize 5312 @@ -221,6 +222,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 @@ -268,6 +270,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 @@ -416,6 +419,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 500 partition_columns part rawDataSize 5312 @@ -522,6 +526,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 @@ -681,6 +686,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 500 partition_columns part rawDataSize 5312 @@ -787,6 +793,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 @@ -948,6 +955,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 500 partition_columns part rawDataSize 5312 @@ -1054,6 +1062,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 500 partition_columns part rawDataSize 5312 Index: ql/src/test/results/clientpositive/union22.q.out =================================================================== --- ql/src/test/results/clientpositive/union22.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/union22.q.out (working copy) @@ -118,6 +118,7 @@ #### A masked pattern was here #### name default.dst_union22_delta numFiles 1 + numPartitions 1 numRows 500 partition_columns ds rawDataSize 16936 @@ -257,6 +258,7 @@ #### A masked pattern was here #### name default.dst_union22 numFiles 1 + numPartitions 1 numRows 500 partition_columns ds rawDataSize 11124 @@ -302,6 +304,7 @@ #### A masked pattern was here #### name default.dst_union22_delta numFiles 1 + numPartitions 1 numRows 500 partition_columns ds rawDataSize 16936 @@ -481,6 +484,7 @@ #### A masked pattern was here #### name default.dst_union22_delta numFiles 1 + numPartitions 1 numRows 500 partition_columns ds rawDataSize 16936 @@ -627,6 +631,7 @@ #### A masked pattern was here #### name default.dst_union22 numFiles 1 + numPartitions 1 numRows 500 partition_columns ds rawDataSize 11124 @@ -672,6 +677,7 @@ #### A masked pattern was here #### name default.dst_union22_delta numFiles 1 + numPartitions 1 numRows 500 partition_columns ds rawDataSize 16936 Index: ql/src/test/results/clientpositive/join32.q.out =================================================================== --- ql/src/test/results/clientpositive/join32.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/join32.q.out (working copy) @@ -53,6 +53,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -280,6 +281,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/input_part1.q.out =================================================================== --- ql/src/test/results/clientpositive/input_part1.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/input_part1.q.out (working copy) @@ -90,6 +90,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out (working copy) @@ -142,6 +142,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -149,6 +150,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -190,6 +192,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -197,6 +200,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -343,6 +347,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -350,6 +355,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -391,6 +397,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -398,6 +405,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -525,6 +533,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -532,6 +541,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -571,6 +581,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -578,6 +589,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -670,6 +682,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -677,6 +690,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -718,6 +732,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -725,6 +740,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -765,6 +781,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -772,6 +789,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -812,6 +830,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -819,6 +838,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -901,6 +921,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -908,6 +929,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -948,6 +970,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -955,6 +978,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1047,6 +1071,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1054,6 +1079,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1095,6 +1121,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1102,6 +1129,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1142,6 +1170,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -1149,6 +1178,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1189,6 +1219,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -1196,6 +1227,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1306,6 +1338,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1313,6 +1346,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1354,6 +1388,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1361,6 +1396,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/columnstats_partlvl.q.out =================================================================== --- ql/src/test/results/clientpositive/columnstats_partlvl.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/columnstats_partlvl.q.out (working copy) @@ -144,6 +144,7 @@ #### A masked pattern was here #### name default.employee_part numFiles 1 + numPartitions 2 numRows 0 partition_columns employeesalary rawDataSize 0 @@ -351,6 +352,7 @@ #### A masked pattern was here #### name default.employee_part numFiles 1 + numPartitions 2 numRows 0 partition_columns employeesalary rawDataSize 0 Index: ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out (working copy) @@ -117,6 +117,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -124,6 +125,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -267,6 +269,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -274,6 +277,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -396,6 +400,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -403,6 +408,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -442,6 +448,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -449,6 +456,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -541,6 +549,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -548,6 +557,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -588,6 +598,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -595,6 +606,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -635,6 +647,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -642,6 +655,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -723,6 +737,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -730,6 +745,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -822,6 +838,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -829,6 +846,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -869,6 +887,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -876,6 +895,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -916,6 +936,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -923,6 +944,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1033,6 +1055,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1040,6 +1063,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/sample8.q.out =================================================================== --- ql/src/test/results/clientpositive/sample8.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/sample8.q.out (working copy) @@ -84,6 +84,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -130,6 +131,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -176,6 +178,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -222,6 +225,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/transform_ppr2.q.out =================================================================== --- ql/src/test/results/clientpositive/transform_ppr2.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/transform_ppr2.q.out (working copy) @@ -91,6 +91,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -137,6 +138,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/union_ppr.q.out =================================================================== --- ql/src/test/results/clientpositive/union_ppr.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/union_ppr.q.out (working copy) @@ -151,6 +151,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -197,6 +198,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/ppd_vc.q.out =================================================================== --- ql/src/test/results/clientpositive/ppd_vc.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/ppd_vc.q.out (working copy) @@ -75,6 +75,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -121,6 +122,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -167,6 +169,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -213,6 +216,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -444,6 +448,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -490,6 +495,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -536,6 +542,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -582,6 +589,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out =================================================================== --- ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out (working copy) @@ -109,6 +109,7 @@ #### A masked pattern was here #### name default.dynamic_part_table numFiles 1 + numPartitions 4 numRows 1 partition_columns partcol1/partcol2 rawDataSize 1 @@ -212,6 +213,7 @@ #### A masked pattern was here #### name default.dynamic_part_table numFiles 1 + numPartitions 4 numRows 1 partition_columns partcol1/partcol2 rawDataSize 1 @@ -315,6 +317,7 @@ #### A masked pattern was here #### name default.dynamic_part_table numFiles 1 + numPartitions 4 numRows 1 partition_columns partcol1/partcol2 rawDataSize 1 @@ -361,6 +364,7 @@ #### A masked pattern was here #### name default.dynamic_part_table numFiles 1 + numPartitions 4 numRows 1 partition_columns partcol1/partcol2 rawDataSize 1 Index: ql/src/test/results/clientpositive/bucketcontext_6.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketcontext_6.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketcontext_6.q.out (working copy) @@ -146,6 +146,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -153,6 +154,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -194,6 +196,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -201,6 +204,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -343,6 +347,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -350,6 +355,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -391,6 +397,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -398,6 +405,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/router_join_ppr.q.out =================================================================== --- ql/src/test/results/clientpositive/router_join_ppr.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/router_join_ppr.q.out (working copy) @@ -135,6 +135,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -181,6 +182,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -227,6 +229,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -273,6 +276,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -542,6 +546,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -588,6 +593,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -846,6 +852,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -892,6 +899,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1152,6 +1160,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1198,6 +1207,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1244,6 +1254,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1290,6 +1301,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketcontext_1.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketcontext_1.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketcontext_1.q.out (working copy) @@ -99,6 +99,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -106,6 +107,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -206,6 +208,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -213,6 +216,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -254,6 +258,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -261,6 +266,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -405,6 +411,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -412,6 +419,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -453,6 +461,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -460,6 +469,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/input42.q.out =================================================================== --- ql/src/test/results/clientpositive/input42.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/input42.q.out (working copy) @@ -65,6 +65,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -111,6 +112,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1256,6 +1258,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1302,6 +1305,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1825,6 +1829,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1871,6 +1876,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin10.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin10.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin10.q.out (working copy) @@ -143,6 +143,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 3 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -188,6 +189,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -286,6 +288,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 @@ -333,6 +336,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 3 + numPartitions 2 numRows 0 partition_columns part rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin1.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin1.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin1.q.out (working copy) @@ -365,6 +365,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -984,6 +985,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/sample10.q.out =================================================================== --- ql/src/test/results/clientpositive/sample10.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/sample10.q.out (working copy) @@ -114,6 +114,7 @@ #### A masked pattern was here #### name default.srcpartbucket numFiles 4 + numPartitions 4 numRows 10 partition_columns ds/hr rawDataSize 60 @@ -162,6 +163,7 @@ #### A masked pattern was here #### name default.srcpartbucket numFiles 4 + numPartitions 4 numRows 10 partition_columns ds/hr rawDataSize 60 @@ -210,6 +212,7 @@ #### A masked pattern was here #### name default.srcpartbucket numFiles 4 + numPartitions 4 numRows 10 partition_columns ds/hr rawDataSize 60 @@ -258,6 +261,7 @@ #### A masked pattern was here #### name default.srcpartbucket numFiles 4 + numPartitions 4 numRows 10 partition_columns ds/hr rawDataSize 60 Index: ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out (working copy) @@ -460,15 +460,22 @@ input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value columns.types string:string #### A masked pattern was here #### name default.bucket_small + numFiles 4 + numPartitions 0 + numRows 0 + rawDataSize 0 serialization.ddl struct bucket_small { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 226 +#### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat @@ -635,15 +642,22 @@ input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value columns.types string:string #### A masked pattern was here #### name default.bucket_small + numFiles 4 + numPartitions 0 + numRows 0 + rawDataSize 0 serialization.ddl struct bucket_small { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 226 +#### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe input format: org.apache.hadoop.mapred.TextInputFormat Index: ql/src/test/results/clientpositive/louter_join_ppr.q.out =================================================================== --- ql/src/test/results/clientpositive/louter_join_ppr.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/louter_join_ppr.q.out (working copy) @@ -133,6 +133,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -179,6 +180,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -439,6 +441,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -485,6 +488,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -531,6 +535,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -577,6 +582,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -848,6 +854,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -894,6 +901,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -940,6 +948,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -986,6 +995,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1250,6 +1260,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1296,6 +1307,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketcontext_8.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketcontext_8.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketcontext_8.q.out (working copy) @@ -112,6 +112,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -119,6 +120,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -158,6 +160,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -165,6 +168,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -265,6 +269,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -272,6 +277,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -313,6 +319,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -320,6 +327,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -466,6 +474,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -473,6 +482,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -514,6 +524,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -521,6 +532,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/avro_partitioned.q.out =================================================================== --- ql/src/test/results/clientpositive/avro_partitioned.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/avro_partitioned.q.out (working copy) @@ -161,6 +161,103 @@ POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +PREHOOK: query: CREATE TABLE episodes_partitioned_projection +PARTITIONED BY (doctor INT) +ROW FORMAT + SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' +STORED AS + INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' + OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' +TBLPROPERTIES ('avro.schema.literal'='{ + "name": "episode_projection", + "type": "record", + "fields": [ + {"name":"title", "type":"string"}, + {"name":"air_date", "type":"string"} + ] +}') +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE episodes_partitioned_projection +PARTITIONED BY (doctor INT) +ROW FORMAT + SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' +STORED AS + INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' + OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' +TBLPROPERTIES ('avro.schema.literal'='{ + "name": "episode_projection", + "type": "record", + "fields": [ + {"name":"title", "type":"string"}, + {"name":"air_date", "type":"string"} + ] +}') +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@episodes_partitioned_projection +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +PREHOOK: query: INSERT OVERWRITE TABLE episodes_partitioned_projection PARTITION (doctor) SELECT title, air_date, doctor FROM episodes WHERE doctor <= 6 +PREHOOK: type: QUERY +PREHOOK: Input: default@episodes +PREHOOK: Output: default@episodes_partitioned_projection +POSTHOOK: query: INSERT OVERWRITE TABLE episodes_partitioned_projection PARTITION (doctor) SELECT title, air_date, doctor FROM episodes WHERE doctor <= 6 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@episodes +POSTHOOK: Output: default@episodes_partitioned_projection@doctor=1 +POSTHOOK: Output: default@episodes_partitioned_projection@doctor=2 +POSTHOOK: Output: default@episodes_partitioned_projection@doctor=4 +POSTHOOK: Output: default@episodes_partitioned_projection@doctor=5 +POSTHOOK: Output: default@episodes_partitioned_projection@doctor=6 +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=11).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] PREHOOK: query: SELECT * FROM episodes_partitioned WHERE doctor_pt > 6 ORDER BY air_date PREHOOK: type: QUERY PREHOOK: Input: default@episodes_partitioned @@ -194,6 +291,16 @@ POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] The Doctor's Wife 14 May 2011 11 11 Rose 26 March 2005 9 9 The Eleventh Hour 3 April 2010 11 11 @@ -242,6 +349,16 @@ POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] An Unearthly Child 23 November 1963 1 1 The Eleventh Hour 3 April 2010 11 11 The Doctor's Wife 14 May 2011 11 11 @@ -280,6 +397,16 @@ POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] The Mysterious Planet 6 September 1986 6 6 PREHOOK: query: -- Fetch w/non-existant partition SELECT * FROM episodes_partitioned WHERE doctor_pt = 7 LIMIT 5 @@ -312,3 +439,13 @@ POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).doctor SIMPLE [(episodes)episodes.FieldSchema(name:doctor, type:int, comment:from deserializer), ] POSTHOOK: Lineage: episodes_partitioned PARTITION(doctor_pt=9).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=1).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=2).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=4).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=5).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).air_date SIMPLE [(episodes)episodes.FieldSchema(name:air_date, type:string, comment:from deserializer), ] +POSTHOOK: Lineage: episodes_partitioned_projection PARTITION(doctor=6).title SIMPLE [(episodes)episodes.FieldSchema(name:title, type:string, comment:from deserializer), ] Index: ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out (working copy) @@ -130,6 +130,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -137,6 +138,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -181,6 +183,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 3 bucket_field_name key columns key,value @@ -188,6 +191,7 @@ #### A masked pattern was here #### name default.bucket_medium numFiles 3 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -232,6 +236,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 3 bucket_field_name key columns key,value @@ -239,6 +244,7 @@ #### A masked pattern was here #### name default.bucket_medium numFiles 3 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -381,6 +387,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -388,6 +395,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -429,6 +437,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -436,6 +445,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -477,6 +487,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 3 bucket_field_name key columns key,value @@ -484,6 +495,7 @@ #### A masked pattern was here #### name default.bucket_medium numFiles 3 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -525,6 +537,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -532,6 +545,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/rand_partitionpruner2.q.out =================================================================== --- ql/src/test/results/clientpositive/rand_partitionpruner2.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/rand_partitionpruner2.q.out (working copy) @@ -94,6 +94,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -140,6 +141,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketcontext_3.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketcontext_3.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketcontext_3.q.out (working copy) @@ -87,6 +87,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -94,6 +95,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -133,6 +135,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -140,6 +143,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -240,6 +244,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -247,6 +252,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -390,6 +396,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -397,6 +404,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out =================================================================== --- ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out (working copy) @@ -71,6 +71,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -117,6 +118,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out =================================================================== --- ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out (working copy) @@ -95,6 +95,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 500 partition_columns part rawDataSize 5312 @@ -194,6 +195,7 @@ partition values: part 1 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -201,6 +203,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 1 numRows 500 partition_columns part rawDataSize 5312 Index: ql/src/test/results/clientpositive/bucketmapjoin8.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin8.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin8.q.out (working copy) @@ -89,6 +89,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 @@ -195,6 +196,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 @@ -336,6 +338,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 @@ -442,6 +445,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin12.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin12.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin12.q.out (working copy) @@ -117,6 +117,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 @@ -222,6 +223,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 @@ -354,6 +356,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_3 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 @@ -452,6 +455,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_1 numFiles 2 + numPartitions 1 numRows 0 partition_columns part rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin3.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin3.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin3.q.out (working copy) @@ -125,6 +125,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -252,6 +253,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -665,6 +667,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -797,6 +800,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/smb_mapjoin_12.q.out =================================================================== --- ql/src/test/results/clientpositive/smb_mapjoin_12.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/smb_mapjoin_12.q.out (working copy) @@ -149,6 +149,7 @@ partition values: ds 1 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 16 bucket_field_name key columns key,value @@ -156,6 +157,7 @@ #### A masked pattern was here #### name default.test_table1 numFiles 16 + numPartitions 1 numRows 500 partition_columns ds rawDataSize 5312 @@ -378,6 +380,7 @@ partition values: ds 1 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 16 bucket_field_name key columns key,value @@ -385,6 +388,7 @@ #### A masked pattern was here #### name default.test_table3 numFiles 16 + numPartitions 1 numRows 3084 partition_columns ds rawDataSize 32904 Index: ql/src/test/results/clientpositive/join32_lessSize.q.out =================================================================== --- ql/src/test/results/clientpositive/join32_lessSize.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/join32_lessSize.q.out (working copy) @@ -204,6 +204,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -335,6 +336,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -1884,6 +1886,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -2015,6 +2018,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -2075,7 +2079,6 @@ Stats-Aggr Operator #### A masked pattern was here #### - PREHOOK: query: INSERT OVERWRITE TABLE dest_j2 SELECT res.key, z.value, res.value FROM (select x.key, x.value from src1 x JOIN src y ON (x.key = y.key)) res @@ -2415,6 +2418,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -2551,6 +2555,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out (working copy) @@ -142,6 +142,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -149,6 +150,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -190,6 +192,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -197,6 +200,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -343,6 +347,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -350,6 +355,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -391,6 +397,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -398,6 +405,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -523,6 +531,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -530,6 +539,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -569,6 +579,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -576,6 +587,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -668,6 +680,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -675,6 +688,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -716,6 +730,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -723,6 +738,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -763,6 +779,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -770,6 +787,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -810,6 +828,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -817,6 +836,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -899,6 +919,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -906,6 +927,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -946,6 +968,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -953,6 +976,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1045,6 +1069,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -1052,6 +1077,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1093,6 +1119,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -1100,6 +1127,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1140,6 +1168,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1147,6 +1176,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1187,6 +1217,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -1194,6 +1225,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1304,6 +1336,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -1311,6 +1344,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -1352,6 +1386,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -1359,6 +1394,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/outer_join_ppr.q.out =================================================================== --- ql/src/test/results/clientpositive/outer_join_ppr.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/outer_join_ppr.q.out (working copy) @@ -125,6 +125,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -171,6 +172,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -217,6 +219,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -263,6 +266,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -524,6 +528,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -570,6 +575,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -616,6 +622,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -662,6 +669,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out =================================================================== --- ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out (working copy) @@ -98,6 +98,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -143,6 +144,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part_2 numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out =================================================================== --- ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out (working copy) @@ -117,6 +117,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -124,6 +125,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -165,6 +167,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -172,6 +175,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -297,6 +301,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -304,6 +309,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -396,6 +402,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -403,6 +410,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -444,6 +452,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -451,6 +460,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -491,6 +501,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -498,6 +509,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -580,6 +592,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -587,6 +600,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -627,6 +641,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -634,6 +649,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -726,6 +742,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -733,6 +750,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -774,6 +792,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -781,6 +800,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -821,6 +841,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 4 bucket_field_name key columns key,value @@ -828,6 +849,7 @@ #### A masked pattern was here #### name default.bucket_small numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -937,6 +959,7 @@ partition values: ds 2008-04-08 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -944,6 +967,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 @@ -985,6 +1009,7 @@ partition values: ds 2008-04-09 properties: + SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key columns key,value @@ -992,6 +1017,7 @@ #### A masked pattern was here #### name default.bucket_big numFiles 2 + numPartitions 2 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/transform_ppr1.q.out =================================================================== --- ql/src/test/results/clientpositive/transform_ppr1.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/transform_ppr1.q.out (working copy) @@ -89,6 +89,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -135,6 +136,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -181,6 +183,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 @@ -227,6 +230,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/clientpositive/ppd_union_view.q.out =================================================================== --- ql/src/test/results/clientpositive/ppd_union_view.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/ppd_union_view.q.out (working copy) @@ -257,6 +257,7 @@ #### A masked pattern was here #### name default.t1_mapping numFiles 1 + numPartitions 2 numRows 1 partition_columns ds rawDataSize 12 @@ -302,6 +303,7 @@ #### A masked pattern was here #### name default.t1_old numFiles 1 + numPartitions 2 numRows 1 partition_columns ds rawDataSize 14 @@ -477,6 +479,7 @@ Fetch Operator limit: -1 + PREHOOK: query: select * from t1 where ds = '2011-10-13' PREHOOK: type: QUERY PREHOOK: Input: default@t1 @@ -764,6 +767,7 @@ #### A masked pattern was here #### name default.t1_new numFiles 1 + numPartitions 2 numRows 1 partition_columns ds rawDataSize 11 Index: ql/src/test/results/clientpositive/stats11.q.out =================================================================== --- ql/src/test/results/clientpositive/stats11.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/stats11.q.out (working copy) @@ -312,6 +312,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 @@ -931,6 +932,7 @@ #### A masked pattern was here #### name default.srcbucket_mapjoin_part numFiles 4 + numPartitions 1 numRows 0 partition_columns ds rawDataSize 0 Index: ql/src/test/results/clientpositive/input23.q.out =================================================================== --- ql/src/test/results/clientpositive/input23.q.out (revision 1523883) +++ ql/src/test/results/clientpositive/input23.q.out (working copy) @@ -70,6 +70,7 @@ #### A masked pattern was here #### name default.srcpart numFiles 1 + numPartitions 4 numRows 0 partition_columns ds/hr rawDataSize 0 Index: ql/src/test/results/compiler/plan/join2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join2.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/join2.q.xml (working copy) @@ -197,6 +197,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -213,6 +217,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -225,6 +241,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -232,6 +252,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -1775,6 +1799,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -1791,6 +1819,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -1803,6 +1843,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -1810,6 +1854,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -1923,6 +1971,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -1939,6 +1991,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -1951,6 +2015,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -1958,6 +2026,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input2.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input2.q.xml (working copy) @@ -1593,6 +1593,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -1609,6 +1613,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -1621,6 +1637,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -1628,6 +1648,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/join3.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join3.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/join3.q.xml (working copy) @@ -186,6 +186,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -202,6 +206,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -214,6 +230,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -221,6 +241,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -334,6 +358,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -350,6 +378,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -362,6 +402,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -369,6 +413,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -482,6 +530,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -498,6 +550,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -510,6 +574,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -517,6 +585,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input3.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input3.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input3.q.xml (working copy) @@ -1963,6 +1963,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -1979,6 +1983,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -1991,6 +2007,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -1998,6 +2018,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/join4.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join4.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/join4.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -181,6 +205,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -197,6 +225,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -209,6 +249,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -216,6 +260,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input4.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input4.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input4.q.xml (working copy) @@ -186,6 +186,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -202,6 +206,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -214,6 +230,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -221,6 +241,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/join5.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join5.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/join5.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -181,6 +205,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -197,6 +225,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -209,6 +249,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -216,6 +260,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input5.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input5.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input5.q.xml (working copy) @@ -186,6 +186,10 @@ default.src_thrift + numFiles + 1 + + columns.types @@ -202,6 +206,18 @@ org.apache.thrift.protocol.TBinaryProtocol + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + serialization.class org.apache.hadoop.hive.serde2.thrift.test.Complex @@ -218,6 +234,10 @@ org.apache.hadoop.mapred.SequenceFileInputFormat + totalSize + 1606 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -225,6 +245,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/join6.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join6.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/join6.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -181,6 +205,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -197,6 +225,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -209,6 +249,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -216,6 +260,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input_testxpath2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input_testxpath2.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input_testxpath2.q.xml (working copy) @@ -33,6 +33,10 @@ default.src_thrift + numFiles + 1 + + columns.types @@ -49,6 +53,18 @@ org.apache.thrift.protocol.TBinaryProtocol + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + serialization.class org.apache.hadoop.hive.serde2.thrift.test.Complex @@ -65,6 +81,10 @@ org.apache.hadoop.mapred.SequenceFileInputFormat + totalSize + 1606 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -72,6 +92,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input6.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input6.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input6.q.xml (working copy) @@ -554,6 +554,10 @@ default.src1 + numFiles + 1 + + columns.types string:string @@ -570,6 +574,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -582,6 +598,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 216 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -589,6 +609,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/join7.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join7.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/join7.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -181,6 +205,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -197,6 +225,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -209,6 +249,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -216,6 +260,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -329,6 +377,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -345,6 +397,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -357,6 +421,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -364,6 +432,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input7.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input7.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input7.q.xml (working copy) @@ -554,6 +554,10 @@ default.src1 + numFiles + 1 + + columns.types string:string @@ -570,6 +574,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -582,6 +598,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 216 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -589,6 +609,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input_testsequencefile.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input_testsequencefile.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input_testsequencefile.q.xml (working copy) @@ -554,6 +554,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -570,6 +574,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -582,6 +598,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -589,6 +609,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input8.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input8.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input8.q.xml (working copy) @@ -33,6 +33,10 @@ default.src1 + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 216 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/join8.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join8.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/join8.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -181,6 +205,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -197,6 +225,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -209,6 +249,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -216,6 +260,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/union.q.xml =================================================================== --- ql/src/test/results/compiler/plan/union.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/union.q.xml (working copy) @@ -427,6 +427,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -443,6 +447,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -455,6 +471,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -462,6 +482,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -575,6 +599,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -591,6 +619,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -603,6 +643,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -610,6 +654,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input9.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input9.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input9.q.xml (working copy) @@ -554,6 +554,10 @@ default.src1 + numFiles + 1 + + columns.types string:string @@ -570,6 +574,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -582,6 +598,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 216 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -589,6 +609,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/udf1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/udf1.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/udf1.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/udf4.q.xml =================================================================== --- ql/src/test/results/compiler/plan/udf4.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/udf4.q.xml (working copy) @@ -68,6 +68,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input_testxpath.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input_testxpath.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input_testxpath.q.xml (working copy) @@ -33,6 +33,10 @@ default.src_thrift + numFiles + 1 + + columns.types @@ -49,6 +53,18 @@ org.apache.thrift.protocol.TBinaryProtocol + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + serialization.class org.apache.hadoop.hive.serde2.thrift.test.Complex @@ -65,6 +81,10 @@ org.apache.hadoop.mapred.SequenceFileInputFormat + totalSize + 1606 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -72,6 +92,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/udf6.q.xml =================================================================== --- ql/src/test/results/compiler/plan/udf6.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/udf6.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input_part1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input_part1.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input_part1.q.xml (working copy) @@ -70,6 +70,10 @@ 0 + numPartitions + 4 + + partition_columns ds/hr @@ -929,6 +933,10 @@ 0 + numPartitions + 4 + + partition_columns ds/hr Index: ql/src/test/results/compiler/plan/groupby1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/groupby1.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/groupby1.q.xml (working copy) @@ -186,6 +186,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -202,6 +206,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -214,6 +230,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -221,6 +241,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/udf_case.q.xml =================================================================== --- ql/src/test/results/compiler/plan/udf_case.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/udf_case.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/groupby2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/groupby2.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/groupby2.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/subq.q.xml =================================================================== --- ql/src/test/results/compiler/plan/subq.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/subq.q.xml (working copy) @@ -427,6 +427,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -443,6 +447,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -455,6 +471,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -462,6 +482,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/groupby3.q.xml =================================================================== --- ql/src/test/results/compiler/plan/groupby3.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/groupby3.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/groupby4.q.xml =================================================================== --- ql/src/test/results/compiler/plan/groupby4.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/groupby4.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/groupby5.q.xml =================================================================== --- ql/src/test/results/compiler/plan/groupby5.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/groupby5.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/groupby6.q.xml =================================================================== --- ql/src/test/results/compiler/plan/groupby6.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/groupby6.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/case_sensitivity.q.xml =================================================================== --- ql/src/test/results/compiler/plan/case_sensitivity.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/case_sensitivity.q.xml (working copy) @@ -554,6 +554,10 @@ default.src_thrift + numFiles + 1 + + columns.types @@ -570,6 +574,18 @@ org.apache.thrift.protocol.TBinaryProtocol + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + serialization.class org.apache.hadoop.hive.serde2.thrift.test.Complex @@ -586,6 +602,10 @@ org.apache.hadoop.mapred.SequenceFileInputFormat + totalSize + 1606 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -593,6 +613,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/udf_when.q.xml =================================================================== --- ql/src/test/results/compiler/plan/udf_when.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/udf_when.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input20.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input20.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input20.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/sample1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample1.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/sample1.q.xml (working copy) @@ -70,6 +70,10 @@ 0 + numPartitions + 4 + + partition_columns ds/hr @@ -1028,6 +1032,10 @@ 0 + numPartitions + 4 + + partition_columns ds/hr Index: ql/src/test/results/compiler/plan/sample2.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample2.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/sample2.q.xml (working copy) @@ -554,6 +554,10 @@ default.srcbucket + numFiles + 2 + + columns.types int:string @@ -574,6 +578,18 @@ 1 + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count 2 @@ -586,6 +602,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 11603 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -593,6 +613,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/sample3.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample3.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/sample3.q.xml (working copy) @@ -554,6 +554,10 @@ default.srcbucket + numFiles + 2 + + columns.types int:string @@ -574,6 +578,18 @@ 1 + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count 2 @@ -586,6 +602,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 11603 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -593,6 +613,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/sample4.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample4.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/sample4.q.xml (working copy) @@ -554,6 +554,10 @@ default.srcbucket + numFiles + 2 + + columns.types int:string @@ -574,6 +578,18 @@ 1 + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count 2 @@ -586,6 +602,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 11603 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -593,6 +613,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/sample5.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample5.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/sample5.q.xml (working copy) @@ -554,6 +554,10 @@ default.srcbucket + numFiles + 2 + + columns.types int:string @@ -574,6 +578,18 @@ 1 + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count 2 @@ -586,6 +602,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 11603 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -593,6 +613,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/sample6.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample6.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/sample6.q.xml (working copy) @@ -554,6 +554,10 @@ default.srcbucket + numFiles + 2 + + columns.types int:string @@ -574,6 +578,18 @@ 1 + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count 2 @@ -586,6 +602,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 11603 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -593,6 +613,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/sample7.q.xml =================================================================== --- ql/src/test/results/compiler/plan/sample7.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/sample7.q.xml (working copy) @@ -554,6 +554,10 @@ default.srcbucket + numFiles + 2 + + columns.types int:string @@ -574,6 +578,18 @@ 1 + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count 2 @@ -586,6 +602,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 11603 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -593,6 +613,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/cast1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/cast1.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/cast1.q.xml (working copy) @@ -33,6 +33,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -49,6 +53,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -61,6 +77,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -68,6 +88,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/join1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/join1.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/join1.q.xml (working copy) @@ -186,6 +186,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -202,6 +206,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -214,6 +230,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -221,6 +241,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + @@ -334,6 +358,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -350,6 +378,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -362,6 +402,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -369,6 +413,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/results/compiler/plan/input1.q.xml =================================================================== --- ql/src/test/results/compiler/plan/input1.q.xml (revision 1523883) +++ ql/src/test/results/compiler/plan/input1.q.xml (working copy) @@ -554,6 +554,10 @@ default.src + numFiles + 1 + + columns.types string:string @@ -570,6 +574,18 @@ key,value + rawDataSize + 0 + + + numRows + 0 + + + numPartitions + 0 + + bucket_count -1 @@ -582,6 +598,10 @@ org.apache.hadoop.mapred.TextInputFormat + totalSize + 5812 + + file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -589,6 +609,10 @@ location #### A masked pattern was here #### + + transient_lastDdlTime + #### A masked pattern was here #### + Index: ql/src/test/queries/clientpositive/avro_partitioned.q =================================================================== --- ql/src/test/queries/clientpositive/avro_partitioned.q (revision 1523883) +++ ql/src/test/queries/clientpositive/avro_partitioned.q (working copy) @@ -63,6 +63,24 @@ SET hive.exec.dynamic.partition.mode=nonstrict; INSERT OVERWRITE TABLE episodes_partitioned PARTITION (doctor_pt) SELECT title, air_date, doctor, doctor as doctor_pt FROM episodes; +CREATE TABLE episodes_partitioned_projection +PARTITIONED BY (doctor INT) +ROW FORMAT + SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' +STORED AS + INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' + OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' +TBLPROPERTIES ('avro.schema.literal'='{ + "name": "episode_projection", + "type": "record", + "fields": [ + {"name":"title", "type":"string"}, + {"name":"air_date", "type":"string"} + ] +}'); + +INSERT OVERWRITE TABLE episodes_partitioned_projection PARTITION (doctor) SELECT title, air_date, doctor FROM episodes WHERE doctor <= 6; + SELECT * FROM episodes_partitioned WHERE doctor_pt > 6 ORDER BY air_date; -- Verify that Fetch works in addition to Map