http://git-wip-us.apache.org/repos/asf/hive/blob/f5383329/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_all_primitive_llap_io.q
----------------------------------------------------------------------
diff --git 
a/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_all_primitive_llap_io.q
 
b/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_all_primitive_llap_io.q
index a191d79..6dd6935 100644
--- 
a/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_all_primitive_llap_io.q
+++ 
b/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_all_primitive_llap_io.q
@@ -61,24 +61,24 @@ select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c1
 select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b
 from part_change_various_various_boolean_to_bigint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table part_change_various_various_boolean_to_bigint replace columns 
(insert_num int,
---**              c1 BOOLEAN, c2 BOOLEAN, c3 BOOLEAN, c4 BOOLEAN, c5 BOOLEAN, 
c6 BOOLEAN, c7 BOOLEAN, c8 BOOLEAN, c9 BOOLEAN,
---**              c10 TINYINT, c11 TINYINT, c12 TINYINT, c13 TINYINT, c14 
TINYINT, c15 TINYINT, c16 TINYINT, c17 TINYINT, c18 TINYINT, c19 TINYINT, c20 
TINYINT,
---**              c21 SMALLINT, c22 SMALLINT, c23 SMALLINT, c24 SMALLINT, c25 
SMALLINT, c26 SMALLINT, c27 SMALLINT, c28 SMALLINT, c29 SMALLINT, c30 SMALLINT, 
c31 SMALLINT,
---**              c32 INT, c33 INT, c34 INT, c35 INT, c36 INT, c37 INT, c38 
INT, c39 INT, c40 INT, c41 INT, c42 INT,
---**              c43 BIGINT, c44 BIGINT, c45 BIGINT, c46 BIGINT, c47 BIGINT, 
c48 BIGINT, c49 BIGINT, c50 BIGINT, c51 BIGINT, c52 BIGINT, c53 BIGINT,
---**              b STRING);
-
---** insert into table part_change_various_various_boolean_to_bigint 
partition(part=1) SELECT insert_num,
---**              boolean1, boolean1, boolean1, boolean1, boolean1, boolean1, 
boolean1, boolean1, boolean1,
---**              tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, 
tinyint1, tinyint1, tinyint1, tinyint1, tinyint1,
---**              smallint1, smallint1, smallint1, smallint1, smallint1, 
smallint1, smallint1, smallint1, smallint1, smallint1, smallint1,
---**              int1, int1, int1, int1, int1, int1, int1, int1, int1, int1, 
int1,
---**              bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, 
bigint1, bigint1, bigint1, bigint1, bigint1, 
---**               'new' FROM schema_evolution_data;
-
---** explain vectorization detail
---** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b
 from part_change_various_various_boolean_to_bigint;
+alter table part_change_various_various_boolean_to_bigint replace columns 
(insert_num int,
+             c1 BOOLEAN, c2 BOOLEAN, c3 BOOLEAN, c4 BOOLEAN, c5 BOOLEAN, c6 
BOOLEAN, c7 BOOLEAN, c8 BOOLEAN, c9 BOOLEAN,
+             c10 TINYINT, c11 TINYINT, c12 TINYINT, c13 TINYINT, c14 TINYINT, 
c15 TINYINT, c16 TINYINT, c17 TINYINT, c18 TINYINT, c19 TINYINT, c20 TINYINT,
+             c21 SMALLINT, c22 SMALLINT, c23 SMALLINT, c24 SMALLINT, c25 
SMALLINT, c26 SMALLINT, c27 SMALLINT, c28 SMALLINT, c29 SMALLINT, c30 SMALLINT, 
c31 SMALLINT,
+             c32 INT, c33 INT, c34 INT, c35 INT, c36 INT, c37 INT, c38 INT, 
c39 INT, c40 INT, c41 INT, c42 INT,
+             c43 BIGINT, c44 BIGINT, c45 BIGINT, c46 BIGINT, c47 BIGINT, c48 
BIGINT, c49 BIGINT, c50 BIGINT, c51 BIGINT, c52 BIGINT, c53 BIGINT,
+             b STRING);
+
+insert into table part_change_various_various_boolean_to_bigint 
partition(part=1) SELECT insert_num,
+             boolean1, boolean1, boolean1, boolean1, boolean1, boolean1, 
boolean1, boolean1, boolean1,
+             tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, tinyint1, 
tinyint1, tinyint1, tinyint1, tinyint1, tinyint1,
+             smallint1, smallint1, smallint1, smallint1, smallint1, smallint1, 
smallint1, smallint1, smallint1, smallint1, smallint1,
+             int1, int1, int1, int1, int1, int1, int1, int1, int1, int1, int1,
+             bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, bigint1, 
bigint1, bigint1, bigint1, bigint1, 
+              'new' FROM schema_evolution_data;
+
+explain vectorization detail
+select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b
 from part_change_various_various_boolean_to_bigint;
 
 --** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50,c51,c52,c53,b
 from part_change_various_various_boolean_to_bigint;
 
