http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out b/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out index 496c5ba..92babd7 100644 --- a/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out +++ b/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out @@ -87,6 +87,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -118,6 +119,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -140,6 +142,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -179,6 +182,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -215,6 +219,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -244,6 +249,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -264,6 +270,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -299,6 +306,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -328,6 +336,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -348,6 +357,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -459,6 +469,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -481,6 +492,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -524,6 +536,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:string:int @@ -554,6 +567,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:string:int @@ -654,6 +668,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -685,6 +700,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -707,6 +723,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -746,6 +763,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -782,6 +800,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -811,6 +830,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -831,6 +851,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -866,6 +887,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -895,6 +917,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -915,6 +938,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1018,6 +1042,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1049,6 +1074,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1071,6 +1097,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1110,6 +1137,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1146,6 +1174,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1175,6 +1204,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1195,6 +1225,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1230,6 +1261,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1259,6 +1291,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1279,6 +1312,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -1390,6 +1424,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -1421,6 +1456,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1443,6 +1479,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1482,6 +1519,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -1518,6 +1556,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -1547,6 +1586,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -1567,6 +1607,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -1602,6 +1643,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -1631,6 +1673,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -1651,6 +1694,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -1763,6 +1807,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1785,6 +1830,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1828,6 +1874,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -1858,6 +1905,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -1959,6 +2007,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1981,6 +2030,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2024,6 +2074,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -2054,6 +2105,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,cnt columns.comments columns.types int:int:int @@ -2167,6 +2219,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2189,6 +2242,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2232,6 +2286,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2262,6 +2317,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2374,6 +2430,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2425,6 +2482,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2456,6 +2514,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2478,6 +2537,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2517,6 +2577,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2553,6 +2614,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2582,6 +2644,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2602,6 +2665,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2637,6 +2701,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2666,6 +2731,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2686,6 +2752,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2816,6 +2883,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2838,6 +2906,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2877,6 +2946,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat properties: + column.name.delimiter , columns _col0,_col1 columns.types string,bigint escape.delim \ @@ -2922,6 +2992,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2961,6 +3032,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -2988,6 +3060,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat properties: + column.name.delimiter , columns _col0,_col1 columns.types string,bigint escape.delim \ @@ -2997,6 +3070,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat properties: + column.name.delimiter , columns _col0,_col1 columns.types string,bigint escape.delim \ @@ -3012,6 +3086,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3034,6 +3109,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3074,6 +3150,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3110,6 +3187,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3139,6 +3217,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3159,6 +3238,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3194,6 +3274,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3223,6 +3304,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3243,6 +3325,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3398,6 +3481,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3420,6 +3504,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3465,6 +3550,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3495,6 +3581,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -3611,6 +3698,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3633,6 +3721,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3668,6 +3757,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat properties: + column.name.delimiter , columns _col0,_col1,_col2 columns.types string,string,bigint escape.delim \ @@ -3727,6 +3817,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat properties: + column.name.delimiter , columns _col0,_col1,_col2 columns.types string,string,bigint escape.delim \ @@ -3736,6 +3827,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat properties: + column.name.delimiter , columns _col0,_col1,_col2 columns.types string,string,bigint escape.delim \ @@ -3751,6 +3843,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3773,6 +3866,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3905,6 +3999,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3927,6 +4022,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3970,6 +4066,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -4000,6 +4097,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -4098,6 +4196,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4129,6 +4228,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4151,6 +4251,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4190,6 +4291,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4226,6 +4328,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4255,6 +4358,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4275,6 +4379,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4310,6 +4415,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4339,6 +4445,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4359,6 +4466,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4473,6 +4581,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,key4,cnt columns.comments columns.types int:int:string:int:int @@ -4504,6 +4613,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4526,6 +4636,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4565,6 +4676,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,key4,cnt columns.comments columns.types int:int:string:int:int @@ -4601,6 +4713,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,key4,cnt columns.comments columns.types int:int:string:int:int @@ -4630,6 +4743,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,key4,cnt columns.comments columns.types int:int:string:int:int @@ -4650,6 +4764,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,key4,cnt columns.comments columns.types int:int:string:int:int @@ -4685,6 +4800,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,key4,cnt columns.comments columns.types int:int:string:int:int @@ -4714,6 +4830,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,key4,cnt columns.comments columns.types int:int:string:int:int @@ -4734,6 +4851,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,key4,cnt columns.comments columns.types int:int:string:int:int @@ -4847,6 +4965,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4878,6 +4997,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4900,6 +5020,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4939,6 +5060,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -4975,6 +5097,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5004,6 +5127,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5024,6 +5148,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5059,6 +5184,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5088,6 +5214,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5108,6 +5235,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5228,6 +5356,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5259,6 +5388,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -5281,6 +5411,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -5320,6 +5451,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5356,6 +5488,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5385,6 +5518,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5405,6 +5539,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5440,6 +5575,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5469,6 +5605,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int @@ -5489,6 +5626,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,key2,key3,cnt columns.comments columns.types int:int:string:int
http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/groupby_sort_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_sort_6.q.out b/ql/src/test/results/clientpositive/groupby_sort_6.q.out index 843fb3b..80baa66 100644 --- a/ql/src/test/results/clientpositive/groupby_sort_6.q.out +++ b/ql/src/test/results/clientpositive/groupby_sort_6.q.out @@ -83,6 +83,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -113,6 +114,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -231,6 +233,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -261,6 +264,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -353,6 +357,7 @@ STAGE PLANS: ds 2 properties: bucket_count -1 + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -374,6 +379,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -415,6 +421,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int @@ -445,6 +452,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,cnt columns.comments columns.types int:int