Repository: hive Updated Branches: refs/heads/master 2c8e67942 -> e041c9ece
HIVE-20524: Schema Evolution checking is broken in going from Hive version 2 to version 3 for ALTER TABLE VARCHAR to DECIMAL (Matt McCline, reviewed by Jason Dere) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/e041c9ec Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/e041c9ec Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/e041c9ec Branch: refs/heads/master Commit: e041c9ecec9d546cb790d2cf8cf3ea10eeeab202 Parents: 2c8e679 Author: Matt McCline <mmccl...@hortonworks.com> Authored: Sat Sep 15 15:06:19 2018 -0500 Committer: Matt McCline <mmccl...@hortonworks.com> Committed: Sat Sep 15 15:06:19 2018 -0500 ---------------------------------------------------------------------- .../clientpositive/schema_evol_undecorated.q | 14 +++++ .../llap/schema_evol_undecorated.q.out | 64 ++++++++++++++++++++ 2 files changed, 78 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/e041c9ec/ql/src/test/queries/clientpositive/schema_evol_undecorated.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/schema_evol_undecorated.q b/ql/src/test/queries/clientpositive/schema_evol_undecorated.q new file mode 100644 index 0000000..1fe5c08 --- /dev/null +++ b/ql/src/test/queries/clientpositive/schema_evol_undecorated.q @@ -0,0 +1,14 @@ + +set hive.metastore.disallow.incompatible.col.type.changes=true; + +create external table new_char_decimal (c1 char(20)); +alter table new_char_decimal change c1 c1 decimal(31,0); + +create external table new_varchar_decimal (c1 varchar(25)); +alter table new_varchar_decimal change c1 c1 decimal(12,5); + +create external table new_char_double (c1 char(20)); +alter table new_char_double change c1 c1 double; + +create external table new_varchar_double (c1 varchar(25)); +alter table new_varchar_double change c1 c1 double; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/e041c9ec/ql/src/test/results/clientpositive/llap/schema_evol_undecorated.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_undecorated.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_undecorated.q.out new file mode 100644 index 0000000..2cbdb4c --- /dev/null +++ b/ql/src/test/results/clientpositive/llap/schema_evol_undecorated.q.out @@ -0,0 +1,64 @@ +PREHOOK: query: create external table new_char_decimal (c1 char(20)) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@new_char_decimal +POSTHOOK: query: create external table new_char_decimal (c1 char(20)) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@new_char_decimal +PREHOOK: query: alter table new_char_decimal change c1 c1 decimal(31,0) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@new_char_decimal +PREHOOK: Output: default@new_char_decimal +POSTHOOK: query: alter table new_char_decimal change c1 c1 decimal(31,0) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@new_char_decimal +POSTHOOK: Output: default@new_char_decimal +PREHOOK: query: create external table new_varchar_decimal (c1 varchar(25)) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@new_varchar_decimal +POSTHOOK: query: create external table new_varchar_decimal (c1 varchar(25)) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@new_varchar_decimal +PREHOOK: query: alter table new_varchar_decimal change c1 c1 decimal(12,5) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@new_varchar_decimal +PREHOOK: Output: default@new_varchar_decimal +POSTHOOK: query: alter table new_varchar_decimal change c1 c1 decimal(12,5) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@new_varchar_decimal +POSTHOOK: Output: default@new_varchar_decimal +PREHOOK: query: create external table new_char_double (c1 char(20)) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@new_char_double +POSTHOOK: query: create external table new_char_double (c1 char(20)) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@new_char_double +PREHOOK: query: alter table new_char_double change c1 c1 double +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@new_char_double +PREHOOK: Output: default@new_char_double +POSTHOOK: query: alter table new_char_double change c1 c1 double +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@new_char_double +POSTHOOK: Output: default@new_char_double +PREHOOK: query: create external table new_varchar_double (c1 varchar(25)) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@new_varchar_double +POSTHOOK: query: create external table new_varchar_double (c1 varchar(25)) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@new_varchar_double +PREHOOK: query: alter table new_varchar_double change c1 c1 double +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@new_varchar_double +PREHOOK: Output: default@new_varchar_double +POSTHOOK: query: alter table new_varchar_double change c1 c1 double +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@new_varchar_double +POSTHOOK: Output: default@new_varchar_double