@@ -110,20 +110,20 @@ select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c1
 select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b
 from part_change_various_various_decimal_to_double;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table part_change_various_various_decimal_to_double 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), 
---**              c12 FLOAT, c13 FLOAT, c14 FLOAT, c15 FLOAT, c16 FLOAT, c17 
FLOAT, c18 FLOAT, c19 FLOAT, c20 FLOAT, c21 FLOAT, c22 FLOAT,
---**              c23 DOUBLE, c24 DOUBLE, c25 DOUBLE, c26 DOUBLE, c27 DOUBLE, 
c28 DOUBLE, c29 DOUBLE, c30 DOUBLE, c31 DOUBLE, c32 DOUBLE, c33 DOUBLE,
---**              b STRING);
-
---** insert into table part_change_various_various_decimal_to_double 
partition(part=1) SELECT insert_num,
---**              decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, 
decimal1, decimal1, decimal1, decimal1, decimal1,
---**              float1, float1, float1, float1, float1, float1, float1, 
float1, float1, float1, float1,
---**              double1, double1, double1, double1, double1, double1, 
double1, double1, double1, double1, double1,
---**              'new' FROM schema_evolution_data_2 WHERE insert_num=111;
-
---** explain vectorization detail
---** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b
 from part_change_various_various_decimal_to_double;
+alter table part_change_various_various_decimal_to_double 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), 
+             c12 FLOAT, c13 FLOAT, c14 FLOAT, c15 FLOAT, c16 FLOAT, c17 FLOAT, 
c18 FLOAT, c19 FLOAT, c20 FLOAT, c21 FLOAT, c22 FLOAT,
+             c23 DOUBLE, c24 DOUBLE, c25 DOUBLE, c26 DOUBLE, c27 DOUBLE, c28 
DOUBLE, c29 DOUBLE, c30 DOUBLE, c31 DOUBLE, c32 DOUBLE, c33 DOUBLE,
+             b STRING);
+
+insert into table part_change_various_various_decimal_to_double 
partition(part=1) SELECT insert_num,
+             decimal1, decimal1, decimal1, decimal1, decimal1, decimal1, 
decimal1, decimal1, decimal1, decimal1, decimal1,
+             float1, float1, float1, float1, float1, float1, float1, float1, 
float1, float1, float1,
+             double1, double1, double1, double1, double1, double1, double1, 
double1, double1, double1, double1,
+             'new' FROM schema_evolution_data_2 WHERE insert_num=111;
+
+explain vectorization detail
+select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b
 from part_change_various_various_decimal_to_double;
 
 --** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,b
 from part_change_various_various_decimal_to_double;
 
@@ -142,17 +142,17 @@ insert into table part_change_various_various_timestamp 
partition(part=1) SELECT
 explain vectorization detail
 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;
+--** 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 ...
---** salter 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);
+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);
 
---** sinsert into table part_change_various_various_timestamp 
partition(part=1) SELECT insert_num, timestamp1, timestamp1, timestamp1, 
timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, 
timestamp1, timestamp1, timestamp1, 'new' FROM schema_evolution_data_2 WHERE 
insert_num=111;
+insert into table part_change_various_various_timestamp partition(part=1) 
SELECT insert_num, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, 
timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, timestamp1, 
timestamp1, 'new' FROM schema_evolution_data_2 WHERE insert_num=111;
 
---** sexplain vectorization detail
---** sselect insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from 
part_change_various_various_timestamp;
+explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,b from 
part_change_various_various_timestamp;
 
---** sselect 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;
 
 drop table part_change_various_various_timestamp;
 
@@ -166,15 +166,15 @@ insert into table part_change_various_various_date 
partition(part=1) SELECT inse
 explain vectorization detail
 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;
+--** 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);
+alter table part_change_various_various_date replace columns (insert_num int, 
c1 DATE, c2 DATE, c3 DATE, c4 DATE, b STRING);
 
