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;