HIVE-14376: Schema evolution tests takes a long time (Prasanth Jayachandran reviewed by Matt McCline)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/9a798130 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/9a798130 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/9a798130 Branch: refs/heads/master Commit: 9a798130e6da4726f4ed042cb8453bb9bff3dbb5 Parents: 87208aa Author: Prasanth Jayachandran <prasan...@apache.org> Authored: Wed Aug 10 17:09:00 2016 -0700 Committer: Prasanth Jayachandran <prasan...@apache.org> Committed: Wed Aug 10 17:09:00 2016 -0700 ---------------------------------------------------------------------- .../test/resources/testconfiguration.properties | 83 +- .../schema_evol_orc_acid_mapwork_part.q | 104 +- .../schema_evol_orc_acid_mapwork_table.q | 104 +- .../schema_evol_orc_acidvec_mapwork_part.q | 104 +- .../schema_evol_orc_acidvec_mapwork_table.q | 104 +- .../schema_evol_orc_nonvec_fetchwork_part.q | 150 +- .../schema_evol_orc_nonvec_fetchwork_table.q | 152 +- .../schema_evol_orc_nonvec_mapwork_part.q | 150 +- ...a_evol_orc_nonvec_mapwork_part_all_complex.q | 20 +- ...evol_orc_nonvec_mapwork_part_all_primitive.q | 96 +- .../schema_evol_orc_nonvec_mapwork_table.q | 152 +- .../schema_evol_orc_vec_mapwork_part.q | 150 +- ...hema_evol_orc_vec_mapwork_part_all_complex.q | 20 +- ...ma_evol_orc_vec_mapwork_part_all_primitive.q | 96 +- .../schema_evol_orc_vec_mapwork_table.q | 152 +- .../schema_evol_text_nonvec_mapwork_part.q | 150 +- ..._evol_text_nonvec_mapwork_part_all_complex.q | 20 +- ...vol_text_nonvec_mapwork_part_all_primitive.q | 96 +- .../schema_evol_text_nonvec_mapwork_table.q | 152 +- .../schema_evol_text_vec_mapwork_part.q | 150 +- ...ema_evol_text_vec_mapwork_part_all_complex.q | 20 +- ...a_evol_text_vec_mapwork_part_all_primitive.q | 96 +- .../schema_evol_text_vec_mapwork_table.q | 152 +- .../schema_evol_text_vecrow_mapwork_part.q | 150 +- ..._evol_text_vecrow_mapwork_part_all_complex.q | 20 +- ...vol_text_vecrow_mapwork_part_all_primitive.q | 96 +- .../schema_evol_text_vecrow_mapwork_table.q | 152 +- .../schema_evol_orc_acid_mapwork_part.q.out | 204 +- .../schema_evol_orc_acid_mapwork_table.q.out | 204 +- .../schema_evol_orc_acidvec_mapwork_part.q.out | 204 +- .../schema_evol_orc_acidvec_mapwork_table.q.out | 204 +- .../schema_evol_orc_nonvec_fetchwork_part.q.out | 732 ++-- ...schema_evol_orc_nonvec_fetchwork_table.q.out | 732 ++-- .../schema_evol_orc_nonvec_mapwork_part.q.out | 708 ++-- ...ol_orc_nonvec_mapwork_part_all_complex.q.out | 91 +- ..._orc_nonvec_mapwork_part_all_primitive.q.out | 464 +- .../schema_evol_orc_nonvec_mapwork_table.q.out | 708 ++-- .../llap/schema_evol_orc_vec_mapwork_part.q.out | 708 ++-- ..._evol_orc_vec_mapwork_part_all_complex.q.out | 91 +- ...vol_orc_vec_mapwork_part_all_primitive.q.out | 464 +- .../schema_evol_orc_vec_mapwork_table.q.out | 708 ++-- .../schema_evol_text_nonvec_mapwork_part.q.out | 708 ++-- ...l_text_nonvec_mapwork_part_all_complex.q.out | 91 +- ...text_nonvec_mapwork_part_all_primitive.q.out | 464 +- .../schema_evol_text_nonvec_mapwork_table.q.out | 708 ++-- .../schema_evol_text_vec_mapwork_part.q.out | 708 ++-- ...evol_text_vec_mapwork_part_all_complex.q.out | 91 +- ...ol_text_vec_mapwork_part_all_primitive.q.out | 464 +- .../schema_evol_text_vec_mapwork_table.q.out | 708 ++-- .../schema_evol_text_vecrow_mapwork_part.q.out | 708 ++-- ...l_text_vecrow_mapwork_part_all_complex.q.out | 91 +- ...text_vecrow_mapwork_part_all_primitive.q.out | 464 +- .../schema_evol_text_vecrow_mapwork_table.q.out | 708 ++-- .../schema_evol_orc_acid_mapwork_part.q.out | 204 +- .../schema_evol_orc_acid_mapwork_table.q.out | 204 +- .../schema_evol_orc_acidvec_mapwork_part.q.out | 204 +- .../schema_evol_orc_acidvec_mapwork_table.q.out | 204 +- .../schema_evol_orc_nonvec_fetchwork_part.q.out | 1260 ++---- ...schema_evol_orc_nonvec_fetchwork_table.q.out | 1260 ++---- .../schema_evol_orc_nonvec_mapwork_part.q.out | 828 ++-- ...ol_orc_nonvec_mapwork_part_all_complex.q.out | 106 +- ..._orc_nonvec_mapwork_part_all_primitive.q.out | 544 +-- .../schema_evol_orc_nonvec_mapwork_table.q.out | 828 ++-- .../schema_evol_orc_vec_mapwork_part.q.out | 828 ++-- ..._evol_orc_vec_mapwork_part_all_complex.q.out | 106 +- ...vol_orc_vec_mapwork_part_all_primitive.q.out | 544 +-- .../schema_evol_orc_vec_mapwork_table.q.out | 828 ++-- .../schema_evol_text_nonvec_mapwork_part.q.out | 828 ++-- ...l_text_nonvec_mapwork_part_all_complex.q.out | 106 +- ...text_nonvec_mapwork_part_all_primitive.q.out | 544 +-- .../schema_evol_text_nonvec_mapwork_table.q.out | 828 ++-- .../schema_evol_text_vec_mapwork_part.q.out | 828 ++-- ...evol_text_vec_mapwork_part_all_complex.q.out | 106 +- ...ol_text_vec_mapwork_part_all_primitive.q.out | 544 +-- .../schema_evol_text_vec_mapwork_table.q.out | 828 ++-- .../schema_evol_text_vecrow_mapwork_part.q.out | 828 ++-- ...l_text_vecrow_mapwork_part_all_complex.q.out | 106 +- ...text_vecrow_mapwork_part_all_primitive.q.out | 544 +-- .../schema_evol_text_vecrow_mapwork_table.q.out | 828 ++-- .../tez/schema_evol_orc_acid_mapwork_part.q.out | 3662 ---------------- .../schema_evol_orc_acid_mapwork_table.q.out | 3331 --------------- .../schema_evol_orc_acidvec_mapwork_part.q.out | 3662 ---------------- .../schema_evol_orc_acidvec_mapwork_table.q.out | 3331 --------------- .../schema_evol_orc_nonvec_fetchwork_part.q.out | 3995 ----------------- ...schema_evol_orc_nonvec_fetchwork_table.q.out | 3747 ---------------- .../schema_evol_orc_nonvec_mapwork_part.q.out | 3995 ----------------- ...ol_orc_nonvec_mapwork_part_all_complex.q.out | 669 --- ..._orc_nonvec_mapwork_part_all_primitive.q.out | 2899 ------------- .../schema_evol_orc_nonvec_mapwork_table.q.out | 3747 ---------------- .../tez/schema_evol_orc_vec_mapwork_part.q.out | 3995 ----------------- ..._evol_orc_vec_mapwork_part_all_complex.q.out | 669 --- ...vol_orc_vec_mapwork_part_all_primitive.q.out | 2899 ------------- .../tez/schema_evol_orc_vec_mapwork_table.q.out | 3747 ---------------- .../clientpositive/tez/schema_evol_stats.q.out | 384 -- .../schema_evol_text_nonvec_mapwork_part.q.out | 3995 ----------------- ...l_text_nonvec_mapwork_part_all_complex.q.out | 669 --- ...text_nonvec_mapwork_part_all_primitive.q.out | 2899 ------------- .../schema_evol_text_nonvec_mapwork_table.q.out | 3747 ---------------- .../tez/schema_evol_text_vec_mapwork_part.q.out | 3999 ------------------ ...evol_text_vec_mapwork_part_all_complex.q.out | 673 --- ...ol_text_vec_mapwork_part_all_primitive.q.out | 2903 ------------- .../schema_evol_text_vec_mapwork_table.q.out | 3751 ---------------- .../schema_evol_text_vecrow_mapwork_part.q.out | 3999 ------------------ ...l_text_vecrow_mapwork_part_all_complex.q.out | 675 --- ...text_vecrow_mapwork_part_all_primitive.q.out | 2903 ------------- .../schema_evol_text_vecrow_mapwork_table.q.out | 3751 ---------------- 106 files changed, 11317 insertions(+), 97271 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/itests/src/test/resources/testconfiguration.properties ---------------------------------------------------------------------- diff --git a/itests/src/test/resources/testconfiguration.properties b/itests/src/test/resources/testconfiguration.properties index ac249ed..5aeca9c 100644 --- a/itests/src/test/resources/testconfiguration.properties +++ b/itests/src/test/resources/testconfiguration.properties @@ -191,33 +191,6 @@ minitez.query.files.shared=acid_globallimit.q,\ ptf_matchpath.q,\ ptf_streaming.q,\ sample1.q,\ - schema_evol_stats.q,\ - schema_evol_orc_acid_mapwork_part.q,\ - schema_evol_orc_acid_mapwork_table.q,\ - schema_evol_orc_acidvec_mapwork_part.q,\ - schema_evol_orc_acidvec_mapwork_table.q,\ - schema_evol_orc_nonvec_fetchwork_part.q,\ - schema_evol_orc_nonvec_fetchwork_table.q,\ - schema_evol_orc_nonvec_mapwork_part.q,\ - schema_evol_orc_nonvec_mapwork_part_all_complex.q,\ - schema_evol_orc_nonvec_mapwork_part_all_primitive.q,\ - schema_evol_orc_nonvec_mapwork_table.q,\ - schema_evol_orc_vec_mapwork_part.q,\ - schema_evol_orc_vec_mapwork_part_all_complex.q,\ - schema_evol_orc_vec_mapwork_part_all_primitive.q,\ - schema_evol_orc_vec_mapwork_table.q,\ - schema_evol_text_nonvec_mapwork_part.q,\ - schema_evol_text_nonvec_mapwork_part_all_complex.q,\ - schema_evol_text_nonvec_mapwork_part_all_primitive.q,\ - schema_evol_text_nonvec_mapwork_table.q,\ - schema_evol_text_vec_mapwork_part.q,\ - schema_evol_text_vec_mapwork_part_all_complex.q,\ - schema_evol_text_vec_mapwork_part_all_primitive.q,\ - schema_evol_text_vec_mapwork_table.q,\ - schema_evol_text_vecrow_mapwork_part.q,\ - schema_evol_text_vecrow_mapwork_part_all_complex.q,\ - schema_evol_text_vecrow_mapwork_part_all_primitive.q,\ - schema_evol_text_vecrow_mapwork_table.q,\ selectDistinctStar.q,\ script_env_var1.q,\ script_env_var2.q,\ @@ -505,33 +478,6 @@ minillap.shared.query.files=bucket_map_join_tez1.q,\ orc_ppd_schema_evol_2a.q,\ orc_ppd_schema_evol_2b.q,\ orc_ppd_schema_evol_3a.q,\ - schema_evol_stats.q,\ - schema_evol_orc_acid_mapwork_part.q,\ - schema_evol_orc_acid_mapwork_table.q,\ - schema_evol_orc_acidvec_mapwork_part.q,\ - schema_evol_orc_acidvec_mapwork_table.q,\ - schema_evol_orc_nonvec_fetchwork_part.q,\ - schema_evol_orc_nonvec_fetchwork_table.q,\ - schema_evol_orc_nonvec_mapwork_part.q,\ - schema_evol_orc_nonvec_mapwork_part_all_complex.q,\ - schema_evol_orc_nonvec_mapwork_part_all_primitive.q,\ - schema_evol_orc_nonvec_mapwork_table.q,\ - schema_evol_orc_vec_mapwork_part.q,\ - schema_evol_orc_vec_mapwork_part_all_complex.q,\ - schema_evol_orc_vec_mapwork_part_all_primitive.q,\ - schema_evol_orc_vec_mapwork_table.q,\ - schema_evol_text_nonvec_mapwork_part.q,\ - schema_evol_text_nonvec_mapwork_part_all_complex.q,\ - schema_evol_text_nonvec_mapwork_part_all_primitive.q,\ - schema_evol_text_nonvec_mapwork_table.q,\ - schema_evol_text_vec_mapwork_part.q,\ - schema_evol_text_vec_mapwork_part_all_complex.q,\ - schema_evol_text_vec_mapwork_part_all_primitive.q,\ - schema_evol_text_vec_mapwork_table.q,\ - schema_evol_text_vecrow_mapwork_part.q,\ - schema_evol_text_vecrow_mapwork_part_all_complex.q,\ - schema_evol_text_vecrow_mapwork_part_all_primitive.q,\ - schema_evol_text_vecrow_mapwork_table.q,\ tez_bmj_schema_evolution.q,\ tez_dml.q,\ tez_fsstat.q,\ @@ -568,7 +514,34 @@ minillap.query.files=llap_udf.q,\ orc_llap.q,\ orc_llap_counters.q,\ orc_llap_counters1.q,\ - orc_llap_nonvector.q + orc_llap_nonvector.q,\ + schema_evol_stats.q,\ + schema_evol_orc_acid_mapwork_part.q,\ + schema_evol_orc_acid_mapwork_table.q,\ + schema_evol_orc_acidvec_mapwork_part.q,\ + schema_evol_orc_acidvec_mapwork_table.q,\ + schema_evol_orc_nonvec_fetchwork_part.q,\ + schema_evol_orc_nonvec_fetchwork_table.q,\ + schema_evol_orc_nonvec_mapwork_part.q,\ + schema_evol_orc_nonvec_mapwork_part_all_complex.q,\ + schema_evol_orc_nonvec_mapwork_part_all_primitive.q,\ + schema_evol_orc_nonvec_mapwork_table.q,\ + schema_evol_orc_vec_mapwork_part.q,\ + schema_evol_orc_vec_mapwork_part_all_complex.q,\ + schema_evol_orc_vec_mapwork_part_all_primitive.q,\ + schema_evol_orc_vec_mapwork_table.q,\ + schema_evol_text_nonvec_mapwork_part.q,\ + schema_evol_text_nonvec_mapwork_part_all_complex.q,\ + schema_evol_text_nonvec_mapwork_part_all_primitive.q,\ + schema_evol_text_nonvec_mapwork_table.q,\ + schema_evol_text_vec_mapwork_part.q,\ + schema_evol_text_vec_mapwork_part_all_complex.q,\ + schema_evol_text_vec_mapwork_part_all_primitive.q,\ + schema_evol_text_vec_mapwork_table.q,\ + schema_evol_text_vecrow_mapwork_part.q,\ + schema_evol_text_vecrow_mapwork_part_all_complex.q,\ + schema_evol_text_vecrow_mapwork_part_all_primitive.q,\ + schema_evol_text_vecrow_mapwork_table.q encrypted.query.files=encryption_join_unencrypted_tbl.q,\ http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_part.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_part.q b/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_part.q index 768d77d..eca40e7 100644 --- a/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_part.q +++ b/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_part.q @@ -48,9 +48,9 @@ insert into table part_add_int_permute_select partition(part=1) (10, 6, 'new', 200); -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_permute_select order by insert_num; -select insert_num,part,a,b,c from part_add_int_permute_select order by insert_num; -select insert_num,part,c from part_add_int_permute_select order by insert_num; +select insert_num,part,a,b from part_add_int_permute_select; +select insert_num,part,a,b,c from part_add_int_permute_select; +select insert_num,part,c from part_add_int_permute_select; drop table part_add_int_permute_select; @@ -80,13 +80,13 @@ insert into table part_add_int_string_permute_select partition(part=1) (10, 6, 'new', 200, 'two hundred'); -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,part,a,b from part_add_int_string_permute_select order by insert_num; -select insert_num,part,a,b,c from part_add_int_string_permute_select order by insert_num; -select insert_num,part,a,b,c,d from part_add_int_string_permute_select order by insert_num; -select insert_num,part,a,c,d from part_add_int_string_permute_select order by insert_num; -select insert_num,part,a,d from part_add_int_string_permute_select order by insert_num; -select insert_num,part,c from part_add_int_string_permute_select order by insert_num; -select insert_num,part,d from part_add_int_string_permute_select order by insert_num; +select insert_num,part,a,b from part_add_int_string_permute_select; +select insert_num,part,a,b,c from part_add_int_string_permute_select; +select insert_num,part,a,b,c,d from part_add_int_string_permute_select; +select insert_num,part,a,c,d from part_add_int_string_permute_select; +select insert_num,part,a,d from part_add_int_string_permute_select; +select insert_num,part,c from part_add_int_string_permute_select; +select insert_num,part,d from part_add_int_string_permute_select; drop table part_add_int_string_permute_select; @@ -120,7 +120,7 @@ insert into table part_change_string_group_double partition(part=1) values (9, 17808.963785, 17808.963785, 17808.963785, 'new'), (10, 9250340.75 , 9250340.75 , 9250340.75 , 'new'); -select insert_num,part,c1,c2,c3,b from part_change_string_group_double order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_string_group_double; drop table part_change_string_group_double; @@ -153,7 +153,7 @@ insert into table part_change_date_group_string_group_timestamp partition(part=1 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'); -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_timestamp; drop table part_change_date_group_string_group_timestamp; @@ -180,7 +180,7 @@ insert into table part_change_date_group_string_group_date partition(part=2) (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'); -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_date_group_string_group_date; drop table part_change_date_group_string_group_date; @@ -201,7 +201,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_string parti (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_multi_ints_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, c4 STRING, b STRING) ; @@ -214,7 +214,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_string parti (9, '100', '5000', '5443', '0', 'new', 1), (10, '17', '90000', '754072151', '3289094', 'new', 1); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_string; drop table part_change_numeric_group_string_group_multi_ints_string; @@ -231,7 +231,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_char partiti (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_multi_ints_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), c4 CHAR(50), b STRING) ; @@ -244,7 +244,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_char partiti (9, '100', '5000', '5443', '0', 'new', 1), (10, '17', '90000', '754072151', '3289094', 'new', 1); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char; drop table part_change_numeric_group_string_group_multi_ints_char; @@ -260,7 +260,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_char_trunc p (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_multi_ints_char_trunc replace columns (insert_num int, c1 CHAR(5), c2 CHAR(5), c3 CHAR(5), c4 CHAR(5), b STRING) ; @@ -273,7 +273,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_char_trunc p (9, '100', '5000', '5443', '0', 'new', 1), (10, '17', '90000', '754072151', '3289094', 'new', 1); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_char_trunc; drop table part_change_numeric_group_string_group_multi_ints_char_trunc; @@ -290,7 +290,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_varchar part (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_multi_ints_varchar replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), c4 VARCHAR(50), b STRING) ; @@ -303,7 +303,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_varchar part (9, '100', '5000', '5443', '0', 'new', 1), (10, '17', '90000', '754072151', '3289094', 'new', 1); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar; drop table part_change_numeric_group_string_group_multi_ints_varchar; @@ -319,7 +319,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_varchar_trun (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_multi_ints_varchar_trunc replace columns (insert_num int, c1 VARCHAR(5), c2 VARCHAR(5), c3 VARCHAR(5), c4 VARCHAR(5), b STRING) ; @@ -332,7 +332,7 @@ insert into table part_change_numeric_group_string_group_multi_ints_varchar_trun (9, '100', '5000', '5443', '0', 'new', 1), (10, '17', '90000', '754072151', '3289094', 'new', 1); -select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_numeric_group_string_group_multi_ints_varchar_trunc; drop table part_change_numeric_group_string_group_multi_ints_varchar_trunc; @@ -348,7 +348,7 @@ insert into table part_change_numeric_group_string_group_floating_string partiti (3, - 832222222, 255, 4957,'original'), (4, 847492223, 0, 20435, 'original'); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_floating_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, b STRING) ; @@ -361,7 +361,7 @@ insert into table part_change_numeric_group_string_group_floating_string partiti (9, '100', '5000', '5443', 'new', 1), (10, '17', '90000', '754072151', 'new', 1); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_string; drop table part_change_numeric_group_string_group_floating_string; @@ -377,7 +377,7 @@ insert into table part_change_numeric_group_string_group_floating_char partition (3, 9000000000, -255, 4957,'original'), (4, -999999999999, 0, 20435, 'original'); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_floating_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), b STRING) ; @@ -390,7 +390,7 @@ insert into table part_change_numeric_group_string_group_floating_char partition (9, '100', '5000', '5443', 'new', 1), (10, '17', '90000', '754072151', 'new', 1); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char; drop table part_change_numeric_group_string_group_floating_char; @@ -406,7 +406,7 @@ insert into table part_change_numeric_group_string_group_floating_char_trunc par (3, 832222222, -255, 4957, 'original'), (4, 847492223, 0, 20435, 'original'); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_floating_char_trunc replace columns (insert_num int, c1 CHAR(7), c2 CHAR(7), c3 CHAR(7), b STRING) ; @@ -419,7 +419,7 @@ insert into table part_change_numeric_group_string_group_floating_char_trunc par (9, '100', '5000', '5443', 'new', 1), (10, '17', '90000', '754072151', 'new', 1); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_char_trunc; drop table part_change_numeric_group_string_group_floating_char_trunc; @@ -435,7 +435,7 @@ insert into table part_change_numeric_group_string_group_floating_varchar partit (3, 9000000000, -255, 4957, 'original'), (4, -999999999999, 0, 20435, 'original'); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_floating_varchar replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), b STRING) ; @@ -448,7 +448,7 @@ insert into table part_change_numeric_group_string_group_floating_varchar partit (9, '100', '5000', '5443', 'new', 1), (10, '17', '90000', '754072151', 'new', 1); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar; drop table part_change_numeric_group_string_group_floating_varchar; @@ -464,7 +464,7 @@ insert into table part_change_numeric_group_string_group_floating_varchar_trunc (3, 9000000000, -255, 4957, 'original'), (4, -999999999999, 0, 20435, 'original'); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_numeric_group_string_group_floating_varchar_trunc replace columns (insert_num int, c1 VARCHAR(7), c2 VARCHAR(7), c3 VARCHAR(7), b STRING) ; @@ -477,7 +477,7 @@ insert into table part_change_numeric_group_string_group_floating_varchar_trunc (9, '100', '5000', '5443', 'new', 1), (10, '17', '90000', '754072151', 'new', 1); -select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_numeric_group_string_group_floating_varchar_trunc; drop table part_change_numeric_group_string_group_floating_varchar_trunc; @@ -497,7 +497,7 @@ insert into table part_change_string_group_string_group_string partition(part=1) (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'blank pads ', 'original'); -select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_string_group_string_group_string replace columns (insert_num int, c1 CHAR(50), c2 CHAR(9), c3 VARCHAR(50), c4 CHAR(9), b STRING) ; @@ -510,7 +510,7 @@ insert into table part_change_string_group_string_group_string partition(part) (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new', 1), (10, 'bottom ', 'bottom ', 'bottom ', 'bottom ', 'new', 1); -select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_string_group_string_group_string; drop table part_change_string_group_string_group_string; @@ -527,7 +527,7 @@ insert into table part_change_string_group_string_group_char partition(part=1) (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'original'); -select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_string_group_string_group_char replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(9), c3 STRING, b STRING) ; @@ -540,7 +540,7 @@ insert into table part_change_string_group_string_group_char partition(part) (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new', 1), (10, 'bottom ', 'bottom ', 'bottom ', 'new', 1); -select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_char; drop table part_change_string_group_string_group_char; @@ -557,7 +557,7 @@ insert into table part_change_string_group_string_group_varchar partition(part=1 (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'original'); -select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_string_group_string_group_varchar replace columns (insert_num int, c1 CHAR(50), c2 CHAR(9), c3 STRING, b STRING) ; @@ -570,7 +570,7 @@ insert into table part_change_string_group_string_group_varchar partition(part) (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new', 1), (10, 'bottom ', 'bottom ', 'bottom ', 'new', 1); -select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_string_group_string_group_varchar; drop table part_change_string_group_string_group_varchar; @@ -591,7 +591,7 @@ insert into table part_change_lower_to_higher_numeric_group_tinyint partition(pa (3, -255, -255, -255, -255, -255, -255, 'original'), (4, 100, 100, 100, 100, 100, 100, 'original'); -select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING) ; @@ -604,7 +604,7 @@ insert into table part_change_lower_to_higher_numeric_group_tinyint partition(pa (9, '100', '5000', '5443', '22', '2', '-2', 'new', 1), (10, '17', '90000', '754072151', '95', '20', '18', 'new', 1); -select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,c6,b from part_change_lower_to_higher_numeric_group_tinyint; drop table part_change_lower_to_higher_numeric_group_tinyint; @@ -620,7 +620,7 @@ insert into table part_change_lower_to_higher_numeric_group_smallint partition(p (3, -5000, -5000, -5000, -5000, -5000, 'original'), (4, 100, 100, 100, 100, 100, 'original'); -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING) ; @@ -633,7 +633,7 @@ insert into table part_change_lower_to_higher_numeric_group_smallint partition(p (9, '100', '5000', '5443', '22', '2', 'new', 1), (10, '17', '90000', '754072151', '95', '20', 'new', 1); -select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint order by insert_num; +select insert_num,part,c1,c2,c3,c4,c5,b from part_change_lower_to_higher_numeric_group_smallint; drop table part_change_lower_to_higher_numeric_group_smallint; @@ -650,7 +650,7 @@ insert into table part_change_lower_to_higher_numeric_group_int partition(part=1 (3, -5000, -5000, -5000, -5000, 'original'), (4, 52927714, 52927714, 52927714, 52927714, 'original'); -select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE, b STRING); @@ -663,7 +663,7 @@ insert into table part_change_lower_to_higher_numeric_group_int partition(part) (9, '100', '5000', '5443', '22', 'new', 1), (10, '17', '90000', '754072151', '95', 'new', 1); -select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int order by insert_num; +select insert_num,part,c1,c2,c3,c4,b from part_change_lower_to_higher_numeric_group_int; drop table part_change_lower_to_higher_numeric_group_int; @@ -679,7 +679,7 @@ insert into table part_change_lower_to_higher_numeric_group_bigint partition(par (3, -5000, -5000, -5000, 'original'), (4, 52927714, 52927714, 52927714, 'original'); -select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING) ; @@ -692,7 +692,7 @@ insert into table part_change_lower_to_higher_numeric_group_bigint partition(par (9, '100', '5000', '5443', 'new', 1), (10, '17', '90000', '754072151', 'new', 1); -select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint order by insert_num; +select insert_num,part,c1,c2,c3,b from part_change_lower_to_higher_numeric_group_bigint; drop table part_change_lower_to_higher_numeric_group_bigint; @@ -708,7 +708,7 @@ insert into table part_change_lower_to_higher_numeric_group_decimal partition(pa (3, -5000, -5000, 'original'), (4, 52927714, 52927714, 'original'); -select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num; +select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) ; @@ -721,7 +721,7 @@ insert into table part_change_lower_to_higher_numeric_group_decimal partition(pa (9, '10.0', '0.100', 'new', 1), (10, '1.7', '17.8888', 'new', 1); -select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num; +select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal; drop table part_change_lower_to_higher_numeric_group_decimal; @@ -737,7 +737,7 @@ insert into table part_change_lower_to_higher_numeric_group_float partition(part (3, -5000, 'original'), (4, 52927714, 'original'); -select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num; +select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float; -- Table-Non-Cascade CHANGE COLUMNS ... alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) ; @@ -750,7 +750,7 @@ insert into table part_change_lower_to_higher_numeric_group_float partition(part (9, '100', 'new', 1), (10, '17', 'new', 1); -select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num; +select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float; drop table part_change_lower_to_higher_numeric_group_float; @@ -856,4 +856,4 @@ select insert_num,part,a,b,c,d from partitioned_delete_2; DROP TABLE partitioned_update_1; DROP TABLE partitioned_delete_1; -DROP TABLE partitioned_delete_2; \ No newline at end of file +DROP TABLE partitioned_delete_2; http://git-wip-us.apache.org/repos/asf/hive/blob/9a798130/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_table.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_table.q b/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_table.q index 09f4f22..1049aa5 100644 --- a/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_table.q +++ b/ql/src/test/queries/clientpositive/schema_evol_orc_acid_mapwork_table.q @@ -47,9 +47,9 @@ insert into table table_add_int_permute_select (10, 6, 'new', 200); -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,a,b from table_add_int_permute_select order by insert_num; -select insert_num,a,b,c from table_add_int_permute_select order by insert_num; -select insert_num,c from table_add_int_permute_select order by insert_num; +select insert_num,a,b from table_add_int_permute_select; +select insert_num,a,b,c from table_add_int_permute_select; +select insert_num,c from table_add_int_permute_select; drop table table_add_int_permute_select; @@ -79,13 +79,13 @@ insert into table table_add_int_string_permute_select (10, 6, 'new', 200, 'two hundred'); -- SELECT permutation columns to make sure NULL defaulting works right -select insert_num,a,b from table_add_int_string_permute_select order by insert_num; -select insert_num,a,b,c from table_add_int_string_permute_select order by insert_num; -select insert_num,a,b,c,d from table_add_int_string_permute_select order by insert_num; -select insert_num,a,c,d from table_add_int_string_permute_select order by insert_num; -select insert_num,a,d from table_add_int_string_permute_select order by insert_num; -select insert_num,c from table_add_int_string_permute_select order by insert_num; -select insert_num,d from table_add_int_string_permute_select order by insert_num; +select insert_num,a,b from table_add_int_string_permute_select; +select insert_num,a,b,c from table_add_int_string_permute_select; +select insert_num,a,b,c,d from table_add_int_string_permute_select; +select insert_num,a,c,d from table_add_int_string_permute_select; +select insert_num,a,d from table_add_int_string_permute_select; +select insert_num,c from table_add_int_string_permute_select; +select insert_num,d from table_add_int_string_permute_select; drop table table_add_int_string_permute_select; @@ -119,7 +119,7 @@ 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'); -select insert_num,c1,c2,c3,b from table_change_string_group_double order by insert_num; +select insert_num,c1,c2,c3,b from table_change_string_group_double; drop table table_change_string_group_double; @@ -149,7 +149,7 @@ 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'); -select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp order by insert_num; +select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_timestamp; drop table table_change_date_group_string_group_timestamp; @@ -176,7 +176,7 @@ insert into table table_change_date_group_string_group_date (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'); -select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date order by insert_num; +select insert_num,c1,c2,c3,c4,c5,b from table_change_date_group_string_group_date; drop table table_change_date_group_string_group_date; @@ -197,7 +197,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_string (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_multi_ints_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, c4 STRING, b STRING) ; @@ -210,7 +210,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_string (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_string; drop table table_change_numeric_group_string_group_multi_ints_string; @@ -227,7 +227,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_char (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_multi_ints_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), c4 CHAR(50), b STRING) ; @@ -240,7 +240,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_char (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char; drop table table_change_numeric_group_string_group_multi_ints_char; @@ -256,7 +256,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_char_trunc (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_multi_ints_char_trunc replace columns (insert_num int, c1 CHAR(5), c2 CHAR(5), c3 CHAR(5), c4 CHAR(5), b STRING) ; @@ -269,7 +269,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_char_trunc (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_char_trunc; drop table table_change_numeric_group_string_group_multi_ints_char_trunc; @@ -286,7 +286,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_varchar (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_multi_ints_varchar replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), c4 VARCHAR(50), b STRING) ; @@ -299,7 +299,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_varchar (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar; drop table table_change_numeric_group_string_group_multi_ints_varchar; @@ -315,7 +315,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_varchar_tru (3, -255, 4957, 832222222, 9000000000, 'original'), (4, 0, 20435, 847492223, -999999999999, 'original'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_multi_ints_varchar_trunc replace columns (insert_num int, c1 VARCHAR(5), c2 VARCHAR(5), c3 VARCHAR(5), c4 VARCHAR(5), b STRING) ; @@ -328,7 +328,7 @@ insert into table table_change_numeric_group_string_group_multi_ints_varchar_tru (9, '100', '5000', '5443', '0', 'new'), (10, '17', '90000', '754072151', '3289094', 'new'); -select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_numeric_group_string_group_multi_ints_varchar_trunc; drop table table_change_numeric_group_string_group_multi_ints_varchar_trunc; @@ -344,7 +344,7 @@ insert into table table_change_numeric_group_string_group_floating_string (3, - 832222222, 255, 4957,'original'), (4, 847492223, 0, 20435, 'original'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, b STRING) ; @@ -357,7 +357,7 @@ insert into table table_change_numeric_group_string_group_floating_string (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_string; drop table table_change_numeric_group_string_group_floating_string; @@ -373,7 +373,7 @@ insert into table table_change_numeric_group_string_group_floating_char (3, 9000000000, -255, 4957,'original'), (4, -999999999999, 0, 20435, 'original'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), b STRING) ; @@ -386,7 +386,7 @@ insert into table table_change_numeric_group_string_group_floating_char (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char; drop table table_change_numeric_group_string_group_floating_char; @@ -402,7 +402,7 @@ insert into table table_change_numeric_group_string_group_floating_char_trunc (3, 832222222, -255, 4957, 'original'), (4, 847492223, 0, 20435, 'original'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_char_trunc replace columns (insert_num int, c1 CHAR(7), c2 CHAR(7), c3 CHAR(7), b STRING) ; @@ -415,7 +415,7 @@ insert into table table_change_numeric_group_string_group_floating_char_trunc (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_char_trunc; drop table table_change_numeric_group_string_group_floating_char_trunc; @@ -431,7 +431,7 @@ insert into table table_change_numeric_group_string_group_floating_varchar (3, 9000000000, -255, 4957, 'original'), (4, -999999999999, 0, 20435, 'original'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_varchar replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(50), c3 VARCHAR(50), b STRING) ; @@ -444,7 +444,7 @@ insert into table table_change_numeric_group_string_group_floating_varchar (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar; drop table table_change_numeric_group_string_group_floating_varchar; @@ -460,7 +460,7 @@ insert into table table_change_numeric_group_string_group_floating_varchar_trunc (3, 9000000000, -255, 4957, 'original'), (4, -999999999999, 0, 20435, 'original'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_varchar_trunc replace columns (insert_num int, c1 VARCHAR(7), c2 VARCHAR(7), c3 VARCHAR(7), b STRING) ; @@ -473,7 +473,7 @@ insert into table table_change_numeric_group_string_group_floating_varchar_trunc (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new'); -select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc order by insert_num; +select insert_num,c1,c2,c3,b from table_change_numeric_group_string_group_floating_varchar_trunc; drop table table_change_numeric_group_string_group_floating_varchar_trunc; @@ -493,7 +493,7 @@ insert into table table_change_string_group_string_group_string (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'blank pads ', 'original'); -select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_string_group_string_group_string replace columns (insert_num int, c1 CHAR(50), c2 CHAR(9), c3 VARCHAR(50), c4 CHAR(9), b STRING) ; @@ -506,7 +506,7 @@ insert into table table_change_string_group_string_group_string (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'bottom ', 'new'); -select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_string_group_string_group_string; drop table table_change_string_group_string_group_string; @@ -523,7 +523,7 @@ insert into table table_change_string_group_string_group_char (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'original'); -select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num; +select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_string_group_string_group_char replace columns (insert_num int, c1 VARCHAR(50), c2 VARCHAR(9), c3 STRING, b STRING) ; @@ -536,7 +536,7 @@ insert into table table_change_string_group_string_group_char (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'new'); -select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char order by insert_num; +select insert_num,c1,c2,c3,b from table_change_string_group_string_group_char; drop table table_change_string_group_string_group_char; @@ -553,7 +553,7 @@ insert into table table_change_string_group_string_group_varchar (3, 'dynamic reptile', 'dynamic reptile', 'dynamic reptile', 'original'), (4, 'blank pads ', 'blank pads ', 'blank pads ', 'original'); -select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num; +select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_string_group_string_group_varchar replace columns (insert_num int, c1 CHAR(50), c2 CHAR(9), c3 STRING, b STRING) ; @@ -566,7 +566,7 @@ insert into table table_change_string_group_string_group_varchar (9, 'hangar paralysed companion ', 'hangar paralysed companion ', 'hangar paralysed companion ', 'new'), (10, 'bottom ', 'bottom ', 'bottom ', 'new'); -select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar order by insert_num; +select insert_num,c1,c2,c3,b from table_change_string_group_string_group_varchar; drop table table_change_string_group_string_group_varchar; @@ -587,7 +587,7 @@ insert into table table_change_lower_to_higher_numeric_group_tinyint (3, -255, -255, -255, -255, -255, -255, 'original'), (4, 100, 100, 100, 100, 100, 100, 'original'); -select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num; +select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING); @@ -600,7 +600,7 @@ insert into table table_change_lower_to_higher_numeric_group_tinyint (9, '100', '5000', '5443', '22', '2', '-2', 'new'), (10, '17', '90000', '754072151', '95', '20', '18', 'new'); -select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint order by insert_num; +select insert_num,c1,c2,c3,c4,c5,c6,b from table_change_lower_to_higher_numeric_group_tinyint; drop table table_change_lower_to_higher_numeric_group_tinyint; @@ -616,7 +616,7 @@ insert into table table_change_lower_to_higher_numeric_group_smallint (3, -5000, -5000, -5000, -5000, -5000, 'original'), (4, 100, 100, 100, 100, 100, 'original'); -select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num; +select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING) ; @@ -629,7 +629,7 @@ insert into table table_change_lower_to_higher_numeric_group_smallint (9, '100', '5000', '5443', '22', '2', 'new'), (10, '17', '90000', '754072151', '95', '20', 'new'); -select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint order by insert_num; +select insert_num,c1,c2,c3,c4,c5,b from table_change_lower_to_higher_numeric_group_smallint; drop table table_change_lower_to_higher_numeric_group_smallint; @@ -646,7 +646,7 @@ insert into table table_change_lower_to_higher_numeric_group_int (3, -5000, -5000, -5000, -5000, 'original'), (4, 52927714, 52927714, 52927714, 52927714, 'original'); -select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE, b STRING) ; @@ -659,7 +659,7 @@ insert into table table_change_lower_to_higher_numeric_group_int (9, '100', '5000', '5443', '22', 'new'), (10, '17', '90000', '754072151', '95', 'new'); -select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int order by insert_num; +select insert_num,c1,c2,c3,c4,b from table_change_lower_to_higher_numeric_group_int; drop table table_change_lower_to_higher_numeric_group_int; @@ -675,7 +675,7 @@ insert into table table_change_lower_to_higher_numeric_group_bigint (3, -5000, -5000, -5000, 'original'), (4, 52927714, 52927714, 52927714, 'original'); -select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num; +select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING) ; @@ -688,7 +688,7 @@ insert into table table_change_lower_to_higher_numeric_group_bigint (9, '100', '5000', '5443', 'new'), (10, '17', '90000', '754072151', 'new'); -select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint order by insert_num; +select insert_num,c1,c2,c3,b from table_change_lower_to_higher_numeric_group_bigint; drop table table_change_lower_to_higher_numeric_group_bigint; @@ -704,7 +704,7 @@ insert into table table_change_lower_to_higher_numeric_group_decimal (3, -5000, -5000, 'original'), (4, 52927714, 52927714, 'original'); -select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num; +select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) ; @@ -717,7 +717,7 @@ insert into table table_change_lower_to_higher_numeric_group_decimal (9, '10.0', '0.100', 'new'), (10, '1.7', '17.8888', 'new'); -select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num; +select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal; drop table table_change_lower_to_higher_numeric_group_decimal; @@ -734,7 +734,7 @@ insert into table table_change_lower_to_higher_numeric_group_float (3, -5000, 'original'), (4, 52927714, 'original'); -select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num; +select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float; -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) ; @@ -747,7 +747,7 @@ insert into table table_change_lower_to_higher_numeric_group_float (9, '100', 'new'), (10, '17', 'new'); -select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num; +select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float; drop table table_change_lower_to_higher_numeric_group_float; @@ -853,4 +853,4 @@ select a,b,c,d from table7; DROP TABLE table5; DROP TABLE table6; -DROP TABLE table7; \ No newline at end of file +DROP TABLE table7;