---** insert into table part_change_various_various_date partition(part=1) 
SELECT insert_num, date1, date1, date1, date1, 'new' FROM 
schema_evolution_data_2 WHERE insert_num=111;
+insert into table part_change_various_various_date partition(part=1) SELECT 
insert_num, date1, date1, date1, date1, 'new' FROM schema_evolution_data_2 
WHERE insert_num=111;
 
---** explain vectorization detail
---** select insert_num,part,c1,c2,c3,c4,b from 
part_change_various_various_date;
+explain vectorization detail
+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;
 
@@ -196,27 +196,27 @@ insert into table part_change_same_type_different_params 
partition(part=1) selec
 explain vectorization detail
 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;
+--** 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);
+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);
 
---** CREATE TABLE same_type1_b_txt(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)
---** row format delimited fields terminated by '|'
---** stored as textfile;
---** load data local inpath 
'../../data/files/schema_evolution/same_type1_b.txt' overwrite into table 
same_type1_b_txt;
+CREATE TABLE same_type1_b_txt(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)
+row format delimited fields terminated by '|'
+stored as textfile;
+load data local inpath '../../data/files/schema_evolution/same_type1_b.txt' 
overwrite into table same_type1_b_txt;
 
---** insert into table part_change_same_type_different_params 
partition(part=1) select * from same_type1_b_txt;
+insert into table part_change_same_type_different_params partition(part=1) 
select * from same_type1_b_txt;
 
---** CREATE TABLE same_type1_c_txt(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)
---** row format delimited fields terminated by '|'
---** stored as textfile;
---** load data local inpath 
'../../data/files/schema_evolution/same_type1_c.txt' overwrite into table 
same_type1_c_txt;
+CREATE TABLE same_type1_c_txt(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)
+row format delimited fields terminated by '|'
+stored as textfile;
+load data local inpath '../../data/files/schema_evolution/same_type1_c.txt' 
overwrite into table same_type1_c_txt;
 
---** insert into table part_change_same_type_different_params 
partition(part=2) 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 vectorization detail
---** select insert_num,part,c1,c2,c3,c4,c5,c6,b from 
part_change_same_type_different_params;
+explain vectorization detail
+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;
 

http://git-wip-us.apache.org/repos/asf/hive/blob/f5383329/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_llap_io.q
----------------------------------------------------------------------
diff --git 
a/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_llap_io.q 
b/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_llap_io.q
index 4a91a95..a4c1e18 100644
--- a/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_llap_io.q
+++ b/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_part_llap_io.q
@@ -40,12 +40,12 @@ select insert_num,part,a,b from part_add_int_permute_select;
 select insert_num,part,a,b from part_add_int_permute_select;
 
 -- Table-Non-Cascade ADD COLUMNS ...
---** alter table part_add_int_permute_select add columns(c int);
+alter table part_add_int_permute_select add columns(c int);
 
---** insert into table part_add_int_permute_select partition(part=1) VALUES 
(2, 2222, 'new', 3333);
+insert into table part_add_int_permute_select partition(part=1) VALUES (2, 
2222, 'new', 3333);
 
---** explain vectorization detail
---** select insert_num,part,a,b from part_add_int_permute_select;
+explain vectorization detail
+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;
@@ -68,12 +68,12 @@ select insert_num,part,a,b from 
part_add_int_string_permute_select;
 select insert_num,part,a,b from part_add_int_string_permute_select;
 
 -- Table-Non-Cascade ADD COLUMNS ...
---** alter table part_add_int_string_permute_select add columns(c int, d 
string);
+alter table part_add_int_string_permute_select add columns(c int, d string);
 
---** insert into table part_add_int_string_permute_select partition(part=1) 
VALUES (2, 2222, 'new', 3333, '4444');
+insert into table part_add_int_string_permute_select partition(part=1) VALUES 
(2, 2222, 'new', 3333, '4444');
 
---** explain vectorization detail
---** select insert_num,part,a,b from part_add_int_string_permute_select;
+explain vectorization detail
+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;
@@ -105,12 +105,12 @@ 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;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table part_change_string_group_double replace columns (insert_num 
int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING);
+alter table part_change_string_group_double replace columns (insert_num int, 
c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING);
 
---** insert into table part_change_string_group_double partition(part=1) 
SELECT insert_num, double1, double1, double1, 'new' FROM schema_evolution_data 
WHERE insert_num = 111;
+insert into table part_change_string_group_double partition(part=1) SELECT 
insert_num, double1, double1, double1, 'new' FROM schema_evolution_data WHERE 
insert_num = 111;
 
