You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by mm...@apache.org on 2016/08/28 06:31:50 UTC
[36/48] hive git commit: HIVE-14515: Schema evolution uses slow
INSERT INTO .. VALUES (Matt McCline, reviewed by Prasanth Jayachandran)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb534ab0/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_part_all_primitive.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_part_all_primitive.q b/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_part_all_primitive.q
deleted file mode 100644
index b13c112..0000000
--- a/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_part_all_primitive.q
+++ /dev/null
@@ -1,544 +0,0 @@
-set hive.explain.user=true;
-set hive.mapred.mode=nonstrict;
-set hive.cli.print.header=true;
-SET hive.exec.schema.evolution=true;
-SET hive.vectorized.use.vectorized.input.format=true;
-SET hive.vectorized.use.vector.serde.deserialize=false;
-SET hive.vectorized.use.row.serde.deserialize=false;
-set hive.fetch.task.conversion=none;
-SET hive.vectorized.execution.enabled=false;
-set hive.exec.dynamic.partition.mode=nonstrict;
-set hive.metastore.disallow.incompatible.col.type.changes=false;
-set hive.default.fileformat=textfile;
-set hive.llap.io.enabled=false;
-
--- SORT_QUERY_RESULTS
---
--- FILE VARIATION: TEXTFILE, Non-Vectorized, MapWork, Partitioned --> all primitive conversions
---
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE CHANGE COLUMNS Various --> Various
---
---
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BYTE, SHORT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, TIMESTAMP) --> BOOLEAN
---
-CREATE TABLE part_change_various_various_boolean(insert_num int, c1 TINYINT, c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_boolean partition(part=1)
- values(1, 255, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, 'true', '0004-09-22 18:26:29.519542222', 'original'),
- (2, 45, 1000, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_boolean partition(part=2)
- values (5, 1, true, false, 1, 0, false, false, true, false, 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, SHORT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> BYTE
--- -128 and a maximum value of 127
---
-CREATE TABLE part_change_various_various_tinyint(insert_num int, c1 BOOLEAN, c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_tinyint partition(part=1)
- values(1, true, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, '129', '-128', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
- (2, 0, -128, -48, -20, -9223372036854775808.0, -9223372036854775808.0, 9223372036854775807.0, '128', '-99', '40', '2007-02-09 05:17:29.368756876', 'original'),
- (3, -1, -129, 100, 499, -9223372036854775809.0, -9223372036854775809.0, 9223372036854775808.0, '128', '-99', '40', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_tinyint partition(part=2)
- values (6, 23, 71, 127, 1, 131, -60, 68, -230, -182, 40, 93, 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> SMALLINT
--- -32768 and a maximum value of 32767
---
-CREATE TABLE part_change_various_various_smallint(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_smallint partition(part=1)
- values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
- (2, 0, 100, -32768 , 32767, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '9000', '32767', '-32768', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, -127, -40000 , 32768, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '9000', '32767', '-32768', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_smallint partition(part=2)
- values (6, -30486, 15230, 3117, 1, -117, -7131, 20227, -24858, -28771, 46114, 72909, 'new');
-
-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;
-
-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;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> INT
--- \u20132147483648 to 2147483647
---
-CREATE TABLE part_change_various_various_int(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_int partition(part=1)
- values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
- (2, 0, 100, 2147483647, -23866739993, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, 2147483648, -23866739993, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_int partition(part=2)
- values (5, 560930, -1281818, 127, 1, 84269672, -60, 27094665, -36016110, -182, 3244222, 561431, 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> BIGINT
--- -9223372036854775808 to 9223372036854775807
---
-CREATE TABLE part_change_various_various_bigint(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_bigint partition(part=1)
- values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
- (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_bigint partition(part=2)
- values (6, 5573199346255528403, 71, 151775655, 1, 131, -60, 6275638713485623898, -230, -695025, 519542222, -29.0764, 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> FLOAT
---
-CREATE TABLE part_change_various_various_float(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_float partition(part=1)
- values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
- (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_float partition(part=2)
- values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, -3651.67212, 46114.28, 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, FLOAT, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> DOUBLE
---
-CREATE TABLE part_change_various_various_double(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_double partition(part=1)
- values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
- (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_double partition(part=2)
- values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, FLOAT, DOUBLE, STRING, CHAR, VARCHAR, TIMESTAMP) --> DECIMAL
---
-CREATE TABLE part_change_various_various_decimal(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_decimal partition(part=1)
- values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '--1551801.09502', '--1551801.09502', '--1551801.09502', '0004-09-22 18:26:29.519542222', 'original'),
- (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_decimal partition(part=2)
- values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, FLOAT, DOUBLE, DECIMAL(38,18), CHAR, VARCHAR, TIMESTAMP, DATE, BINARY) --> STRING
---
-CREATE TABLE part_change_various_various_string(insert_num int, 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, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_string partition(part=1)
- values(1, true, 200, 72909, 3244222, -99999999999, -29.0764, 470614135, 470614135, 'dynamic reptile ', 'dynamic reptile ', '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
- (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_string partition(part=2)
- values (6, 'true', '400', '44388', -'100', '953967041.', '62.079153', '718.78', '1', 'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, FLOAT, DOUBLE, DECIMAL(38,18), STRING, VARCHAR, TIMESTAMP, DATE, BINARY) --> CHAR
---
-CREATE TABLE part_change_various_various_char(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 DECIMAL(38,18), c9 STRING, c10 VARCHAR(25), c11 TIMESTAMP, c12 DATE, c13 BINARY, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_char partition(part=1)
- values(1, true, 200, 72909, 3244222, -99999999999, -29.0764, 470614135, 470614135, 'dynamic reptile ', 'dynamic reptile ', '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
- (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_char partition(part=2)
- values (6, 'true', '400', '44388', -'100', '953967041.', '62.079153', '718.78', '1', 'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, FLOAT, DOUBLE, DECIMAL(38,18), STRING, VARCHAR, TIMESTAMP, DATE, BINARY) --> CHAR trunc
---
-CREATE TABLE part_change_various_various_char_trunc(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 DECIMAL(38,18), c9 STRING, c10 VARCHAR(8), c11 TIMESTAMP, c12 DATE, c13 BINARY, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_char_trunc partition(part=1)
- values(1, true, 200, 72909, 3244222, -99999999999, -29.0764, 470614135, 470614135, 'dynamic reptile ', 'dynamic reptile ', '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
- (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_char_trunc partition(part=2)
- values (6, 'true', '400', '44388', -'100', '953967041.', '62.079153', '718.78', '1', 'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, FLOAT, DOUBLE, DECIMAL(38,18), STRING, CHAR, TIMESTAMP, DATE, BINARY) --> VARCHAR
---
-CREATE TABLE part_change_various_various_varchar(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 DECIMAL(38,18), c9 STRING, c10 CHAR(25), c11 TIMESTAMP, c12 DATE, c13 BINARY, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_varchar partition(part=1)
- values(1, true, 200, 72909, 3244222, -99999999999, -29.0764, 470614135, 470614135, 'dynamic reptile ', 'dynamic reptile ', '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
- (2, 0, 100, 32767, -23372036854775, -9223372036854775808.0, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -9223372036854775809.0, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_varchar partition(part=2)
- values (6, 'true', '400', '44388', -'100', '953967041.', '62.079153', '718.78', '1', 'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, FLOAT, DOUBLE, DECIMAL(38,18), STRING, CHAR, TIMESTAMP, DATE, BINARY) --> VARCHAR trunc
---
-CREATE TABLE part_change_various_various_varchar_trunc(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 DECIMAL(38,18), c9 STRING, c10 CHAR(25), c11 TIMESTAMP, c12 DATE, c13 BINARY, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_varchar_trunc partition(part=1)
- values(1, true, 200, 72909, 3244222, -99999999999, -29.0764, 470614135, 470614135, 'dynamic reptile ', 'dynamic reptile ', '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
- (2, 0, 100, 32767, -23372036854775, -9223372036854775808.0, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -9223372036854775809.0, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_varchar_trunc partition(part=2)
- values (5, 'true', '400', '44388', -'100', '953967041.', '62.079153', '718.78', '1', 'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new');
-
-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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, LONG, FLOAT, DOUBLE, DECIMAL(38,18), STRING, CHAR, VARCHAR, DATE) --> TIMESTAMP
---
-CREATE TABLE part_change_various_various_timestamp(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 BIGINT, c6 FLOAT, c7 DOUBLE, c8 DECIMAL(38,18), c9 STRING, c10 CHAR(25), c11 VARCHAR(25), c12 DATE, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_timestamp partition(part=1)
- values(1, true, 200, 72909, 3244222, -99999999999, -29.0764, 470614135, 470614135, '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '2007-02-09', 'original'),
- (2, 0, 100, 32767, -23372036854775, -9223372036854775808.0, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (3, 0, 100, -32768, 23372036854775, -9223372036854775809.0, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_timestamp partition(part=2)
- values (6, 'true', '400', '44388', -'100', '953967041.', '62.079153', '718.78', '1', 'timestamp', 'timestamp', 'timestamp', 'date', 'new');
-
-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;
-
-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;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (STRING, CHAR, VARCHAR, TIMESTAMP --> DATE
---
-CREATE TABLE part_change_various_various_date(insert_num int, c1 STRING, c2 CHAR(25), c3 VARCHAR(25), c4 TIMESTAMP, b STRING) PARTITIONED BY(part INT);
-
-insert into table part_change_various_various_date partition(part=1)
- values(1, '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', 'original'),
- (2, '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', 'original'),
- (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;
-
--- 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);
-
-insert into table part_change_various_various_date partition(part=2)
- values (5, '2016-03-07', '2016-03-07', '2016-03-07', '2016-03-07', 'new');
-
-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;
-
-select insert_num,part,c1,c2,c3,c4,b from part_change_various_various_date;
-
-drop table part_change_various_various_date;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Same Type (CHAR, VARCHAR, DECIMAL) --> Different maxLength or precision/scale
---
-CREATE TABLE part_change_same_type_different_params(insert_num int, c1 CHAR(12), c2 CHAR(25), c3 VARCHAR(25), c4 VARCHAR(10), c5 DECIMAL(12,4), c6 DECIMAL(20,10), b STRING) PARTITIONED BY(part INT);
-
-CREATE TABLE same_type1_a_txt(insert_num int, c1 CHAR(12), c2 CHAR(25), c3 VARCHAR(25), c4 VARCHAR(10), c5 DECIMAL(12,4), c6 DECIMAL(20,10), b STRING)
-row format delimited fields terminated by '|'
-stored as textfile;
-load data local inpath '../../data/files/same_type1_a.txt' overwrite into table same_type1_a_txt;
-
-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;
-
--- 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);
-
-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/same_type1_b.txt' overwrite into table same_type1_b_txt;
-
-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/same_type1_c.txt' overwrite into table same_type1_c_txt;
-
-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;
-
-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/cb534ab0/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q b/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q
deleted file mode 100644
index dd3edb9..0000000
--- a/ql/src/test/queries/clientpositive/schema_evol_text_nonvec_mapwork_table.q
+++ /dev/null
@@ -1,825 +0,0 @@
-set hive.explain.user=true;
-set hive.cli.print.header=true;
-SET hive.exec.schema.evolution=true;
-SET hive.vectorized.use.vectorized.input.format=true;
-SET hive.vectorized.use.vector.serde.deserialize=false;
-SET hive.vectorized.use.row.serde.deserialize=false;
-set hive.fetch.task.conversion=none;
-SET hive.vectorized.execution.enabled=false;
-set hive.exec.dynamic.partition.mode=nonstrict;
-set hive.metastore.disallow.incompatible.col.type.changes=true;
-set hive.default.fileformat=textfile;
-set hive.llap.io.enabled=false;
-
--- SORT_QUERY_RESULTS
---
--- FILE VARIATION: TEXTFILE, Non-Vectorized, MapWork, Table
---
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE ADD COLUMNS
---
---
--- SUBSECTION: ALTER TABLE ADD COLUMNS: INT PERMUTE SELECT
---
---
-CREATE TABLE table_add_int_permute_select(insert_num int, a INT, b STRING);
-DESCRIBE FORMATTED table_add_int_permute_select;
-
-insert into table table_add_int_permute_select
- values (1, 1, 'original'),
- (2, 2, 'original'),
- (3, 3, 'original'),
- (4, 4, 'original');
-
--- Table-Non-Cascade ADD COLUMNS ...
-alter table table_add_int_permute_select add columns(c int);
-DESCRIBE FORMATTED table_add_int_permute_select;
-
-insert into table table_add_int_permute_select
- values (5, 1, 'new', 10),
- (6, 2, 'new', 20),
- (7, 3, 'new', 30),
- (8, 4, 'new', 40);
-
-insert into table table_add_int_permute_select
- values (9, 5, 'new', 100),
- (10, 6, 'new', 200);
-
-explain
-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;
-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;
-
-
--- SUBSECTION: ALTER TABLE ADD COLUMNS: INT, STRING, PERMUTE SELECT
---
---
-CREATE TABLE table_add_int_string_permute_select(insert_num int, a INT, b STRING);
-DESCRIBE FORMATTED table_add_int_string_permute_select;
-
-insert into table table_add_int_string_permute_select
- values (1, 1, 'original'),
- (2, 2, 'original'),
- (3, 3, 'original'),
- (4, 4, 'original');
-
--- Table-Non-Cascade ADD COLUMNS ...
-alter table table_add_int_string_permute_select add columns(c int, d string);
-DESCRIBE FORMATTED table_add_int_string_permute_select;
-
-insert into table table_add_int_string_permute_select
- values (5, 1, 'new', 10, 'ten'),
- (6, 2, 'new', 20, 'twenty'),
- (7, 3, 'new', 30, 'thirty'),
- (8, 4, 'new', 40, 'forty');
-
-insert into table table_add_int_string_permute_select
- values (9, 5, 'new', 100, 'hundred'),
- (10, 6, 'new', 200, 'two hundred');
-
-explain
-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;
-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;
-
-
-
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> DOUBLE
---
---
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> DOUBLE: (STRING, CHAR, VARCHAR)
---
-CREATE TABLE table_change_string_group_double(insert_num int, c1 STRING, c2 CHAR(50), c3 VARCHAR(50), b STRING);
-
-insert into table table_change_string_group_double
- values (1, '753.7028', '753.7028', '753.7028', 'original'),
- (2, '-3651.672121', '-3651.672121', '-3651.672121', 'original'),
- (3, '-29.0764', '-29.0764', '-29.0764', 'original'),
- (4, '-10.3', '-10.3', '-10.3', 'original');
-
--- 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);
-
-insert into table table_change_string_group_double
- values (5, 30.774, 30.774, 30.774, 'new'),
- (6, 20.31, 20.31, 20.31, 'new'),
- (7, 46114.284799488, 46114.284799488, 46114.284799488, 'new'),
- (8, -66475.561431, -66475.561431, -66475.561431, 'new');
-
-insert into table table_change_string_group_double
- values (9, 17808.963785, 17808.963785, 17808.963785, 'new'),
- (10, 9250340.75 , 9250340.75 , 9250340.75 , 'new');
-
-explain
-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;
-
-drop table table_change_string_group_double;
-
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP
---
---
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP: TIMESTAMP, (STRING, CHAR, CHAR trunc, VARCHAR, VARCHAR trunc)
---
-CREATE TABLE table_change_date_group_string_group_timestamp(insert_num int, c1 TIMESTAMP, c2 TIMESTAMP, c3 TIMESTAMP, c4 TIMESTAMP, c5 TIMESTAMP, b STRING);
-
-insert into table table_change_date_group_string_group_timestamp
- values (1, '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', '2000-12-18 08:42:30.000595596', 'original'),
- (2, '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', '2024-11-11 16:42:41.101', 'original'),
- (3, '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', '2021-09-24 03:18:32.413655165', 'original');
-
--- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_date_group_string_group_timestamp replace columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 VARCHAR(15), b STRING);
-
-insert into table table_change_date_group_string_group_timestamp
- values (4, '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', '0004-09-22 18:26:29.519542222', 'new'),
- (5, '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', '1815-05-06 00:12:37.543584705', 'new'),
- (6, '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', '2007-02-09 05:17:29.368756876', 'new'),
- (7, '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', '2002-05-10 05:29:48.990818073', 'new');
-insert into table table_change_date_group_string_group_timestamp
- values (8, '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', '6229-06-28 02:54:28.970117179', 'new'),
- (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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for DATE_GROUP -> STRING_GROUP: DATE, (STRING, CHAR, CHAR trunc, VARCHAR, VARCHAR trunc)
---
-CREATE TABLE table_change_date_group_string_group_date(insert_num int, c1 DATE, c2 DATE, c3 DATE, c4 DATE, c5 DATE, b STRING);
-
-insert into table table_change_date_group_string_group_date
- values (1, '2000-12-18', '2000-12-18', '2000-12-18', '2000-12-18', '2000-12-18', 'original'),
- (2, '2024-11-11', '2024-11-11', '2024-11-11', '2024-11-11', '2024-11-11', 'original'),
- (3, '2021-09-24', '2021-09-24', '2021-09-24', '2021-09-24', '2021-09-24', 'original');
-
--- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_date_group_string_group_date replace columns(insert_num int, c1 STRING, c2 CHAR(50), c3 CHAR(15), c4 VARCHAR(50), c5 VARCHAR(15), b STRING);DESCRIBE FORMATTED table_change_date_group_string_group_date;
-
-insert into table table_change_date_group_string_group_date
- values (4, '0004-09-22', '0004-09-22', '0004-09-22', '0004-09-22', '0004-09-22', 'new'),
- (5, '1815-05-06', '1815-05-06', '1815-05-06', '1815-05-06', '1815-05-06', 'new'),
- (6, '2007-02-09', '2007-02-09', '2007-02-09', '2007-02-09', '2007-02-09', 'new'),
- (7, '2002-05-10', '2002-05-10', '2002-05-10', '2002-05-10', '2002-05-10', 'new'),
- (8, '6229-06-28', '6229-06-28', '6229-06-28', '6229-06-28', '6229-06-28', 'new'),
- (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;
-
-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;
-
-
-
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP
---
---
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), STRING
---
-CREATE TABLE table_change_numeric_group_string_group_multi_ints_string(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING);
-
-insert into table table_change_numeric_group_string_group_multi_ints_string
- values (1, 45, 1000, 483777, -23866739993, 'original'),
- (2, -2, -6737, 56, 28899333, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_multi_ints_string
- values (5, '2000', '72909', '3244222', '-93222', 'new'),
- (6, '1', '200', '2323322', '5430907', 'new'),
- (7, '256', '32768', '31889', '470614135', 'new'),
- (8, '5555', '40000', '-719017797', '810662019', 'new'),
- (9, '100', '5000', '5443', '0', 'new'),
- (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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), CHAR
---
-CREATE TABLE table_change_numeric_group_string_group_multi_ints_char(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING);
-
-insert into table table_change_numeric_group_string_group_multi_ints_char
- values (1, 45, 1000, 483777, -23866739993, 'original'),
- (2, -2, -6737, 56, 28899333, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_multi_ints_char
- values (5, '2000', '72909', '3244222', '-93222', 'new'),
- (6, '1', '200', '2323322', '5430907', 'new'),
- (7, '256', '32768', '31889', '470614135', 'new'),
- (8, '5555', '40000', '-719017797', '810662019', 'new'),
- (9, '100', '5000', '5443', '0', 'new'),
- (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;
-
-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;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), CHAR truncation
---
-CREATE TABLE table_change_numeric_group_string_group_multi_ints_char_trunc(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING);
-
-insert into table table_change_numeric_group_string_group_multi_ints_char_trunc
- values (1, 45, 1000, 483777, -23866739993, 'original'),
- (2, -2, -6737, 56, 28899333, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_multi_ints_char_trunc
- values (5, '2000', '72909', '3244222', '-93222', 'new'),
- (6, '1', '200', '2323322', '5430907', 'new'),
- (7, '256', '32768', '31889', '470614135', 'new'),
- (8, '5555', '40000', '-719017797', '810662019', 'new'),
- (9, '100', '5000', '5443', '0', 'new'),
- (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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), VARCHAR
---
-CREATE TABLE table_change_numeric_group_string_group_multi_ints_varchar(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING);
-
-insert into table table_change_numeric_group_string_group_multi_ints_varchar
- values (1, 45, 1000, 483777, -23866739993, 'original'),
- (2, -2, -6737, 56, 28899333, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_multi_ints_varchar
- values (5, '2000', '72909', '3244222', '-93222', 'new'),
- (6, '1', '200', '2323322', '5430907', 'new'),
- (7, '256', '32768', '31889', '470614135', 'new'),
- (8, '5555', '40000', '-719017797', '810662019', 'new'),
- (9, '100', '5000', '5443', '0', 'new'),
- (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;
-
-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;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (TINYINT, SMALLINT, INT, BIGINT), VARCHAR truncation
---
-CREATE TABLE table_change_numeric_group_string_group_multi_ints_varchar_trunc(insert_num int, c1 tinyint, c2 smallint, c3 int, c4 bigint, b STRING);
-
-insert into table table_change_numeric_group_string_group_multi_ints_varchar_trunc
- values (1, 45, 1000, 483777, -23866739993, 'original'),
- (2, -2, -6737, 56, 28899333, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_multi_ints_varchar_trunc
- values (5, '2000', '72909', '3244222', '-93222', 'new'),
- (6, '1', '200', '2323322', '5430907', 'new'),
- (7, '256', '32768', '31889', '470614135', 'new'),
- (8, '5555', '40000', '-719017797', '810662019', 'new'),
- (9, '100', '5000', '5443', '0', 'new'),
- (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;
-
-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;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING
---
-CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING);
-
-insert into table table_change_numeric_group_string_group_floating_string
- values (1, -23866739993, 753.7028, -3651.672121, 'original'),
- (2, -10.3, -2, -29.0764, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_floating_string
- values (5, '30.774', '20.31', '46114.284799488', 'new'),
- (6, '-66475.561431', '52927714', '7203778961', 'new'),
- (7, '256', '32768', '31889', 'new'),
- (8, '5555', '40000', '-719017797', 'new'),
- (9, '100', '5000', '5443', 'new'),
- (10, '17', '90000', '754072151', 'new');
-
-explain
-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;
-
-drop table table_change_numeric_group_string_group_floating_string;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR
---
-CREATE TABLE table_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING);
-
-insert into table table_change_numeric_group_string_group_floating_char
- values (1, -23866739993, 753.7028, -3651.672121, 'original'),
- (2, -10.3, -2, -29.0764, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_floating_char
- values (5, '30.774', '20.31', '46114.284799488', 'new'),
- (6, '-66475.561431', '52927714', '7203778961', 'new'),
- (7, '256', '32768', '31889', 'new'),
- (8, '5555', '40000', '-719017797', 'new'),
- (9, '100', '5000', '5443', 'new'),
- (10, '17', '90000', '754072151', 'new');
-
-explain
-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;
-
-drop table table_change_numeric_group_string_group_floating_char;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR truncation
---
-CREATE TABLE table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING);
-
-insert into table table_change_numeric_group_string_group_floating_char_trunc
- values (1, -23866739993, 753.7028, -3651.672121, 'original'),
- (2, -10.3, -2, -29.0764, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_floating_char_trunc
- values (5, '30.774', '20.31', '46114.284799488', 'new'),
- (6, '-66475.561431', '52927714', '7203778961', 'new'),
- (7, '256', '32768', '31889', 'new'),
- (8, '5555', '40000', '-719017797', 'new'),
- (9, '100', '5000', '5443', 'new'),
- (10, '17', '90000', '754072151', 'new');
-
-explain
-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;
-
-drop table table_change_numeric_group_string_group_floating_char_trunc;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR
---
-CREATE TABLE table_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING);
-
-insert into table table_change_numeric_group_string_group_floating_varchar
- values (1, -23866739993, 753.7028, -3651.672121, 'original'),
- (2, -10.3, -2, -29.0764, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_floating_varchar
- values (5, '30.774', '20.31', '46114.284799488', 'new'),
- (6, '-66475.561431', '52927714', '7203778961', 'new'),
- (7, '256', '32768', '31889', 'new'),
- (8, '5555', '40000', '-719017797', 'new'),
- (9, '100', '5000', '5443', 'new'),
- (10, '17', '90000', '754072151', 'new');
-
-explain
-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;
-
-drop table table_change_numeric_group_string_group_floating_varchar;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR truncation
---
-CREATE TABLE table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING);
-
-insert into table table_change_numeric_group_string_group_floating_varchar_trunc
- values (1, -23866739993, 753.7028, -3651.672121, 'original'),
- (2, -10.3, -2, -29.0764, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_numeric_group_string_group_floating_varchar_trunc
- values (5, '30.774', '20.31', '46114.284799488', 'new'),
- (6, '-66475.561431', '52927714', '7203778961', 'new'),
- (7, '256', '32768', '31889', 'new'),
- (8, '5555', '40000', '-719017797', 'new'),
- (9, '100', '5000', '5443', 'new'),
- (10, '17', '90000', '754072151', 'new');
-
-explain
-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;
-
-drop table table_change_numeric_group_string_group_floating_varchar_trunc;
-
-
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> STRING_GROUP
---
---
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> STRING_GROUP: STRING, (CHAR, CHAR trunc, VARCHAR, VARCHAR trunc)
---
-CREATE TABLE table_change_string_group_string_group_string(insert_num int, c1 string, c2 string, c3 string, c4 string, b STRING);
-
-insert into table table_change_string_group_string_group_string
- values (1, 'escapist', 'escapist', 'escapist', 'escapist', 'original'),
- (2, 'heartbeat', 'heartbeat', 'heartbeat', 'heartbeat', 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_string_group_string_group_string
- values (5, 'junkyard', 'junkyard', 'junkyard', 'junkyard', 'new'),
- (6, ' baffling ', ' baffling ', ' baffling ', ' baffling ', 'new'),
- (7, ' featherweight ', ' featherweight ',' featherweight ',' featherweight ', 'new'),
- (8, ' against', ' against', ' against', ' against', 'new'),
- (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'),
- (10, 'bottom ', 'bottom ', 'bottom ', 'bottom ', 'new');
-
-explain
-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;
-
-drop table table_change_string_group_string_group_string;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> STRING_GROUP: CHAR, (VARCHAR, VARCHAR trunc, STRING)
---
-CREATE TABLE table_change_string_group_string_group_char(insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), b STRING);
-
-insert into table table_change_string_group_string_group_char
- values (1, 'escapist', 'escapist', 'escapist', 'original'),
- (2, 'heartbeat', 'heartbeat', 'heartbeat', 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_string_group_string_group_char
- values (5, 'junkyard', 'junkyard', 'junkyard', 'new'),
- (6, ' baffling ', ' baffling ', ' baffling ', 'new'),
- (7, ' featherweight ', ' featherweight ',' featherweight ', 'new'),
- (8, ' against', ' against', ' against', 'new'),
- (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'),
- (10, 'bottom ', 'bottom ', 'bottom ', 'new');
-
-explain
-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;
-
-drop table table_change_string_group_string_group_char;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for STRING_GROUP -> STRING_GROUP: VARCHAR, (CHAR, CHAR trunc, STRING)
---
-CREATE TABLE table_change_string_group_string_group_varchar(insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), b STRING);
-
-insert into table table_change_string_group_string_group_varchar
- values (1, 'escapist', 'escapist', 'escapist', 'original'),
- (2, 'heartbeat', 'heartbeat', 'heartbeat', 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_string_group_string_group_varchar
- values (5, 'junkyard', 'junkyard', 'junkyard', 'new'),
- (6, ' baffling ', ' baffling ', ' baffling ', 'new'),
- (7, ' featherweight ', ' featherweight ',' featherweight ', 'new'),
- (8, ' against', ' against', ' against', 'new'),
- (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'),
- (10, 'bottom ', 'bottom ', 'bottom ', 'new');
-
-explain
-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;
-
-drop table table_change_string_group_string_group_varchar;
-
-
-
-------------------------------------------------------------------------------------------
--- SECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP
---
---
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
---
-CREATE TABLE table_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING);
-
-insert into table table_change_lower_to_higher_numeric_group_tinyint
- values (1, 45, 45, 45, 45, 45, 45, 'original'),
- (2, -2, -2, -2, -2, -2, -2, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_lower_to_higher_numeric_group_tinyint
- values (5, '774', '2031', '200', '12', '99', '0', 'new'),
- (6, '561431', '52927714', '7203778961', '8', '7', '6', 'new'),
- (7, '256', '32768', '31889', '300', '444', '506', 'new'),
- (8, '5555', '40000', '-719017797', '45', '55', '65', 'new'),
- (9, '100', '5000', '5443', '22', '2', '-2', 'new'),
- (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;
-
-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;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
---
-CREATE TABLE table_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING);
-
-insert into table table_change_lower_to_higher_numeric_group_smallint
- values (1, 2031, 2031, 2031, 2031, 2031, 'original'),
- (2, -2, -2, -2, -2, -2, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_lower_to_higher_numeric_group_smallint
- values (5, '774', '2031', '200', '12', '99', 'new'),
- (6, '561431', '52927714', '7203778961', '8', '7', 'new'),
- (7, '256', '32768', '31889', '300', '444', 'new'),
- (8, '5555', '40000', '-719017797', '45', '55', 'new'),
- (9, '100', '5000', '5443', '22', '2', 'new'),
- (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;
-
-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;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, DECIMAL, FLOAT, DOUBLE)
---
-CREATE TABLE table_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING);
-
-insert into table table_change_lower_to_higher_numeric_group_int
- values (1, 2031, 2031, 2031, 2031, 'original'),
- (2, -2, -2, -2, -2, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_lower_to_higher_numeric_group_int
- values (5, '774', '2031', '200', '12', 'new'),
- (6, '561431', '52927714', '7203778961', '8', 'new'),
- (7, '256', '32768', '31889', '300', 'new'),
- (8, '5555', '40000', '-719017797', '45', 'new'),
- (9, '100', '5000', '5443', '22', 'new'),
- (10, '17', '90000', '754072151', '95', 'new');
-
-explain
-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;
-
-drop table table_change_lower_to_higher_numeric_group_int;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (DECIMAL, FLOAT, DOUBLE)
---
-CREATE TABLE table_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING);
-
-insert into table table_change_lower_to_higher_numeric_group_bigint
- values (1, 7203778961, 7203778961, 7203778961, 'original'),
- (2, -2, -2, -2, 'original'),
- (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;
-
--- 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) ;
-
-insert into table table_change_lower_to_higher_numeric_group_bigint
- values (5, '774', '2031', '200', 'new'),
- (6, '561431', '52927714', '7203778961', 'new'),
- (7, '256', '32768', '31889', 'new'),
- (8, '5555', '40000', '-719017797', 'new'),
- (9, '100', '5000', '5443', 'new'),
- (10, '17', '90000', '754072151', 'new');
-
-explain
-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;
-
-drop table table_change_lower_to_higher_numeric_group_bigint;
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE)
---
-CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING);
-
-insert into table table_change_lower_to_higher_numeric_group_decimal
- values (1, -29.0764, -29.0764, 'original'),
- (2, 753.7028, 753.7028, 'original'),
- (3, -5000, -5000, 'original'),
- (4, 52927714, 52927714, 'original');
-
-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) ;
-
-insert into table table_change_lower_to_higher_numeric_group_decimal
- values (5, '7.74', '22.3', 'new'),
- (6, '56.1431', '90.9', 'new'),
- (7, '2.56', '25.6', 'new'),
- (8, '555.5', '55.55', 'new'),
- (9, '10.0', '0.100', 'new'),
- (10, '1.7', '17.8888', 'new');
-
-explain
-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;
-
-drop table table_change_lower_to_higher_numeric_group_decimal;
-
-
-
---
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE)
---
-CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING);
-
-insert into table table_change_lower_to_higher_numeric_group_float
- values (1, -29.0764, 'original'),
- (2, 753.7028, 'original'),
- (3, -5000, 'original'),
- (4, 52927714, 'original');
-
-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) ;
-
-insert into table table_change_lower_to_higher_numeric_group_float
- values (5, '774', 'new'),
- (6, '561431', 'new'),
- (7, '256', 'new'),
- (8, '5555', 'new'),
- (9, '100', 'new'),
- (10, '17', 'new');
-
-explain
-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;
-
-drop table table_change_lower_to_higher_numeric_group_float;