http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_primitive.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_primitive.q b/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_primitive.q index 30a1c08..bdc5805 100644 --- a/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_primitive.q +++ b/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_part_all_primitive.q @@ -32,7 +32,7 @@ insert into table part_change_various_various_boolean partition(part=1) (3, 200, 72909, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '6229-06-28 02:54:28.970117179', 'original'), (4, 1, 90000, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, 'time will come', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_boolean replace columns (insert_num int, c1 BOOLEAN, c2 BOOLEAN, c3 BOOLEAN, c4 BOOLEAN, c5 BOOLEAN, c6 BOOLEAN, c7 BOOLEAN, c8 BOOLEAN, c9 BOOLEAN, b STRING); @@ -44,9 +44,9 @@ insert into table part_change_various_various_boolean partition(part=1) values (6, 0, 1, 1, false, 0, true, false, true, 0, 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,b from part_change_various_various_boolean; drop table part_change_various_various_boolean; @@ -65,7 +65,7 @@ insert into table part_change_various_various_tinyint partition(part=1) (4, false, -72, -127, 127, 30.774, 127.561431, -106.561431, '90.284799488', '90.284799488', '1', '6229-06-28 02:54:28.970117179', 'original'), (5, 1, -90, 75, -38, 109.284799488 ,-128.75, 98.75, '120.4', '33.333', '0.45', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_tinyint replace columns (insert_num int, c1 TINYINT, c2 TINYINT, c3 TINYINT, c4 TINYINT, c5 TINYINT, c6 TINYINT, c7 TINYINT, c8 TINYINT, c9 TINYINT, c10 TINYINT, c11 TINYINT, b STRING); @@ -77,9 +77,9 @@ insert into table part_change_various_various_tinyint partition(part=1) values (7, -120, 85, -126, -167, 91, 113, -28, -63, 0, 8, 237, 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint; drop table part_change_various_various_tinyint; @@ -98,7 +98,7 @@ insert into table part_change_various_various_smallint partition(part=1) (4, false, 72, 32422, -9322, 30.774, -6675.561431, -6675.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'), (5, 1, -90, 7151, 3094, 30000.284799488 ,-9000.75, 0.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_smallint replace columns (insert_num int, c1 SMALLINT, c2 SMALLINT, c3 SMALLINT, c4 SMALLINT, c5 SMALLINT, c6 SMALLINT, c7 SMALLINT, c8 SMALLINT, c9 SMALLINT, c10 SMALLINT, c11 SMALLINT, b STRING); @@ -110,9 +110,9 @@ insert into table part_change_various_various_smallint partition(part=1) values (7, -10542, -1805, -4844, 15507, 91, 22385, -28, -12268, 0, 66475, 774, 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint; drop table part_change_various_various_smallint; @@ -130,7 +130,7 @@ insert into table part_change_various_various_int partition(part=1) (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_int replace columns (insert_num int, c1 INT, c2 INT, c3 INT, c4 INT, c5 INT, c6 INT, c7 INT, c8 INT, c9 INT, c10 INT, c11 INT, b STRING); @@ -142,9 +142,9 @@ insert into table part_change_various_various_int partition(part=1) values (6, -1928921, 695025, -151775655, -167, 91, 113, -164341325, -134237413, 0, 6229, 4422, 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int; drop table part_change_various_various_int; @@ -163,7 +163,7 @@ insert into table part_change_various_various_bigint partition(part=1) (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '1998287.3541', '1998287.3541', '1998287.3541', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_bigint replace columns (insert_num int, c1 BIGINT, c2 BIGINT, c3 BIGINT, c4 BIGINT, c5 BIGINT, c6 BIGINT, c7 BIGINT, c8 BIGINT, c9 BIGINT, c10 BIGINT, c11 BIGINT, b STRING); @@ -175,9 +175,9 @@ insert into table part_change_various_various_bigint partition(part=1) values (7, -164341325, 9043162437544575070, -126, -6566204574741299000, 91, 113, -28, -63, 0, 3244222, -90, 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint; drop table part_change_various_various_bigint; @@ -195,7 +195,7 @@ insert into table part_change_various_various_float partition(part=1) (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '2402.3', '2402.3', '2402.3', '6229-06-28 02:54:28.970117179', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_float replace columns (insert_num int, c1 FLOAT, c2 FLOAT, c3 FLOAT, c4 FLOAT, c5 FLOAT, c6 FLOAT, c7 FLOAT, c8 FLOAT, c9 FLOAT, c10 FLOAT, c11 FLOAT, b STRING); @@ -207,9 +207,9 @@ insert into table part_change_various_various_float partition(part=1) values (7, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -93222.200, 29.076, 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float; drop table part_change_various_various_float; @@ -227,7 +227,7 @@ insert into table part_change_various_various_double partition(part=1) (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_double replace columns (insert_num int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE, c10 DOUBLE, c11 DOUBLE, b STRING); @@ -239,9 +239,9 @@ insert into table part_change_various_various_double partition(part=1) values (7, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double; drop table part_change_various_various_double; @@ -259,7 +259,7 @@ insert into table part_change_various_various_decimal partition(part=1) (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '2402.3', '2402.3', '2402.3', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_decimal replace columns (insert_num int, c1 DECIMAL(38,18), c2 DECIMAL(38,18), c3 DECIMAL(38,18), c4 DECIMAL(38,18), c5 DECIMAL(38,18), c6 DECIMAL(38,18), c7 DECIMAL(38,18), c8 DECIMAL(38,18), c9 DECIMAL(38,18), c10 DECIMAL(38,18), c11 DECIMAL(38,18), b STRING); @@ -271,9 +271,9 @@ insert into table part_change_various_various_decimal partition(part=1) values (7,-1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal; drop table part_change_various_various_decimal; @@ -291,7 +291,7 @@ insert into table part_change_various_various_string partition(part=1) (4, false, 72, 3244222, -93222, 30.774, - 66475.561431, -66475.561431, 0.561431, '1', '1', '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488, 9250340.75, 9250340.75, 9250340.75, 'junkyard', 'junkyard', '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_string replace columns (insert_num int, 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); @@ -303,9 +303,9 @@ insert into table part_change_various_various_string partition(part=1) values (7,-'false', '-67', '833', '63993', ' 1255178165.77663', '905070.974', '-4314.7918', -'1240033819', 'trial', 'trial', '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string; drop table part_change_various_various_string; @@ -323,7 +323,7 @@ insert into table part_change_various_various_char partition(part=1) (4, false, 72, 3244222, -93222, 30.774, - 66475.561431, -66475.561431, 0.561431, '1', '1', '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488, 9250340.75, 9250340.75, 9250340.75, 'junkyard', 'junkyard', '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_char replace columns (insert_num int, c1 CHAR(25), c2 CHAR(25), c3 CHAR(25), c4 CHAR(25), c5 CHAR(25), c6 CHAR(25), c7 CHAR(25), c8 CHAR(25), c9 CHAR(25), c10 CHAR(25), c11 CHAR(25), c12 CHAR(25), c13 CHAR(25), b STRING); @@ -335,9 +335,9 @@ insert into table part_change_various_various_char partition(part=1) values (7,-'false', '-67', '833', '63993', ' 1255178165.77663', '905070.974', '-4314.7918', -'1240033819', 'trial', 'trial', '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char; drop table part_change_various_various_char; @@ -355,7 +355,7 @@ insert into table part_change_various_various_char_trunc partition(part=1) (4, false, 72, 3244222, -93222, 30.774, - 66475.561431, -66475.561431, 0.561431, '1', '1', '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488, 9250340.75, 9250340.75, 9250340.75, 'junkyard', 'junkyard', '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_char_trunc replace columns (insert_num int, c1 CHAR(8), c2 CHAR(8), c3 CHAR(8), c4 CHAR(8), c5 CHAR(8), c6 CHAR(8), c7 CHAR(8), c8 CHAR(8), c9 CHAR(8), c10 CHAR(8), c11 CHAR(8), c12 CHAR(8), c13 CHAR(8), b STRING); @@ -367,9 +367,9 @@ insert into table part_change_various_various_char_trunc partition(part=1) values (7,-'false', '-67', '833', '63993', ' 1255178165.77663', '905070.974', '-4314.7918', -'1240033819', 'trial', 'trial', '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_char_trunc; drop table part_change_various_various_char_trunc; @@ -387,7 +387,7 @@ insert into table part_change_various_various_varchar partition(part=1) (4, false, 72, 3244222, -93222, 30.774, - 66475.561431, -66475.561431, 0.561431, '1', '1', '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488, 9250340.75, 9250340.75, 9250340.75, 'junkyard', 'junkyard', '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_varchar replace columns (insert_num int, c1 VARCHAR(25), c2 VARCHAR(25), c3 VARCHAR(25), c4 VARCHAR(25), c5 VARCHAR(25), c6 VARCHAR(25), c7 VARCHAR(25), c8 VARCHAR(25), c9 VARCHAR(25), c10 VARCHAR(25), c11 VARCHAR(25), c12 VARCHAR(25), c13 VARCHAR(25), b STRING); @@ -399,9 +399,9 @@ insert into table part_change_various_various_varchar partition(part=1) values (7,-'false', '-67', '833', '63993', ' 1255178165.77663', '905070.974', '-4314.7918', -'1240033819', 'trial', 'trial', '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar; drop table part_change_various_various_varchar; @@ -419,7 +419,7 @@ insert into table part_change_various_various_varchar_trunc partition(part=1) (3, false, 72, 3244222, -93222, 30.774, - 66475.561431, -66475.561431, 0.561431, '1', '1', '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'), (4, 1, -90, 754072151, 3289094, 46114.284799488, 9250340.75, 9250340.75, 9250340.75, 'junkyard', 'junkyard', '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_varchar_trunc replace columns (insert_num int, c1 VARCHAR(8), c2 VARCHAR(8), c3 VARCHAR(8), c4 VARCHAR(8), c5 VARCHAR(8), c6 VARCHAR(8), c7 VARCHAR(8), c8 VARCHAR(8), c9 VARCHAR(8), c10 VARCHAR(8), c11 VARCHAR(8), c12 VARCHAR(8), c13 VARCHAR(8), b STRING); @@ -431,9 +431,9 @@ insert into table part_change_various_various_varchar_trunc partition(part=1) values (6,-'false', '-67', '833', '63993', ' 1255178165.77663', '905070.974', '-4314.7918', -'1240033819', 'trial', 'trial', '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_varchar_trunc; drop table part_change_various_various_varchar_trunc; @@ -451,7 +451,7 @@ insert into table part_change_various_various_timestamp partition(part=1) (4, false, 72, 3244222, -93222, 30.774, - 66475.561431, -66475.561431, 0.561431, '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '5966-07-09', 'original'), (5, 1, -90, 754072151, 3289094, 46114.284799488, 9250340.75, 9250340.75, 9250340.75, '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '1815-05-06', 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_timestamp replace columns (insert_num int, c1 TIMESTAMP, c2 TIMESTAMP, c3 TIMESTAMP, c4 TIMESTAMP, c5 TIMESTAMP, c6 TIMESTAMP, c7 TIMESTAMP, c8 TIMESTAMP, c9 TIMESTAMP, c10 TIMESTAMP, c11 TIMESTAMP, c12 TIMESTAMP, b STRING); @@ -463,9 +463,9 @@ insert into table part_change_various_various_timestamp partition(part=1) values (7,-'false', '-67', '833', '63993', ' 1255178165.77663', '905070.974', '-4314.7918', -'1240033819', '2016-03-07 03:02:22.0', '2016-03-07 03:02:22.0', '2016-03-07 03:02:22.0', '2016-03-07', 'new'); explain -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp; -select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from part_change_various_various_timestamp; drop table part_change_various_various_timestamp; @@ -481,7 +481,7 @@ insert into table part_change_various_various_date partition(part=1) (3, '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', '6229-06-28 02:54:28.970117179', 'original'), (4, '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', '2002-05-10 05:29:48.990818073', 'original'); -select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_various_various_date replace columns (insert_num int, c1 DATE, c2 DATE, c3 DATE, c4 DATE, b STRING); @@ -493,9 +493,9 @@ insert into table part_change_various_various_date partition(part=1) values (6,-'2002-05-10', '2002-05-10', '2002-05-10', '2002-05-10','new'); explain -select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date; -select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date; drop table part_change_various_various_date; @@ -514,7 +514,7 @@ select * from same_type1_a_txt; insert into table part_change_same_type_different_params partition(part=1) select * from same_type1_a_txt; -select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_same_type_different_params replace columns (insert_num int, c1 CHAR(8), c2 CHAR(32), c3 VARCHAR(15), c4 VARCHAR(18), c5 DECIMAL(10,2), c6 DECIMAL(25,15), b STRING); @@ -538,8 +538,8 @@ select * from same_type1_c_txt; insert into table part_change_same_type_different_params partition(part=2) select * from same_type1_c_txt; explain -select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params; -select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_same_type_different_params; drop table part_change_same_type_different_params;
http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_table.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_table.q b/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_table.q index b20f7e8..112052f 100644 --- a/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_table.q +++ b/ql/src/test/queries/clientpositive/schema_evol_text_vec_mapwork_table.q @@ -47,12 +47,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; @@ -84,16 +84,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; @@ -128,9 +128,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; @@ -161,9 +161,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; @@ -191,9 +191,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; @@ -214,7 +214,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) ; @@ -228,9 +228,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; @@ -247,7 +247,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) ; @@ -261,9 +261,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; @@ -279,7 +279,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) ; @@ -293,9 +293,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; @@ -312,7 +312,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) ; @@ -326,9 +326,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; @@ -344,7 +344,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) ; @@ -358,9 +358,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; @@ -376,7 +376,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) ; @@ -390,9 +390,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; @@ -408,7 +408,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) ; @@ -422,9 +422,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; @@ -440,7 +440,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) ; @@ -454,9 +454,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; @@ -472,7 +472,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) ; @@ -486,9 +486,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; @@ -504,7 +504,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) ; @@ -518,9 +518,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; @@ -540,7 +540,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) ; @@ -554,9 +554,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; @@ -573,7 +573,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) ; @@ -587,9 +587,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; @@ -606,7 +606,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) ; @@ -620,9 +620,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; @@ -643,7 +643,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) ; @@ -657,9 +657,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; @@ -675,7 +675,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) ; @@ -689,9 +689,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; @@ -708,7 +708,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) ; @@ -722,9 +722,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; @@ -740,7 +740,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) ; @@ -754,9 +754,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; @@ -772,7 +772,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) ; @@ -786,9 +786,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; @@ -805,7 +805,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) ; @@ -819,8 +819,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_vecrow_mapwork_part.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_mapwork_part.q b/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_mapwork_part.q index c54ed91..32edd50 100644 --- a/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_mapwork_part.q +++ b/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_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;
