http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out b/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out index 4f58719..9c09302 100644 --- a/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out +++ b/ql/src/test/results/clientpositive/groupby_sort_skew_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 @@ -460,6 +470,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -482,6 +493,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -517,6 +529,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 \ @@ -549,6 +562,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 \ @@ -558,6 +572,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 \ @@ -590,6 +605,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 @@ -620,6 +636,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 @@ -720,6 +737,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 @@ -751,6 +769,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -773,6 +792,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -812,6 +832,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 @@ -848,6 +869,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 @@ -877,6 +899,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 @@ -897,6 +920,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 @@ -932,6 +956,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 @@ -961,6 +986,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 @@ -981,6 +1007,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 @@ -1084,6 +1111,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 @@ -1115,6 +1143,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1137,6 +1166,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1176,6 +1206,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 @@ -1212,6 +1243,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 @@ -1241,6 +1273,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 @@ -1261,6 +1294,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 @@ -1296,6 +1330,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 @@ -1325,6 +1360,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 @@ -1345,6 +1381,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 @@ -1456,6 +1493,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 @@ -1487,6 +1525,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1509,6 +1548,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1548,6 +1588,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 @@ -1584,6 +1625,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 @@ -1613,6 +1655,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 @@ -1633,6 +1676,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 @@ -1668,6 +1712,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 @@ -1697,6 +1742,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 @@ -1717,6 +1763,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 @@ -1830,6 +1877,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1852,6 +1900,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -1887,6 +1936,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 \ @@ -1919,6 +1969,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 \ @@ -1928,6 +1979,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 \ @@ -1960,6 +2012,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 @@ -1990,6 +2043,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 @@ -2092,6 +2146,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2114,6 +2169,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2149,6 +2205,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,double,bigint escape.delim \ @@ -2181,6 +2238,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,double,bigint escape.delim \ @@ -2190,6 +2248,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,double,bigint escape.delim \ @@ -2222,6 +2281,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 @@ -2252,6 +2312,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 @@ -2366,6 +2427,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2388,6 +2450,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2423,6 +2486,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 double,bigint escape.delim \ @@ -2455,6 +2519,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 double,bigint escape.delim \ @@ -2464,6 +2529,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 double,bigint escape.delim \ @@ -2496,6 +2562,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 @@ -2526,6 +2593,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 @@ -2638,6 +2706,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 @@ -2689,6 +2758,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 @@ -2720,6 +2790,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2742,6 +2813,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -2781,6 +2853,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 @@ -2817,6 +2890,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 @@ -2846,6 +2920,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 @@ -2866,6 +2941,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 @@ -2901,6 +2977,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 @@ -2930,6 +3007,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 @@ -2950,6 +3028,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 @@ -3081,6 +3160,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3103,6 +3183,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3138,6 +3219,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 double,bigint escape.delim \ @@ -3170,6 +3252,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 double,bigint escape.delim \ @@ -3179,6 +3262,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 double,bigint escape.delim \ @@ -3207,6 +3291,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 \ @@ -3252,6 +3337,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 @@ -3291,6 +3377,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 @@ -3318,6 +3405,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 \ @@ -3327,6 +3415,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 \ @@ -3342,6 +3431,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3364,6 +3454,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3404,6 +3495,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 @@ -3440,6 +3532,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 @@ -3469,6 +3562,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 @@ -3489,6 +3583,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 @@ -3524,6 +3619,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 @@ -3553,6 +3649,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 @@ -3573,6 +3670,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 @@ -3728,6 +3826,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3750,6 +3849,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3795,6 +3895,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 @@ -3825,6 +3926,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 @@ -3942,6 +4044,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3964,6 +4067,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -3999,6 +4103,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 \ @@ -4031,6 +4136,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 \ @@ -4040,6 +4146,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 \ @@ -4064,6 +4171,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 \ @@ -4123,6 +4231,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 \ @@ -4132,6 +4241,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 \ @@ -4147,6 +4257,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4169,6 +4280,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4302,6 +4414,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4324,6 +4437,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4359,6 +4473,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 \ @@ -4391,6 +4506,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 \ @@ -4400,6 +4516,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 \ @@ -4432,6 +4549,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 @@ -4462,6 +4580,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 @@ -4560,6 +4679,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 @@ -4591,6 +4711,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4613,6 +4734,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4652,6 +4774,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 @@ -4688,6 +4811,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 @@ -4717,6 +4841,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 @@ -4737,6 +4862,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 @@ -4772,6 +4898,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 @@ -4801,6 +4928,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 @@ -4821,6 +4949,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 @@ -4935,6 +5064,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 @@ -4966,6 +5096,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -4988,6 +5119,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -5027,6 +5159,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 @@ -5063,6 +5196,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 @@ -5092,6 +5226,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 @@ -5112,6 +5247,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 @@ -5147,6 +5283,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 @@ -5176,6 +5313,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 @@ -5196,6 +5334,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 @@ -5309,6 +5448,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 @@ -5340,6 +5480,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -5362,6 +5503,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -5401,6 +5543,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 @@ -5437,6 +5580,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 @@ -5466,6 +5610,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 @@ -5486,6 +5631,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 @@ -5521,6 +5667,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 @@ -5550,6 +5697,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 @@ -5570,6 +5718,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 @@ -5690,6 +5839,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 @@ -5721,6 +5871,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -5743,6 +5894,7 @@ STAGE PLANS: SORTBUCKETCOLSPREFIX TRUE bucket_count 2 bucket_field_name key + column.name.delimiter , columns key,val columns.comments columns.types string:string @@ -5782,6 +5934,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 @@ -5818,6 +5971,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 @@ -5847,6 +6001,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 @@ -5867,6 +6022,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 @@ -5902,6 +6058,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 @@ -5931,6 +6088,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 @@ -5951,6 +6109,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/input23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input23.q.out b/ql/src/test/results/clientpositive/input23.q.out index c911cbf..80ee81b 100644 --- a/ql/src/test/results/clientpositive/input23.q.out +++ b/ql/src/test/results/clientpositive/input23.q.out @@ -61,6 +61,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -82,6 +83,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/input42.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input42.q.out b/ql/src/test/results/clientpositive/input42.q.out index adf1523..7b9e639 100644 --- a/ql/src/test/results/clientpositive/input42.q.out +++ b/ql/src/test/results/clientpositive/input42.q.out @@ -21,6 +21,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -42,6 +43,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -65,6 +67,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -86,6 +89,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -1146,6 +1150,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -1167,6 +1172,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -1190,6 +1196,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -1211,6 +1218,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -1653,6 +1661,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -1674,6 +1683,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -1697,6 +1707,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -1718,6 +1729,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/input_part1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input_part1.q.out b/ql/src/test/results/clientpositive/input_part1.q.out index 16c450b..2f6f302 100644 --- a/ql/src/test/results/clientpositive/input_part1.q.out +++ b/ql/src/test/results/clientpositive/input_part1.q.out @@ -53,6 +53,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -85,6 +86,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -106,6 +108,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -143,6 +146,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -179,6 +183,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -208,6 +213,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -228,6 +234,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -263,6 +270,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -292,6 +300,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -312,6 +321,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/input_part2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input_part2.q.out b/ql/src/test/results/clientpositive/input_part2.q.out index 2500035..95f36ab 100644 --- a/ql/src/test/results/clientpositive/input_part2.q.out +++ b/ql/src/test/results/clientpositive/input_part2.q.out @@ -70,6 +70,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -109,6 +110,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -141,6 +143,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -162,6 +165,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -187,6 +191,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -208,6 +213,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -246,6 +252,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -282,6 +289,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -311,6 +319,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -331,6 +340,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -366,6 +376,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -395,6 +406,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -415,6 +427,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -460,6 +473,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -496,6 +510,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -525,6 +540,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -545,6 +561,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -580,6 +597,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -609,6 +627,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string @@ -629,6 +648,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,hr,ds columns.comments columns.types int:string:string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/input_part7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input_part7.q.out b/ql/src/test/results/clientpositive/input_part7.q.out index 3543d0e..724f070 100644 --- a/ql/src/test/results/clientpositive/input_part7.q.out +++ b/ql/src/test/results/clientpositive/input_part7.q.out @@ -86,6 +86,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -107,6 +108,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -132,6 +134,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -153,6 +156,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/input_part9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input_part9.q.out b/ql/src/test/results/clientpositive/input_part9.q.out index 91da0c5..a6aee99 100644 --- a/ql/src/test/results/clientpositive/input_part9.q.out +++ b/ql/src/test/results/clientpositive/input_part9.q.out @@ -21,6 +21,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -42,6 +43,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -65,6 +67,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -86,6 +89,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/join17.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join17.q.out b/ql/src/test/results/clientpositive/join17.q.out index 6c8ed4f..8bd67eb 100644 --- a/ql/src/test/results/clientpositive/join17.q.out +++ b/ql/src/test/results/clientpositive/join17.q.out @@ -76,6 +76,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -96,6 +97,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -141,6 +143,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,value1,key2,value2 columns.comments columns.types int:string:int:string @@ -171,6 +174,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key1,value1,key2,value2 columns.comments columns.types int:string:int:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/join26.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join26.q.out b/ql/src/test/results/clientpositive/join26.q.out index 8889804..8004208 100644 --- a/ql/src/test/results/clientpositive/join26.q.out +++ b/ql/src/test/results/clientpositive/join26.q.out @@ -110,6 +110,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -144,6 +145,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -165,6 +167,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -202,6 +205,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -238,6 +242,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -267,6 +272,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -287,6 +293,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -322,6 +329,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -351,6 +359,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -371,6 +380,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/join32.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join32.q.out b/ql/src/test/results/clientpositive/join32.q.out index ef4582e..0358968 100644 --- a/ql/src/test/results/clientpositive/join32.q.out +++ b/ql/src/test/results/clientpositive/join32.q.out @@ -122,6 +122,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -153,6 +154,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -173,6 +175,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -197,6 +200,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -217,6 +221,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -244,6 +249,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -265,6 +271,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -293,6 +300,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/join33.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join33.q.out b/ql/src/test/results/clientpositive/join33.q.out index ef4582e..0358968 100644 --- a/ql/src/test/results/clientpositive/join33.q.out +++ b/ql/src/test/results/clientpositive/join33.q.out @@ -122,6 +122,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -153,6 +154,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -173,6 +175,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -197,6 +200,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -217,6 +221,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -244,6 +249,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -265,6 +271,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -293,6 +300,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string http://git-wip-us.apache.org/repos/asf/hive/blob/588c3911/ql/src/test/results/clientpositive/join34.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join34.q.out b/ql/src/test/results/clientpositive/join34.q.out index 391f0b4..117afac 100644 --- a/ql/src/test/results/clientpositive/join34.q.out +++ b/ql/src/test/results/clientpositive/join34.q.out @@ -102,6 +102,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -160,6 +161,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string @@ -191,6 +193,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -211,6 +214,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -235,6 +239,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -255,6 +260,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + column.name.delimiter , columns key,value columns.comments 'default','default' columns.types string:string @@ -285,6 +291,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + column.name.delimiter , columns key,value,val2 columns.comments columns.types string:string:string