---** explain vectorization detail
---** select insert_num,part,c1,c2,c3,b from part_change_string_group_double;
+explain vectorization detail
+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;
 
@@ -133,12 +133,12 @@ select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b 
from part_change_date_gr
 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
part_change_date_group_string_group_date_timestamp;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table part_change_date_group_string_group_date_timestamp replace 
columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 
VARCHAR(15), c6 STRING, c7 CHAR(50), c8 CHAR(15), c9 VARCHAR(50), c10 
VARCHAR(15), b STRING);
+alter table part_change_date_group_string_group_date_timestamp replace 
columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 
VARCHAR(15), c6 STRING, c7 CHAR(50), c8 CHAR(15), c9 VARCHAR(50), c10 
VARCHAR(15), b STRING);
 
---** insert into table part_change_date_group_string_group_date_timestamp 
partition(part=1) VALUES (111, 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'new');
+insert into table part_change_date_group_string_group_date_timestamp 
partition(part=1) VALUES (111, 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'new');
 
---** explain vectorization detail
---** select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
part_change_date_group_string_group_date_timestamp;
+explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
part_change_date_group_string_group_date_timestamp;
 
 --** select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
part_change_date_group_string_group_date_timestamp;
 
@@ -176,20 +176,20 @@ select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c1
 select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
 from part_change_numeric_group_string_group_multi_ints_string_group;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table 
part_change_numeric_group_string_group_multi_ints_string_group replace columns 
(insert_num int,
---**              c1 STRING, c2 STRING, c3 STRING, c4 STRING,
---**              c5 CHAR(50), c6 CHAR(50), c7 CHAR(50), c8 CHAR(50), c9 
CHAR(5), c10 CHAR(5), c11 CHAR(5), c12 CHAR(5),
---**              c13 VARCHAR(50), c14 VARCHAR(50), c15 VARCHAR(50), c16 
VARCHAR(50), c17 VARCHAR(5), c18 VARCHAR(5), c19 VARCHAR(5), c20 VARCHAR(5),
---**              b STRING) ;
-
---** insert into table 
part_change_numeric_group_string_group_multi_ints_string_group 
partition(part=1) VALUES (111,
---**             'filler', 'filler', 'filler', 'filler',
---**             'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler',
---**             'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler',
---**             'new');
-
---** explain vectorization detail
---** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
 from part_change_numeric_group_string_group_multi_ints_string_group;
+alter table part_change_numeric_group_string_group_multi_ints_string_group 
replace columns (insert_num int,
+             c1 STRING, c2 STRING, c3 STRING, c4 STRING,
+             c5 CHAR(50), c6 CHAR(50), c7 CHAR(50), c8 CHAR(50), c9 CHAR(5), 
c10 CHAR(5), c11 CHAR(5), c12 CHAR(5),
+             c13 VARCHAR(50), c14 VARCHAR(50), c15 VARCHAR(50), c16 
VARCHAR(50), c17 VARCHAR(5), c18 VARCHAR(5), c19 VARCHAR(5), c20 VARCHAR(5),
+             b STRING) ;
+
+insert into table 
part_change_numeric_group_string_group_multi_ints_string_group 
partition(part=1) VALUES (111,
+            'filler', 'filler', 'filler', 'filler',
+            'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler',
+            'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler',
+            'new');
+
+explain vectorization detail
+select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
 from part_change_numeric_group_string_group_multi_ints_string_group;
 
 --** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
 from part_change_numeric_group_string_group_multi_ints_string_group;
 
@@ -222,20 +222,20 @@ select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b from
 select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b 
from part_change_numeric_group_string_group_floating_string_group;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table part_change_numeric_group_string_group_floating_string_group 
replace columns (insert_num int,
---**               c1 STRING, c2 STRING, c3 STRING,
---**               c4 CHAR(50), c5 CHAR(50), c6 CHAR(50), c7 CHAR(7), c8 
CHAR(7), c9 CHAR(7),
---**               c10 VARCHAR(50), c11 VARCHAR(50), c12 VARCHAR(50), c13 
VARCHAR(7), c14 VARCHAR(7), c15 VARCHAR(7),
---**               b STRING);
-
---** insert into table 
part_change_numeric_group_string_group_floating_string_group partition(part=1) 
VALUES (111,
---**              'filler', 'filler', 'filler',
---**              'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
---**              'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
---**              'new');
-
---** explain vectorization detail
---** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b from 
part_change_numeric_group_string_group_floating_string_group;
+alter table part_change_numeric_group_string_group_floating_string_group 
replace columns (insert_num int,
+              c1 STRING, c2 STRING, c3 STRING,
+              c4 CHAR(50), c5 CHAR(50), c6 CHAR(50), c7 CHAR(7), c8 CHAR(7), 
c9 CHAR(7),
+              c10 VARCHAR(50), c11 VARCHAR(50), c12 VARCHAR(50), c13 
VARCHAR(7), c14 VARCHAR(7), c15 VARCHAR(7),
+              b STRING);
+
+insert into table part_change_numeric_group_string_group_floating_string_group 
partition(part=1) VALUES (111,
+             'filler', 'filler', 'filler',
+             'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
+             'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
+             'new');
+
+explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b 
from part_change_numeric_group_string_group_floating_string_group;
 
 --** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b from 
