hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prasan...@apache.org
Subject [45/51] [partial] hive git commit: HIVE-14376: Schema evolution tests takes a long time (Prasanth Jayachandran reviewed by Matt McCline)
Date Thu, 11 Aug 2016 00:09:57 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q b/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q
index 9fa020a..4935397 100644
--- a/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q
+++ b/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q
@@ -45,12 +45,12 @@ insert into table table_add_int_permute_select
            (10, 6, 'new', 200);
 
 explain
-select insert_num,a,b from table_add_int_permute_select order by insert_num;
+select insert_num,a,b from table_add_int_permute_select;
 
 -- SELECT permutation columns to make sure NULL defaulting works right
-select insert_num,a,b from table_add_int_permute_select order by insert_num;
-select insert_num,a,b,c from table_add_int_permute_select order by insert_num;
-select insert_num,c from table_add_int_permute_select order by insert_num;
+select insert_num,a,b from table_add_int_permute_select;
+select insert_num,a,b,c from table_add_int_permute_select;
+select insert_num,c from table_add_int_permute_select;
 
 drop table table_add_int_permute_select;
 
@@ -82,16 +82,16 @@ insert into table table_add_int_string_permute_select
            (10, 6, 'new', 200, 'two hundred');
 
 explain
-select insert_num,a,b from table_add_int_string_permute_select order by insert_num;
+select insert_num,a,b from table_add_int_string_permute_select;
 
 -- SELECT permutation columns to make sure NULL defaulting works right
-select insert_num,a,b from table_add_int_string_permute_select order by insert_num;
-select insert_num,a,b,c from table_add_int_string_permute_select order by insert_num;
-select insert_num,a,b,c,d from table_add_int_string_permute_select order by insert_num;
-select insert_num,a,c,d from table_add_int_string_permute_select order by insert_num;
-select insert_num,a,d from table_add_int_string_permute_select order by insert_num;
-select insert_num,c from table_add_int_string_permute_select order by insert_num;
-select insert_num,d from table_add_int_string_permute_select order by insert_num;
+select insert_num,a,b from table_add_int_string_permute_select;
+select insert_num,a,b,c from table_add_int_string_permute_select;
+select insert_num,a,b,c,d from table_add_int_string_permute_select;
+select insert_num,a,c,d from table_add_int_string_permute_select;
+select insert_num,a,d from table_add_int_string_permute_select;
+select insert_num,c from table_add_int_string_permute_select;
+select insert_num,d from table_add_int_string_permute_select;
 
 drop table table_add_int_string_permute_select;
 
