http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_complex.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_complex.q b/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_complex.q index f8a8fa6..2a0fb5f 100644 --- a/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_complex.q +++ b/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_complex.q @@ -29,7 +29,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); @@ -51,9 +51,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; @@ -68,7 +68,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>); @@ -89,7 +89,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>); @@ -111,9 +111,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; @@ -133,7 +133,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>); @@ -155,8 +155,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;
http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_primitive.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_primitive.q b/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_primitive.q index 3769485..061c4d0 100644 --- a/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_primitive.q +++ b/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_part_all_primitive.q @@ -30,7 +30,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); @@ -42,9 +42,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; @@ -63,7 +63,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); @@ -75,9 +75,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; @@ -96,7 +96,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); @@ -108,9 +108,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; @@ -128,7 +128,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); @@ -140,9 +140,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; @@ -161,7 +161,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); @@ -173,9 +173,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; @@ -193,7 +193,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); @@ -205,9 +205,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; @@ -225,7 +225,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); @@ -237,9 +237,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; @@ -257,7 +257,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); @@ -269,9 +269,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; @@ -289,7 +289,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); @@ -301,9 +301,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; @@ -321,7 +321,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); @@ -333,9 +333,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; @@ -353,7 +353,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); @@ -365,9 +365,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; @@ -385,7 +385,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); @@ -397,9 +397,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; @@ -417,7 +417,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); @@ -429,9 +429,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; @@ -449,7 +449,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); @@ -461,9 +461,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; @@ -479,7 +479,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); @@ -491,9 +491,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; @@ -512,7 +512,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); @@ -536,8 +536,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_orc_vec_mapwork_table.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_table.q b/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_table.q index 98b70f9..df67505 100644 --- a/ql/src/test/queries/clientpositive/schema_evol_orc_vec_mapwork_table.q +++ b/ql/src/test/queries/clientpositive/schema_evol_orc_vec_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;