part_change_numeric_group_string_group_floating_string_group;
 
@@ -268,19 +268,19 @@ select insert_num,part,c1,c2,c3,c4,b from 
part_change_string_group_string_group_
 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),
---**            c5 VARCHAR(50), c6 VARCHAR(9), c7 STRING,
---**            c8 CHAR(50), c9 CHAR(9), c10 STRING, b STRING) ;
-
---** insert into table part_change_string_group_string_group_string 
partition(part=1) VALUES (111,
---**           'filler', 'filler', 'filler', 'filler',
---**           'filler', 'filler', 'filler',
---**           'filler', 'filler', 'filler',
---**           'new');
-
---** explain vectorization detail
---** select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
part_change_string_group_string_group_string;
+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),
+           c5 VARCHAR(50), c6 VARCHAR(9), c7 STRING,
+           c8 CHAR(50), c9 CHAR(9), c10 STRING, b STRING) ;
+
+insert into table part_change_string_group_string_group_string 
partition(part=1) VALUES (111,
+          'filler', 'filler', 'filler', 'filler',
+          'filler', 'filler', 'filler',
+          'filler', 'filler', 'filler',
+          'new');
+
+explain vectorization detail
+select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
part_change_string_group_string_group_string;
 
 --** select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
part_change_string_group_string_group_string;
 
@@ -318,22 +318,22 @@ select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c1
 select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,b
 from part_change_lower_to_higher_numeric_group_tinyint_to_bigint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table part_change_lower_to_higher_numeric_group_tinyint_to_bigint 
replace columns (insert_num int,
---**              c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, 
c6 DOUBLE,
---**              c7 INT, c8 BIGINT, c9 decimal(38,18), c10 FLOAT, c11 DOUBLE,
---**              c12 BIGINT, c13 decimal(38,18), c14 FLOAT, c15 DOUBLE,
---**              c16 decimal(38,18), c17 FLOAT, c18 DOUBLE,
---**              b STRING) ;
-
---** insert into table 
part_change_lower_to_higher_numeric_group_tinyint_to_bigint partition(part=1) 
VALUES (111,
---**             7000, 80000, 90000000, 1234.5678, 9876.543, 789.321,
---**             80000, 90000000, 1234.5678, 9876.543, 789.321,
---**             90000000, 1234.5678, 9876.543, 789.321,
---**             1234.5678, 9876.543, 789.321,
---**            'new');
-
---** explain vectorization detail
---** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,b
 from part_change_lower_to_higher_numeric_group_tinyint_to_bigint;
+alter table part_change_lower_to_higher_numeric_group_tinyint_to_bigint 
replace columns (insert_num int,
+             c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 
DOUBLE,
+             c7 INT, c8 BIGINT, c9 decimal(38,18), c10 FLOAT, c11 DOUBLE,
+             c12 BIGINT, c13 decimal(38,18), c14 FLOAT, c15 DOUBLE,
+             c16 decimal(38,18), c17 FLOAT, c18 DOUBLE,
+             b STRING) ;
+
+insert into table part_change_lower_to_higher_numeric_group_tinyint_to_bigint 
partition(part=1) VALUES (111,
+            7000, 80000, 90000000, 1234.5678, 9876.543, 789.321,
+            80000, 90000000, 1234.5678, 9876.543, 789.321,
+            90000000, 1234.5678, 9876.543, 789.321,
+            1234.5678, 9876.543, 789.321,
+           'new');
+
+explain vectorization detail
+select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,b
 from part_change_lower_to_higher_numeric_group_tinyint_to_bigint;
 
 --** select 
insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,b
 from part_change_lower_to_higher_numeric_group_tinyint_to_bigint;
 