@@ -126,9 +126,9 @@ insert into table table_change_string_group_double
            (10, 9250340.75 , 9250340.75 , 9250340.75 , 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_string_group_double;
 
-select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_string_group_double;
 
 drop table table_change_string_group_double;
 
@@ -159,9 +159,9 @@ insert into table table_change_date_group_string_group_timestamp
            (9, '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp;
 
-select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp;
 
 drop table table_change_date_group_string_group_timestamp;
 
@@ -189,9 +189,9 @@ insert into table table_change_date_group_string_group_date
            (9, '5966-07-09', '5966-07-09', '5966-07-09', '5966-07-09', '5966-07-09', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date;
 
-select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date;
 
 drop table table_change_date_group_string_group_date;
 
@@ -212,7 +212,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_string
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_multi_ints_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, c4 STRING, b STRING) ;
@@ -226,9 +226,9 @@ insert into table table_change_numeric_group_string_group_multi_ints_string
            (10, '17', '90000', '754072151', '3289094', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string;
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string;
 
 drop table table_change_numeric_group_string_group_multi_ints_string;
 
@@ -245,7 +245,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_char
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_multi_ints_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), c4 CHAR(50), b STRING) ;
@@ -259,9 +259,9 @@ insert into table table_change_numeric_group_string_group_multi_ints_char
            (10, '17', '90000', '754072151', '3289094', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char;
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char;
 
 drop table table_change_numeric_group_string_group_multi_ints_char;
 
@@ -277,7 +277,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_char_trunc
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_multi_ints_char_trunc replace columns (insert_num int, c1 CHAR(5), c2 CHAR(5), c3 CHAR(5), c4 CHAR(5), b STRING) ;
@@ -291,9 +291,9 @@ insert into table table_change_numeric_group_string_group_multi_ints_char_trunc
            (10, '17', '90000', '754072151', '3289094', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc;
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc;
 
 drop table table_change_numeric_group_string_group_multi_ints_char_trunc;
 
@@ -310,7 +310,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_varchar
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_multi_ints_varchar replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), c4 VARCHAR(50), b STRING) ;
@@ -324,9 +324,9 @@ insert into table table_change_numeric_group_string_group_multi_ints_varchar
            (10, '17', '90000', '754072151', '3289094', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar;
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar;
 
 drop table table_change_numeric_group_string_group_multi_ints_varchar;
 
@@ -342,7 +342,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_varchar_tru
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_multi_ints_varchar_trunc replace columns (insert_num int, c1 VARCHAR(5), c2 VARCHAR(5), c3 VARCHAR(5), c4 VARCHAR(5), b STRING) ;
@@ -356,9 +356,9 @@ insert into table table_change_numeric_group_string_group_multi_ints_varchar_tru
            (10, '17', '90000', '754072151', '3289094', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc;
 
-select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc;
 
 drop table table_change_numeric_group_string_group_multi_ints_varchar_trunc;
 
@@ -374,7 +374,7 @@ insert into table table_change_numeric_group_string_group_floating_string
            (3, - 832222222, 255, 4957,'original'),
            (4, 847492223, 0, 20435, 'original');
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_floating_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, b STRING) ;
@@ -388,9 +388,9 @@ insert into table table_change_numeric_group_string_group_floating_string
            (10, '17', '90000', '754072151', 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string;
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string;
 
 drop table table_change_numeric_group_string_group_floating_string;
 
@@ -406,7 +406,7 @@ insert into table table_change_numeric_group_string_group_floating_char
            (3,  9000000000, -255, 4957,'original'),
            (4, -999999999999, 0, 20435, 'original');
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_floating_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), b STRING) ;
@@ -420,9 +420,9 @@ insert into table table_change_numeric_group_string_group_floating_char
            (10, '17', '90000', '754072151', 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char;
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char;
 
 drop table table_change_numeric_group_string_group_floating_char;
 
@@ -438,7 +438,7 @@ insert into table table_change_numeric_group_string_group_floating_char_trunc
            (3, 832222222, -255, 4957, 'original'),
            (4, 847492223, 0, 20435, 'original');
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_floating_char_trunc replace columns (insert_num int, c1 CHAR(7), c2 CHAR(7), c3 CHAR(7), b STRING) ;
@@ -452,9 +452,9 @@ insert into table table_change_numeric_group_string_group_floating_char_trunc
            (10, '17', '90000', '754072151', 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc;
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc;
 
 drop table table_change_numeric_group_string_group_floating_char_trunc;
 
@@ -470,7 +470,7 @@ insert into table table_change_numeric_group_string_group_floating_varchar
            (3, 9000000000, -255, 4957, 'original'),
            (4, -999999999999, 0, 20435, 'original');
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_floating_varchar replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), b STRING) ;
@@ -484,9 +484,9 @@ insert into table table_change_numeric_group_string_group_floating_varchar
            (10, '17', '90000', '754072151', 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar;
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar;
 
 drop table table_change_numeric_group_string_group_floating_varchar;
 
@@ -502,7 +502,7 @@ insert into table table_change_numeric_group_string_group_floating_varchar_trunc
            (3, 9000000000, -255, 4957, 'original'),
            (4, -999999999999, 0, 20435, 'original');
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_numeric_group_string_group_floating_varchar_trunc replace columns (insert_num int, c1 VARCHAR(7), c2 VARCHAR(7), c3 VARCHAR(7), b STRING) ;
@@ -516,9 +516,9 @@ insert into table table_change_numeric_group_string_group_floating_varchar_trunc
            (10, '17', '90000', '754072151', 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc;
 
-select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc;
 
 drop table table_change_numeric_group_string_group_floating_varchar_trunc;
 
@@ -538,7 +538,7 @@ insert into table table_change_string_group_string_group_string
            (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'),
            (4, 'blank pads   ', 'blank pads   ', 'blank pads   ', 'blank pads   ', 'original');
 
-select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_string_group_string_group_string replace columns (insert_num int, c1 CHAR(50), c2 CHAR(9), c3 VARCHAR(50), c4 CHAR(9), b STRING) ;
@@ -552,9 +552,9 @@ insert into table table_change_string_group_string_group_string
            (10, 'bottom  ', 'bottom  ', 'bottom  ', 'bottom  ', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string;
 
-select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string;
 
 drop table table_change_string_group_string_group_string;
 
@@ -571,7 +571,7 @@ insert into table table_change_string_group_string_group_char
            (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'),
            (4, 'blank pads   ', 'blank pads   ', 'blank pads   ', 'original');
 
-select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_string_group_string_group_char replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(9), c3 STRING, b STRING) ;
@@ -585,9 +585,9 @@ insert into table table_change_string_group_string_group_char
            (10, 'bottom  ', 'bottom  ', 'bottom  ', 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char;
 
-select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char;
 
 drop table table_change_string_group_string_group_char;
 
@@ -604,7 +604,7 @@ insert into table table_change_string_group_string_group_varchar
            (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'),
            (4, 'blank pads   ', 'blank pads   ', 'blank pads   ', 'original');
 
-select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_string_group_string_group_varchar replace columns (insert_num int, c1 CHAR(50), c2 CHAR(9), c3 STRING, b STRING) ;
@@ -618,9 +618,9 @@ insert into table table_change_string_group_string_group_varchar
            (10, 'bottom  ', 'bottom  ', 'bottom  ', 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar;
 
-select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar;
 
 drop table table_change_string_group_string_group_varchar;
 
@@ -641,7 +641,7 @@ insert into table table_change_lower_to_higher_numeric_group_tinyint
            (3, -255, -255, -255, -255, -255, -255, 'original'),
            (4, 100, 100, 100, 100, 100, 100, 'original');
 
-select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING) ;
@@ -655,9 +655,9 @@ insert into table table_change_lower_to_higher_numeric_group_tinyint
            (10, '17', '90000', '754072151', '95', '20', '18', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint;
 
-select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint;
 
 drop table table_change_lower_to_higher_numeric_group_tinyint;
 
@@ -673,7 +673,7 @@ insert into table table_change_lower_to_higher_numeric_group_smallint
            (3, -5000, -5000, -5000, -5000, -5000, 'original'),
            (4, 100, 100, 100, 100, 100, 'original');
 
-select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING) ;
@@ -687,9 +687,9 @@ insert into table table_change_lower_to_higher_numeric_group_smallint
            (10, '17', '90000', '754072151', '95', '20', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint;
 
-select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num;
+select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint;
 
 drop table table_change_lower_to_higher_numeric_group_smallint;
 
@@ -706,7 +706,7 @@ insert into table table_change_lower_to_higher_numeric_group_int
            (3, -5000, -5000, -5000, -5000, 'original'),
            (4, 52927714, 52927714, 52927714, 52927714, 'original');
 
-select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE,  b STRING) ;
@@ -720,9 +720,9 @@ insert into table table_change_lower_to_higher_numeric_group_int
            (10, '17', '90000', '754072151', '95', 'new');
 
 explain
-select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int;
 
-select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num;
+select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int;
 
 drop table table_change_lower_to_higher_numeric_group_int;
 
@@ -738,7 +738,7 @@ insert into table table_change_lower_to_higher_numeric_group_bigint
            (3, -5000, -5000, -5000, 'original'),
            (4, 52927714, 52927714, 52927714, 'original');
 
-select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING) ;
@@ -752,9 +752,9 @@ insert into table table_change_lower_to_higher_numeric_group_bigint
            (10, '17', '90000', '754072151', 'new');
 
 explain
-select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint;
 
-select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num;
+select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint;
 
 drop table table_change_lower_to_higher_numeric_group_bigint;
 
@@ -770,7 +770,7 @@ insert into table table_change_lower_to_higher_numeric_group_decimal
            (3, -5000, -5000, 'original'),
            (4, 52927714, 52927714, 'original');
 
-select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num;
+select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) ;
@@ -784,9 +784,9 @@ insert into table table_change_lower_to_higher_numeric_group_decimal
            (10, '1.7', '17.8888', 'new');
 
 explain
-select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num;
+select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal;
 
-select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num;
+select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal;
 
 drop table table_change_lower_to_higher_numeric_group_decimal;
 
@@ -803,7 +803,7 @@ insert into table table_change_lower_to_higher_numeric_group_float
            (3, -5000, 'original'),
            (4, 52927714, 'original');
 
-select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num;
+select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) ;
@@ -817,8 +817,8 @@ insert into table table_change_lower_to_higher_numeric_group_float
            (10, '17', 'new');
 
 explain
-select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num;
+select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float;
 
-select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num;
+select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float;
 
-drop table table_change_lower_to_higher_numeric_group_float;
\ No newline at end of file
+drop table table_change_lower_to_higher_numeric_group_float;

http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part.q b/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part.q
index c21bf8f..5c8b2ae 100644
--- a/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part.q
+++ b/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part.q
@@ -48,12 +48,12 @@ insert into table part_add_int_permute_select partition(part=1)
            (10, 6, 'new', 200);
 
 explain
-select insert_num,part,a,b from part_add_int_permute_select order by insert_num;
+select insert_num,part,a,b from part_add_int_permute_select;
 
 -- SELECT permutation columns to make sure NULL defaulting works right
-select insert_num,part,a,b from part_add_int_permute_select order by insert_num;
-select insert_num,part,a,b,c from part_add_int_permute_select order by insert_num;
-select insert_num,part,c from part_add_int_permute_select order by insert_num;
+select insert_num,part,a,b from part_add_int_permute_select;
+select insert_num,part,a,b,c from part_add_int_permute_select;
+select insert_num,part,c from part_add_int_permute_select;
 
 drop table part_add_int_permute_select;
 
@@ -85,16 +85,16 @@ insert into table part_add_int_string_permute_select partition(part=1)
            (10, 6, 'new', 200, 'two hundred');
 
 explain
-select insert_num,part,a,b from part_add_int_string_permute_select order by insert_num;
+select insert_num,part,a,b from part_add_int_string_permute_select;
 
 -- SELECT permutation columns to make sure NULL defaulting works right
-select insert_num,part,a,b from part_add_int_string_permute_select order by insert_num;
-select insert_num,part,a,b,c from part_add_int_string_permute_select order by insert_num;
-select insert_num,part,a,b,c,d from part_add_int_string_permute_select order by insert_num;
-select insert_num,part,a,c,d from part_add_int_string_permute_select order by insert_num;
-select insert_num,part,a,d from part_add_int_string_permute_select order by insert_num;
-select insert_num,part,c from part_add_int_string_permute_select order by insert_num;
-select insert_num,part,d from part_add_int_string_permute_select order by insert_num;
+select insert_num,part,a,b from part_add_int_string_permute_select;
+select insert_num,part,a,b,c from part_add_int_string_permute_select;
+select insert_num,part,a,b,c,d from part_add_int_string_permute_select;
+select insert_num,part,a,c,d from part_add_int_string_permute_select;
+select insert_num,part,a,d from part_add_int_string_permute_select;
+select insert_num,part,c from part_add_int_string_permute_select;
+select insert_num,part,d from part_add_int_string_permute_select;
 
 drop table part_add_int_string_permute_select;
 
@@ -129,9 +129,9 @@ insert into table part_change_string_group_double partition(part=1)
            (10, 9250340.75 , 9250340.75 , 9250340.75 , 'new');
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_string_group_double order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_string_group_double;
 
-select insert_num,part,c1,c2,c3,b from part_change_string_group_double order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_string_group_double;
 
 drop table part_change_string_group_double;
 
@@ -162,9 +162,9 @@ insert into table part_change_date_group_string_group_timestamp partition(part=1
            (9, '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', '5966-07-09 03:30:50.597', 'new');
 
 explain
-select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp;
 
-select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp;
 
 drop table part_change_date_group_string_group_timestamp;
 
@@ -192,9 +192,9 @@ insert into table part_change_date_group_string_group_date partition(part=2)
            (9, '5966-07-09', '5966-07-09', '5966-07-09', '5966-07-09', '5966-07-09', 'new');
 
 explain
-select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date;
 
-select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date;
 
 drop table part_change_date_group_string_group_date;
 
@@ -215,7 +215,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_string parti
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_multi_ints_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, c4 STRING, b STRING) ;
@@ -229,9 +229,9 @@ insert into table part_change_numeric_group_string_group_multi_ints_string parti
            (10, '17', '90000', '754072151', '3289094', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string;
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string;
 
 drop table part_change_numeric_group_string_group_multi_ints_string;
 
@@ -248,7 +248,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_char partiti
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_multi_ints_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), c4 CHAR(50), b STRING) ;
@@ -262,9 +262,9 @@ insert into table part_change_numeric_group_string_group_multi_ints_char partiti
            (10, '17', '90000', '754072151', '3289094', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char;
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char;
 
 drop table part_change_numeric_group_string_group_multi_ints_char;
 
@@ -280,7 +280,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_char_trunc p
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_multi_ints_char_trunc replace columns (insert_num int, c1 CHAR(5), c2 CHAR(5), c3 CHAR(5), c4 CHAR(5), b STRING) ;
@@ -294,9 +294,9 @@ insert into table part_change_numeric_group_string_group_multi_ints_char_trunc p
            (10, '17', '90000', '754072151', '3289094', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc;
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc;
 
 drop table part_change_numeric_group_string_group_multi_ints_char_trunc;
 
@@ -313,7 +313,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_varchar part
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_multi_ints_varchar replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), c4 VARCHAR(50), b STRING) ;
@@ -327,9 +327,9 @@ insert into table part_change_numeric_group_string_group_multi_ints_varchar part
            (10, '17', '90000', '754072151', '3289094', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar;
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar;
 
 drop table part_change_numeric_group_string_group_multi_ints_varchar;
 
@@ -345,7 +345,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_varchar_trun
            (3, -255, 4957, 832222222, 9000000000, 'original'),
            (4, 0, 20435, 847492223, -999999999999, 'original');
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_multi_ints_varchar_trunc replace columns (insert_num int, c1 VARCHAR(5), c2 VARCHAR(5), c3 VARCHAR(5), c4 VARCHAR(5), b STRING) ;
@@ -359,9 +359,9 @@ insert into table part_change_numeric_group_string_group_multi_ints_varchar_trun
            (10, '17', '90000', '754072151', '3289094', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc;
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc;
 
 drop table part_change_numeric_group_string_group_multi_ints_varchar_trunc;
 
@@ -377,7 +377,7 @@ insert into table part_change_numeric_group_string_group_floating_string partiti
            (3, - 832222222, 255, 4957,'original'),
            (4, 847492223, 0, 20435, 'original');
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, b STRING) ;
@@ -391,9 +391,9 @@ insert into table part_change_numeric_group_string_group_floating_string partiti
            (10, '17', '90000', '754072151', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string;
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string;
 
 drop table part_change_numeric_group_string_group_floating_string;
 
@@ -409,7 +409,7 @@ insert into table part_change_numeric_group_string_group_floating_char partition
            (3,  9000000000, -255, 4957,'original'),
            (4, -999999999999, 0, 20435, 'original');
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), b STRING) ;
@@ -423,9 +423,9 @@ insert into table part_change_numeric_group_string_group_floating_char partition
            (10, '17', '90000', '754072151', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char;
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char;
 
 drop table part_change_numeric_group_string_group_floating_char;
 
@@ -441,7 +441,7 @@ insert into table part_change_numeric_group_string_group_floating_char_trunc par
            (3, 832222222, -255, 4957, 'original'),
            (4, 847492223, 0, 20435, 'original');
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_char_trunc replace columns (insert_num int, c1 CHAR(7), c2 CHAR(7), c3 CHAR(7), b STRING) ;
@@ -455,9 +455,9 @@ insert into table part_change_numeric_group_string_group_floating_char_trunc par
            (10, '17', '90000', '754072151', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc;
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc;
 
 drop table part_change_numeric_group_string_group_floating_char_trunc;
 
@@ -473,7 +473,7 @@ insert into table part_change_numeric_group_string_group_floating_varchar partit
            (3, 9000000000, -255, 4957, 'original'),
            (4, -999999999999, 0, 20435, 'original');
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_varchar replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), b STRING) ;
@@ -487,9 +487,9 @@ insert into table part_change_numeric_group_string_group_floating_varchar partit
            (10, '17', '90000', '754072151', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar;
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar;
 
 drop table part_change_numeric_group_string_group_floating_varchar;
 
@@ -505,7 +505,7 @@ insert into table part_change_numeric_group_string_group_floating_varchar_trunc
            (3, 9000000000, -255, 4957, 'original'),
            (4, -999999999999, 0, 20435, 'original');
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_varchar_trunc replace columns (insert_num int, c1 VARCHAR(7), c2 VARCHAR(7), c3 VARCHAR(7), b STRING) ;
@@ -519,9 +519,9 @@ insert into table part_change_numeric_group_string_group_floating_varchar_trunc
            (10, '17', '90000', '754072151', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc;
 
-select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc;
 
 drop table part_change_numeric_group_string_group_floating_varchar_trunc;
 
@@ -541,7 +541,7 @@ insert into table part_change_string_group_string_group_string partition(part=1)
            (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'),
            (4, 'blank pads   ', 'blank pads   ', 'blank pads   ', 'blank pads   ', 'original');
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_string_group_string_group_string replace columns (insert_num int, c1 CHAR(50), c2 CHAR(9), c3 VARCHAR(50), c4 CHAR(9), b STRING) ;
@@ -555,9 +555,9 @@ insert into table part_change_string_group_string_group_string partition(part)
            (10, 'bottom  ', 'bottom  ', 'bottom  ', 'bottom  ', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string;
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string;
 
 drop table part_change_string_group_string_group_string;
 
@@ -574,7 +574,7 @@ insert into table part_change_string_group_string_group_char partition(part=1)
            (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'),
            (4, 'blank pads   ', 'blank pads   ', 'blank pads   ', 'original');
 
-select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_string_group_string_group_char replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(9), c3 STRING, b STRING) ;
@@ -588,9 +588,9 @@ insert into table part_change_string_group_string_group_char partition(part)
            (10, 'bottom  ', 'bottom  ', 'bottom  ', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char;
 
-select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char;
 
 drop table part_change_string_group_string_group_char;
 
@@ -607,7 +607,7 @@ insert into table part_change_string_group_string_group_varchar partition(part=1
            (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'),
            (4, 'blank pads   ', 'blank pads   ', 'blank pads   ', 'original');
 
-select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_string_group_string_group_varchar replace columns (insert_num int, c1 CHAR(50), c2 CHAR(9), c3 STRING, b STRING) ;
@@ -621,9 +621,9 @@ insert into table part_change_string_group_string_group_varchar partition(part)
            (10, 'bottom  ', 'bottom  ', 'bottom  ', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar;
 
-select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar;
 
 drop table part_change_string_group_string_group_varchar;
 
@@ -644,7 +644,7 @@ insert into table part_change_lower_to_higher_numeric_group_tinyint partition(pa
            (3, -255, -255, -255, -255, -255, -255, 'original'),
            (4, 100, 100, 100, 100, 100, 100, 'original');
 
-select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING) ;
@@ -658,9 +658,9 @@ insert into table part_change_lower_to_higher_numeric_group_tinyint partition(pa
            (10, '17', '90000', '754072151', '95', '20', '18', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint;
 
-select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint;
 
 drop table part_change_lower_to_higher_numeric_group_tinyint;
 
@@ -676,7 +676,7 @@ insert into table part_change_lower_to_higher_numeric_group_smallint partition(p
            (3, -5000, -5000, -5000, -5000, -5000, 'original'),
            (4, 100, 100, 100, 100, 100, 'original');
 
-select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING) ;
@@ -690,9 +690,9 @@ insert into table part_change_lower_to_higher_numeric_group_smallint partition(p
            (10, '17', '90000', '754072151', '95', '20', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint;
 
-select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num;
+select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint;
 
 drop table part_change_lower_to_higher_numeric_group_smallint;
 
@@ -709,7 +709,7 @@ insert into table part_change_lower_to_higher_numeric_group_int partition(part=1
            (3, -5000, -5000, -5000, -5000, 'original'),
            (4, 52927714, 52927714, 52927714, 52927714, 'original');
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE,  b STRING) ;
@@ -723,9 +723,9 @@ insert into table part_change_lower_to_higher_numeric_group_int partition(part)
            (10, '17', '90000', '754072151', '95', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int;
 
-select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int order by insert_num;
+select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int;
 
 drop table part_change_lower_to_higher_numeric_group_int;
 
@@ -741,7 +741,7 @@ insert into table part_change_lower_to_higher_numeric_group_bigint partition(par
            (3, -5000, -5000, -5000, 'original'),
            (4, 52927714, 52927714, 52927714, 'original');
 
-select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING) ;
@@ -755,9 +755,9 @@ insert into table part_change_lower_to_higher_numeric_group_bigint partition(par
            (10, '17', '90000', '754072151', 'new', 1);
 
 explain
-select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint;
 
-select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint order by insert_num;
+select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint;
 
 drop table part_change_lower_to_higher_numeric_group_bigint;
 
@@ -773,7 +773,7 @@ insert into table part_change_lower_to_higher_numeric_group_decimal partition(pa
            (3, -5000, -5000, 'original'),
            (4, 52927714, 52927714, 'original');
 
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num;
+select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) ;
@@ -787,9 +787,9 @@ insert into table part_change_lower_to_higher_numeric_group_decimal partition(pa
            (10, '1.7', '17.8888', 'new', 1);
 
 explain
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num;
+select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal;
 
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num;
+select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal;
 
 drop table part_change_lower_to_higher_numeric_group_decimal;
 
@@ -805,7 +805,7 @@ insert into table part_change_lower_to_higher_numeric_group_float partition(part
            (3, -5000, 'original'),
            (4, 52927714, 'original');
 
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num;
+select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) ;
@@ -819,9 +819,9 @@ insert into table part_change_lower_to_higher_numeric_group_float partition(part
            (10, '17',  'new', 1);
 
 explain
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num;
+select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float;
 
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num;
+select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float;
 
 drop table part_change_lower_to_higher_numeric_group_float;
 

http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_complex.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_complex.q b/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_complex.q
index a914544..a3c49c8 100644
--- a/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_complex.q
+++ b/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_complex.q
@@ -31,7 +31,7 @@ load data local inpath '../../data/files/struct1_a.txt' overwrite into table str
 
 insert into table part_change_various_various_struct1 partition(part=1) select * from struct1_a_txt;
 
-select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num;
+select insert_num,part,s1,b from part_change_various_various_struct1;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_various_various_struct1 replace columns (insert_num int, s1 STRUCT<c1:STRING, c2:STRING, c3:STRING, c4:STRING, c5:STRING, c6:STRING, c7:STRING, c8:STRING, c9:STRING, c10:STRING, c11:STRING, c12:STRING, c13:STRING>, b STRING);
@@ -53,9 +53,9 @@ load data local inpath '../../data/files/struct1_c.txt' overwrite into table str
 insert into table part_change_various_various_struct1 partition(part=1) select * from struct1_c_txt;
 
 explain
-select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num;
+select insert_num,part,s1,b from part_change_various_various_struct1;
 
-select insert_num,part,s1,b from part_change_various_various_struct1 order by insert_num;
+select insert_num,part,s1,b from part_change_various_various_struct1;
 
 drop table part_change_various_various_struct1;
 
@@ -70,7 +70,7 @@ insert into table part_add_various_various_struct2 partition(part=1)
     values(1, 'original'),
           (2, 'original');
 
-select insert_num,part,b from part_add_various_various_struct2 order by insert_num;
+select insert_num,part,b from part_add_various_various_struct2;
 
 -- Table-Non-Cascade ADD COLUMN ...
 alter table part_add_various_various_struct2 ADD columns (s2 STRUCT<c1:BOOLEAN, c2:TINYINT, c3:SMALLINT, c4:INT, c5:BIGINT, c6:FLOAT, c7:DOUBLE, c8:DECIMAL(38,18), c9:CHAR(25), c10:VARCHAR(25), c11:TIMESTAMP, c12:DATE, c13:BINARY>);
@@ -91,7 +91,7 @@ load data local inpath '../../data/files/struct2_b.txt' overwrite into table str
 
 insert into table part_add_various_various_struct2 partition(part=2) select * from struct2_b_txt;
 
-select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num;
+select insert_num,part,b,s2 from part_add_various_various_struct2;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_add_various_various_struct2 REPLACE columns (insert_num int, b STRING, s2 STRUCT<c1:STRING, c2:STRING, c3:STRING, c4:STRING, c5:STRING, c6:STRING, c7:STRING, c8:STRING, c9:STRING, c10:STRING, c11:STRING, c12:STRING, c13:STRING>);
@@ -113,9 +113,9 @@ load data local inpath '../../data/files/struct2_d.txt' overwrite into table str
 insert into table part_add_various_various_struct2 partition(part=1) select * from struct2_d_txt;
 
 explain
-select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num;
+select insert_num,part,b,s2 from part_add_various_various_struct2;
 
-select insert_num,part,b,s2 from part_add_various_various_struct2 order by insert_num;
+select insert_num,part,b,s2 from part_add_various_various_struct2;
 
 drop table part_add_various_various_struct2;
 
@@ -135,7 +135,7 @@ load data local inpath '../../data/files/struct4_a.txt' overwrite into table str
 
 insert into table part_add_to_various_various_struct4 partition(part=1) select * from struct4_a_txt;
 
-select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num;
+select insert_num,part,b,s3 from part_add_to_various_various_struct4;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_add_to_various_various_struct4 replace columns (insert_num int, b STRING, s3 STRUCT<c1:BOOLEAN, c2:TINYINT, c3:SMALLINT, c4:INT, c5:BIGINT, c6:FLOAT, c7:DOUBLE, c8:DECIMAL(38,18), c9:CHAR(25), c10:VARCHAR(25), c11:TIMESTAMP, c12:DATE, c13:BINARY>);
@@ -157,8 +157,8 @@ load data local inpath '../../data/files/struct4_c.txt' overwrite into table str
 insert into table part_add_to_various_various_struct4 partition(part=1) select * from struct4_c_txt;
 
 explain
-select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num;
+select insert_num,part,b,s3 from part_add_to_various_various_struct4;
 
-select insert_num,part,b,s3 from part_add_to_various_various_struct4 order by insert_num;
+select insert_num,part,b,s3 from part_add_to_various_various_struct4;
 
 drop table part_add_to_various_various_struct4;


Mime
View raw message