@@ -362,12 +362,12 @@ select insert_num,part,c1,c2,c3,b from 
part_change_lower_to_higher_numeric_group
 select insert_num,part,c1,c2,c3,b from 
part_change_lower_to_higher_numeric_group_decimal_to_float;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table part_change_lower_to_higher_numeric_group_decimal_to_float 
replace columns (insert_num int, c1 float, c2 double, c3 DOUBLE, b STRING) ;
+alter table part_change_lower_to_higher_numeric_group_decimal_to_float replace 
columns (insert_num int, c1 float, c2 double, c3 DOUBLE, b STRING) ;
 
---** insert into table 
part_change_lower_to_higher_numeric_group_decimal_to_float partition(part=1) 
VALUES (111, 1234.5678, 9876.543, 1234.5678, 'new');
+insert into table part_change_lower_to_higher_numeric_group_decimal_to_float 
partition(part=1) VALUES (111, 1234.5678, 9876.543, 1234.5678, 'new');
 
---** explain vectorization detail
---** select insert_num,part,c1,c2,c3,b from 
part_change_lower_to_higher_numeric_group_decimal_to_float;
+explain vectorization detail
+select insert_num,part,c1,c2,c3,b from 
part_change_lower_to_higher_numeric_group_decimal_to_float;
 
 --** select insert_num,part,c1,c2,c3,b from 
part_change_lower_to_higher_numeric_group_decimal_to_float;
 

http://git-wip-us.apache.org/repos/asf/hive/blob/f5383329/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_table_llap_io.q
----------------------------------------------------------------------
diff --git 
a/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_table_llap_io.q 
b/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_table_llap_io.q
index d728cc9..3fa9388 100644
--- a/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_table_llap_io.q
+++ b/ql/src/test/queries/clientpositive/schema_evol_text_vecrow_table_llap_io.q
@@ -39,12 +39,12 @@ select insert_num,a,b from table_add_int_permute_select;
 select insert_num,a,b from table_add_int_permute_select;
 
 -- Table-Non-Cascade ADD COLUMNS ...
---** alter table table_add_int_permute_select add columns(c int);
+alter table table_add_int_permute_select add columns(c int);
 
---** insert into table table_add_int_permute_select VALUES (111, 80000, 'new', 
80000);
+insert into table table_add_int_permute_select VALUES (111, 80000, 'new', 
80000);
 
---** explain vectorization detail
---** select insert_num,a,b from table_add_int_permute_select;
+explain vectorization detail
+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;
@@ -67,12 +67,12 @@ select insert_num,a,b from 
table_add_int_string_permute_select;
 select insert_num,a,b from table_add_int_string_permute_select;
 
 -- Table-Non-Cascade ADD COLUMNS ...
---** alter table table_add_int_string_permute_select add columns(c int, d 
string);
+alter table table_add_int_string_permute_select add columns(c int, d string);
 
---** insert into table table_add_int_string_permute_select VALUES (111, 80000, 
'new', 80000, 'filler');
+insert into table table_add_int_string_permute_select VALUES (111, 80000, 
'new', 80000, 'filler');
 
---** explain vectorization detail
---** select insert_num,a,b from table_add_int_string_permute_select;
+explain vectorization detail
+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;
@@ -104,12 +104,12 @@ 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;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table table_change_string_group_double replace columns (insert_num 
int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING);
+alter table table_change_string_group_double replace columns (insert_num int, 
c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, b STRING);
 
---** insert into table table_change_string_group_double VALUES (111, 789.321, 
789.321, 789.321, 'new');
+insert into table table_change_string_group_double VALUES (111, 789.321, 
789.321, 789.321, 'new');
 
---** explain vectorization detail
---** select insert_num,c1,c2,c3,b from table_change_string_group_double;
+explain vectorization detail
+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;
 
@@ -132,12 +132,12 @@ select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
table_change_date_group_
 select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
table_change_date_group_string_group_date_group;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table table_change_date_group_string_group_date_group replace 
columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 
VARCHAR(15), c6 STRING, c7 CHAR(50), c8 CHAR(15), c9 VARCHAR(50), c10 
VARCHAR(15), b STRING);
+alter table table_change_date_group_string_group_date_group replace 
columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 
VARCHAR(15), c6 STRING, c7 CHAR(50), c8 CHAR(15), c9 VARCHAR(50), c10 
VARCHAR(15), b STRING);
 
---** insert into table table_change_date_group_string_group_date_group VALUES 
(111, 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler', 'filler', 'new');
+insert into table table_change_date_group_string_group_date_group VALUES (111, 
'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler', 'new');
 
---** explain vectorization detail
---** select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
table_change_date_group_string_group_date_group;
+explain vectorization detail
+select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
table_change_date_group_string_group_date_group;
 
 --** select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
table_change_date_group_string_group_date_group;
 
@@ -174,20 +174,20 @@ select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18
 select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
 from table_change_numeric_group_string_group_multi_ints_string_group;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table 
table_change_numeric_group_string_group_multi_ints_string_group replace columns 
(insert_num int,
---**              c1 STRING, c2 STRING, c3 STRING, c4 STRING,
---**              c5 CHAR(50), c6 CHAR(50), c7 CHAR(50), c8 CHAR(50), c9 
CHAR(5), c10 CHAR(5), c11 CHAR(5), c12 CHAR(5),
---**              c13 VARCHAR(50), c14 VARCHAR(50), c15 VARCHAR(50), c16 
VARCHAR(50), c17 VARCHAR(5), c18 VARCHAR(5), c19 VARCHAR(5), c20 VARCHAR(5),
---**              b STRING) ;
-
---** insert into table 
table_change_numeric_group_string_group_multi_ints_string_group VALUES (111,
---**             'filler', 'filler', 'filler', 'filler',
---**             'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler',
---**             'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler',
---**             'new');
-
---** explain vectorization detail
---** select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
 from table_change_numeric_group_string_group_multi_ints_string_group;
+alter table table_change_numeric_group_string_group_multi_ints_string_group 
replace columns (insert_num int,
+             c1 STRING, c2 STRING, c3 STRING, c4 STRING,
+             c5 CHAR(50), c6 CHAR(50), c7 CHAR(50), c8 CHAR(50), c9 CHAR(5), 
c10 CHAR(5), c11 CHAR(5), c12 CHAR(5),
+             c13 VARCHAR(50), c14 VARCHAR(50), c15 VARCHAR(50), c16 
VARCHAR(50), c17 VARCHAR(5), c18 VARCHAR(5), c19 VARCHAR(5), c20 VARCHAR(5),
+             b STRING) ;
+
+insert into table 
table_change_numeric_group_string_group_multi_ints_string_group VALUES (111,
+            'filler', 'filler', 'filler', 'filler',
+            'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler',
+            'filler', 'filler', 'filler', 'filler', 'filler', 'filler', 
'filler', 'filler',
+            'new');
+
+explain vectorization detail
+select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
 from table_change_numeric_group_string_group_multi_ints_string_group;
 
 --** select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,b
 from table_change_numeric_group_string_group_multi_ints_string_group;
 
@@ -220,20 +220,20 @@ select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b from tabl
 select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b from 
table_change_numeric_group_string_group_floating_string_group;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table table_change_numeric_group_string_group_floating_string_group 
replace columns (insert_num int,
---**               c1 STRING, c2 STRING, c3 STRING,
---**               c4 CHAR(50), c5 CHAR(50), c6 CHAR(50), c7 CHAR(7), c8 
CHAR(7), c9 CHAR(7),
---**               c10 VARCHAR(50), c11 VARCHAR(50), c12 VARCHAR(50), c13 
VARCHAR(7), c14 VARCHAR(7), c15 VARCHAR(7),
---**               b STRING);
-
---** insert into table 
table_change_numeric_group_string_group_floating_string_group VALUES (111,
---**              'filler', 'filler', 'filler',
---**              'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
---**              'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
---**              'new');
-
---** explain vectorization detail
---** select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b 
from table_change_numeric_group_string_group_floating_string_group;
+alter table table_change_numeric_group_string_group_floating_string_group 
replace columns (insert_num int,
+              c1 STRING, c2 STRING, c3 STRING,
+              c4 CHAR(50), c5 CHAR(50), c6 CHAR(50), c7 CHAR(7), c8 CHAR(7), 
c9 CHAR(7),
+              c10 VARCHAR(50), c11 VARCHAR(50), c12 VARCHAR(50), c13 
VARCHAR(7), c14 VARCHAR(7), c15 VARCHAR(7),
+              b STRING);
+
+insert into table 
table_change_numeric_group_string_group_floating_string_group VALUES (111,
+             'filler', 'filler', 'filler',
+             'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
+             'filler', 'filler', 'filler', 'filler', 'filler', 'filler',
+             'new');
+
+explain vectorization detail
+select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b from 
table_change_numeric_group_string_group_floating_string_group;
 
 --** select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,b 
from table_change_numeric_group_string_group_floating_string_group;
 
@@ -265,16 +265,16 @@ select insert_num,c1,c2,c3,c4,b from 
table_change_string_group_string_group_stri
 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),
---**            c5 VARCHAR(50), c6 VARCHAR(9), c7 STRING,
---**            c8 CHAR(50), c9 CHAR(9), c10 STRING, b STRING) ;
+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),
+           c5 VARCHAR(50), c6 VARCHAR(9), c7 STRING,
+           c8 CHAR(50), c9 CHAR(9), c10 STRING, b STRING) ;
 
---** insert into table table_change_string_group_string_group_string VALUES 
(111,
---**           'filler', 'filler', 'filler', 'filler',
---**           'filler', 'filler', 'filler',
---**           'filler', 'filler', 'filler',
---**           'new');
+insert into table table_change_string_group_string_group_string VALUES (111,
+          'filler', 'filler', 'filler', 'filler',
+          'filler', 'filler', 'filler',
+          'filler', 'filler', 'filler',
+          'new');
 
 --** select insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,b from 
table_change_string_group_string_group_string;
 
@@ -313,19 +313,19 @@ select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18
 select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,b 
from table_change_lower_to_higher_numeric_group_tinyint_to_bigint;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table table_change_lower_to_higher_numeric_group_tinyint_to_bigint 
replace columns (insert_num int,
---**              c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, 
c6 DOUBLE,
---**              c7 INT, c8 BIGINT, c9 decimal(38,18), c10 FLOAT, c11 DOUBLE,
---**              c12 BIGINT, c13 decimal(38,18), c14 FLOAT, c15 DOUBLE,
---**              c16 decimal(38,18), c17 FLOAT, c18 DOUBLE,
---**              b STRING) ;
-
---** insert into table 
table_change_lower_to_higher_numeric_group_tinyint_to_bigint VALUES (111,
---**             7000, 80000, 90000000, 1234.5678, 9876.543, 789.321,
---**             80000, 90000000, 1234.5678, 9876.543, 789.321,
---**             90000000, 1234.5678, 9876.543, 789.321,
---**             1234.5678, 9876.543, 789.321,
---**            'new');
+alter table table_change_lower_to_higher_numeric_group_tinyint_to_bigint 
replace columns (insert_num int,
+             c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 
DOUBLE,
+             c7 INT, c8 BIGINT, c9 decimal(38,18), c10 FLOAT, c11 DOUBLE,
+             c12 BIGINT, c13 decimal(38,18), c14 FLOAT, c15 DOUBLE,
+             c16 decimal(38,18), c17 FLOAT, c18 DOUBLE,
+             b STRING) ;
+
+insert into table table_change_lower_to_higher_numeric_group_tinyint_to_bigint 
VALUES (111,
+            7000, 80000, 90000000, 1234.5678, 9876.543, 789.321,
+            80000, 90000000, 1234.5678, 9876.543, 789.321,
+            90000000, 1234.5678, 9876.543, 789.321,
+            1234.5678, 9876.543, 789.321,
+           'new');
 
 --** select 
insert_num,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18,b 
from table_change_lower_to_higher_numeric_group_tinyint_to_bigint;
 
@@ -354,9 +354,9 @@ select insert_num,c1,c2,c3,b from 
table_change_lower_to_higher_numeric_group_dec
 select insert_num,c1,c2,c3,b from 
table_change_lower_to_higher_numeric_group_decimal_to_float;
 
 -- Table-Non-Cascade CHANGE COLUMNS ...
---** alter table table_change_lower_to_higher_numeric_group_decimal_to_float 
replace columns (insert_num int, c1 float, c2 double, c3 DOUBLE, b STRING) ;
+alter table table_change_lower_to_higher_numeric_group_decimal_to_float 
replace columns (insert_num int, c1 float, c2 double, c3 DOUBLE, b STRING) ;
 
---** insert into table 
table_change_lower_to_higher_numeric_group_decimal_to_float VALUES (111, 
1234.5678, 9876.543, 1234.5678, 'new');
+insert into table table_change_lower_to_higher_numeric_group_decimal_to_float 
VALUES (111, 1234.5678, 9876.543, 1234.5678, 'new');
 
 --** select insert_num,c1,c2,c3,b from 
table_change_lower_to_higher_numeric_group_decimal_to_float;
 

Reply via email to