Repository: hive Updated Branches: refs/heads/master bad8525cc -> b36f6a3a2
http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_fk_tbl2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_fk_tbl2.q b/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_fk_tbl2.q new file mode 100644 index 0000000..c18247b --- /dev/null +++ b/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_fk_tbl2.q @@ -0,0 +1,3 @@ +CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate); +CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely); +alter table table2 add constraint fk1 foreign key (b) references table3(a) disable novalidate; http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_pk_col.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_pk_col.q b/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_pk_col.q new file mode 100644 index 0000000..8005abe --- /dev/null +++ b/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_pk_col.q @@ -0,0 +1,2 @@ +CREATE TABLE table1 (a STRING, b STRING); +alter table table1 add constraint pk1 primary key (c) disable novalidate; http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_pk_tbl.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_pk_tbl.q b/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_pk_tbl.q new file mode 100644 index 0000000..b6850fa --- /dev/null +++ b/ql/src/test/queries/clientnegative/alter_table_constraint_invalid_pk_tbl.q @@ -0,0 +1,3 @@ +CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate); +CREATE TABLE table2 (a STRING, b STRING); +alter table table3 add constraint pk3 primary key (a) disable novalidate rely; http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/queries/clientpositive/create_with_constraints.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/create_with_constraints.q b/ql/src/test/queries/clientpositive/create_with_constraints.q index 7aabf74..10cb1c9 100644 --- a/ql/src/test/queries/clientpositive/create_with_constraints.q +++ b/ql/src/test/queries/clientpositive/create_with_constraints.q @@ -1,17 +1,17 @@ CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate); CREATE TABLE table2 (a STRING, b STRING, constraint pk1 primary key (a) disable novalidate); -CREATE TABLE table3 (x string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE); -CREATE TABLE table4 (x string, y string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk2 FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE, +CREATE TABLE table3 (x string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE); +CREATE TABLE table4 (x string, y string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk2 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE, CONSTRAINT fk3 FOREIGN KEY (y) REFERENCES table2(a) DISABLE NOVALIDATE); -CREATE TABLE table5 (x string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE); -CREATE TABLE table6 (x string, y string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE, +CREATE TABLE table5 (x string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE); +CREATE TABLE table6 (x string, y string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE, CONSTRAINT fk4 FOREIGN KEY (y) REFERENCES table1(a) DISABLE NOVALIDATE); CREATE TABLE table7 (a STRING, b STRING, primary key (a) disable novalidate rely); CREATE TABLE table8 (a STRING, b STRING, constraint pk8 primary key (a) disable novalidate norely); CREATE TABLE table9 (a STRING, b STRING, primary key (a, b) disable novalidate rely); CREATE TABLE table10 (a STRING, b STRING, constraint pk10 primary key (a) disable novalidate norely, foreign key (a, b) references table9(a, b) disable novalidate); -CREATE TABLE table11 (a STRING, b STRING, c STRING, constraint pk11 primary key (a) disable novalidate rely, foreign key (a, b) references table9(a, b) disable novalidate, -foreign key (c) references table4(x) disable novalidate); +CREATE TABLE table11 (a STRING, b STRING, c STRING, constraint pk11 primary key (a) disable novalidate rely, constraint fk11_1 foreign key (a, b) references table9(a, b) disable novalidate, +constraint fk11_2 foreign key (c) references table4(x) disable novalidate); DESCRIBE EXTENDED table1; DESCRIBE EXTENDED table2; @@ -37,7 +37,6 @@ DESCRIBE FORMATTED table9; DESCRIBE FORMATTED table10; DESCRIBE FORMATTED table11; - ALTER TABLE table2 DROP CONSTRAINT pk1; ALTER TABLE table3 DROP CONSTRAINT fk1; ALTER TABLE table6 DROP CONSTRAINT fk4; @@ -50,6 +49,14 @@ DESCRIBE FORMATTED table2; DESCRIBE FORMATTED table3; DESCRIBE FORMATTED table6; +ALTER TABLE table2 ADD CONSTRAINT pkt2 primary key (a) disable novalidate; +ALTER TABLE table3 ADD CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE RELY; +ALTER TABLE table6 ADD CONSTRAINT fk4 FOREIGN KEY (y) REFERENCES table1(a) DISABLE NOVALIDATE; + +DESCRIBE FORMATTED table2; +DESCRIBE FORMATTED table3; +DESCRIBE FORMATTED table6; + CREATE DATABASE dbconstraint; USE dbconstraint; CREATE TABLE table2 (a STRING, b STRING, constraint pk1 primary key (a) disable novalidate); @@ -62,3 +69,8 @@ ALTER TABLE dbconstraint.table2 DROP CONSTRAINT pk1; DESCRIBE EXTENDED dbconstraint.table2; DESCRIBE FORMATTED dbconstraint.table2; + +ALTER TABLE dbconstraint.table2 ADD CONSTRAINT pk1 primary key (a) disable novalidate; +DESCRIBE FORMATTED dbconstraint.table2; +ALTER TABLE dbconstraint.table2 ADD CONSTRAINT fkx FOREIGN KEY (b) REFERENCES table1(a) DISABLE NOVALIDATE; +DESCRIBE FORMATTED dbconstraint.table2; http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/results/clientnegative/alter_table_constraint_duplicate_pk.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/alter_table_constraint_duplicate_pk.q.out b/ql/src/test/results/clientnegative/alter_table_constraint_duplicate_pk.q.out new file mode 100644 index 0000000..d1bb637 --- /dev/null +++ b/ql/src/test/results/clientnegative/alter_table_constraint_duplicate_pk.q.out @@ -0,0 +1,11 @@ +PREHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table1 +POSTHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table1 +PREHOOK: query: alter table table1 add constraint pk4 primary key (b) disable novalidate rely +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message: Primary key already exists for: default.table1) http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_col1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_col1.q.out b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_col1.q.out new file mode 100644 index 0000000..2cd85c4 --- /dev/null +++ b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_col1.q.out @@ -0,0 +1,19 @@ +PREHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table1 +POSTHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table1 +PREHOOK: query: CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table2 +POSTHOOK: query: CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table2 +PREHOOK: query: alter table table2 add constraint fk1 foreign key (c) references table1(a) disable novalidate +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:Child column not found: c) http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_col2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_col2.q.out b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_col2.q.out new file mode 100644 index 0000000..86c38c1 --- /dev/null +++ b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_col2.q.out @@ -0,0 +1,19 @@ +PREHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table1 +POSTHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table1 +PREHOOK: query: CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table2 +POSTHOOK: query: CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table2 +PREHOOK: query: alter table table2 add constraint fk1 foreign key (b) references table1(c) disable novalidate +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:Parent column not found: c) http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_tbl1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_tbl1.q.out b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_tbl1.q.out new file mode 100644 index 0000000..16edd44 --- /dev/null +++ b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_tbl1.q.out @@ -0,0 +1,19 @@ +PREHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table1 +POSTHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table1 +PREHOOK: query: CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table2 +POSTHOOK: query: CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table2 +PREHOOK: query: alter table table3 add constraint fk1 foreign key (c) references table1(a) disable novalidate +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:Child table not found: table3) http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_tbl2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_tbl2.q.out b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_tbl2.q.out new file mode 100644 index 0000000..31dfcd1 --- /dev/null +++ b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_fk_tbl2.q.out @@ -0,0 +1,19 @@ +PREHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table1 +POSTHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table1 +PREHOOK: query: CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table2 +POSTHOOK: query: CREATE TABLE table2 (a STRING, b STRING, primary key (a) disable novalidate rely) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table2 +PREHOOK: query: alter table table2 add constraint fk1 foreign key (b) references table3(a) disable novalidate +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:Parent table not found: table3) http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_pk_col.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_pk_col.q.out b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_pk_col.q.out new file mode 100644 index 0000000..71689f7 --- /dev/null +++ b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_pk_col.q.out @@ -0,0 +1,11 @@ +PREHOOK: query: CREATE TABLE table1 (a STRING, b STRING) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table1 +POSTHOOK: query: CREATE TABLE table1 (a STRING, b STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table1 +PREHOOK: query: alter table table1 add constraint pk1 primary key (c) disable novalidate +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:Parent column not found: c) http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_pk_tbl.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientnegative/alter_table_constraint_invalid_pk_tbl.q.out b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_pk_tbl.q.out new file mode 100644 index 0000000..0207d8c --- /dev/null +++ b/ql/src/test/results/clientnegative/alter_table_constraint_invalid_pk_tbl.q.out @@ -0,0 +1,19 @@ +PREHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table1 +POSTHOOK: query: CREATE TABLE table1 (a STRING, b STRING, primary key (a) disable novalidate) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table1 +PREHOOK: query: CREATE TABLE table2 (a STRING, b STRING) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@table2 +POSTHOOK: query: CREATE TABLE table2 (a STRING, b STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@table2 +PREHOOK: query: alter table table3 add constraint pk3 primary key (a) disable novalidate rely +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:Parent table not found: table3) http://git-wip-us.apache.org/repos/asf/hive/blob/b36f6a3a/ql/src/test/results/clientpositive/create_with_constraints.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_with_constraints.q.out b/ql/src/test/results/clientpositive/create_with_constraints.q.out index 34dac30..b040e43 100644 --- a/ql/src/test/results/clientpositive/create_with_constraints.q.out +++ b/ql/src/test/results/clientpositive/create_with_constraints.q.out @@ -14,38 +14,38 @@ POSTHOOK: query: CREATE TABLE table2 (a STRING, b STRING, constraint pk1 primary POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table2 -PREHOOK: query: CREATE TABLE table3 (x string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE) +PREHOOK: query: CREATE TABLE table3 (x string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table3 -POSTHOOK: query: CREATE TABLE table3 (x string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE) +POSTHOOK: query: CREATE TABLE table3 (x string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table3 -PREHOOK: query: CREATE TABLE table4 (x string, y string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk2 FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE, +PREHOOK: query: CREATE TABLE table4 (x string, y string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk2 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE, CONSTRAINT fk3 FOREIGN KEY (y) REFERENCES table2(a) DISABLE NOVALIDATE) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table4 -POSTHOOK: query: CREATE TABLE table4 (x string, y string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk2 FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE, +POSTHOOK: query: CREATE TABLE table4 (x string, y string, PRIMARY KEY (x) disable novalidate, CONSTRAINT fk2 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE, CONSTRAINT fk3 FOREIGN KEY (y) REFERENCES table2(a) DISABLE NOVALIDATE) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table4 -PREHOOK: query: CREATE TABLE table5 (x string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE) +PREHOOK: query: CREATE TABLE table5 (x string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table5 -POSTHOOK: query: CREATE TABLE table5 (x string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE) +POSTHOOK: query: CREATE TABLE table5 (x string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table5 -PREHOOK: query: CREATE TABLE table6 (x string, y string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE, +PREHOOK: query: CREATE TABLE table6 (x string, y string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE, CONSTRAINT fk4 FOREIGN KEY (y) REFERENCES table1(a) DISABLE NOVALIDATE) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table6 -POSTHOOK: query: CREATE TABLE table6 (x string, y string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(b) DISABLE NOVALIDATE, +POSTHOOK: query: CREATE TABLE table6 (x string, y string, PRIMARY KEY (x) disable novalidate, FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE, CONSTRAINT fk4 FOREIGN KEY (y) REFERENCES table1(a) DISABLE NOVALIDATE) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -82,13 +82,13 @@ POSTHOOK: query: CREATE TABLE table10 (a STRING, b STRING, constraint pk10 prima POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table10 -PREHOOK: query: CREATE TABLE table11 (a STRING, b STRING, c STRING, constraint pk11 primary key (a) disable novalidate rely, foreign key (a, b) references table9(a, b) disable novalidate, -foreign key (c) references table4(x) disable novalidate) +PREHOOK: query: CREATE TABLE table11 (a STRING, b STRING, c STRING, constraint pk11 primary key (a) disable novalidate rely, constraint fk11_1 foreign key (a, b) references table9(a, b) disable novalidate, +constraint fk11_2 foreign key (c) references table4(x) disable novalidate) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table11 -POSTHOOK: query: CREATE TABLE table11 (a STRING, b STRING, c STRING, constraint pk11 primary key (a) disable novalidate rely, foreign key (a, b) references table9(a, b) disable novalidate, -foreign key (c) references table4(x) disable novalidate) +POSTHOOK: query: CREATE TABLE table11 (a STRING, b STRING, c STRING, constraint pk11 primary key (a) disable novalidate rely, constraint fk11_1 foreign key (a, b) references table9(a, b) disable novalidate, +constraint fk11_2 foreign key (c) references table4(x) disable novalidate) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table11 @@ -124,6 +124,7 @@ x string #### A masked pattern was here #### Constraints Primary Key for default.table3:[x], Constraint Name: #### A masked pattern was here #### +Foreign Keys for default.table3:[ {Constraint Name: fk1, (Parent Column Name: default.table2.a, Column Name: x, Key Sequence: 1)}] PREHOOK: query: DESCRIBE EXTENDED table4 PREHOOK: type: DESCTABLE PREHOOK: Input: default@table4 @@ -135,7 +136,7 @@ y string #### A masked pattern was here #### Constraints Primary Key for default.table4:[x], Constraint Name: #### A masked pattern was here #### -Foreign Keys for default.table4:[ {Constraint Name: fk3, (Parent Column Name: default.table2.a, Column Name: y, Key Sequence: 1)}] +Foreign Keys for default.table4:[ {Constraint Name: fk2, (Parent Column Name: default.table2.a, Column Name: x, Key Sequence: 1)}, {Constraint Name: fk3, (Parent Column Name: default.table2.a, Column Name: y, Key Sequence: 1)}] PREHOOK: query: DESCRIBE EXTENDED table5 PREHOOK: type: DESCTABLE PREHOOK: Input: default@table5 @@ -146,6 +147,7 @@ x string #### A masked pattern was here #### Constraints Primary Key for default.table5:[x], Constraint Name: #### A masked pattern was here #### +Foreign Keys for default.table5:[ {Constraint Name: #### A masked pattern was here ####, (Parent Column Name: default.table2.a, Column Name: x, Key Sequence: 1)}] PREHOOK: query: DESCRIBE EXTENDED table6 PREHOOK: type: DESCTABLE PREHOOK: Input: default@table6 @@ -157,7 +159,7 @@ y string #### A masked pattern was here #### Constraints Primary Key for default.table6:[x], Constraint Name: #### A masked pattern was here #### -Foreign Keys for default.table6:[ {Constraint Name: fk4, (Parent Column Name: default.table1.a, Column Name: y, Key Sequence: 1)}] +Foreign Keys for default.table6:[ {Constraint Name: fk4, (Parent Column Name: default.table1.a, Column Name: y, Key Sequence: 1)}, {Constraint Name: #### A masked pattern was here ####, (Parent Column Name: default.table2.a, Column Name: x, Key Sequence: 1)}] PREHOOK: query: DESCRIBE EXTENDED table7 PREHOOK: type: DESCTABLE PREHOOK: Input: default@table7 @@ -215,7 +217,7 @@ c string #### A masked pattern was here #### Constraints Primary Key for default.table11:[a], Constraint Name: pk11 -Foreign Keys for default.table11:[ {Constraint Name: #### A masked pattern was here ####, (Parent Column Name: default.table9.a, Column Name: a, Key Sequence: 1), (Parent Column Name: default.table9.b, Column Name: b, Key Sequence: 2)}, {Constraint Name: #### A masked pattern was here ####, (Parent Column Name: default.table4.x, Column Name: c, Key Sequence: 1)}] +Foreign Keys for default.table11:[ {Constraint Name: fk11_1, (Parent Column Name: default.table9.a, Column Name: a, Key Sequence: 1), (Parent Column Name: default.table9.b, Column Name: b, Key Sequence: 2)}, {Constraint Name: fk11_2, (Parent Column Name: default.table4.x, Column Name: c, Key Sequence: 1)}] PREHOOK: query: DESCRIBE FORMATTED table1 PREHOOK: type: DESCTABLE PREHOOK: Input: default@table1 @@ -341,6 +343,12 @@ Storage Desc Params: Table: default.table3 Constraint Name: #### A masked pattern was here #### Column Names: x + +# Foreign Keys +Table: default.table3 +Constraint Name: fk1 +Parent Column Name:default.table2.a Column Name:x Key Sequence:1 + PREHOOK: query: DESCRIBE FORMATTED table4 PREHOOK: type: DESCTABLE PREHOOK: Input: default@table4 @@ -386,6 +394,9 @@ Column Names: x # Foreign Keys Table: default.table4 +Constraint Name: fk2 +Parent Column Name:default.table2.a Column Name:x Key Sequence:1 + Constraint Name: fk3 Parent Column Name:default.table2.a Column Name:y Key Sequence:1 @@ -430,6 +441,12 @@ Storage Desc Params: Table: default.table5 Constraint Name: #### A masked pattern was here #### Column Names: x + +# Foreign Keys +Table: default.table5 +Constraint Name: #### A masked pattern was here #### +Parent Column Name:default.table2.a Column Name:x Key Sequence:1 + PREHOOK: query: DESCRIBE FORMATTED table6 PREHOOK: type: DESCTABLE PREHOOK: Input: default@table6 @@ -478,6 +495,9 @@ Table: default.table6 Constraint Name: fk4 Parent Column Name:default.table1.a Column Name:y Key Sequence:1 +Constraint Name: #### A masked pattern was here #### +Parent Column Name:default.table2.a Column Name:x Key Sequence:1 + PREHOOK: query: DESCRIBE FORMATTED table7 PREHOOK: type: DESCTABLE PREHOOK: Input: default@table7 @@ -699,11 +719,11 @@ Column Names: a # Foreign Keys Table: default.table11 -Constraint Name: #### A masked pattern was here #### +Constraint Name: fk11_1 Parent Column Name:default.table9.a Column Name:a Key Sequence:1 Parent Column Name:default.table9.b Column Name:b Key Sequence:2 -Constraint Name: #### A masked pattern was here #### +Constraint Name: fk11_2 Parent Column Name:default.table4.x Column Name:c Key Sequence:1 PREHOOK: query: ALTER TABLE table2 DROP CONSTRAINT pk1 @@ -867,6 +887,158 @@ Storage Desc Params: Table: default.table6 Constraint Name: #### A masked pattern was here #### Column Names: x +PREHOOK: query: ALTER TABLE table2 ADD CONSTRAINT pkt2 primary key (a) disable novalidate +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +POSTHOOK: query: ALTER TABLE table2 ADD CONSTRAINT pkt2 primary key (a) disable novalidate +POSTHOOK: type: ALTERTABLE_ADDCONSTRAINT +PREHOOK: query: ALTER TABLE table3 ADD CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE RELY +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +POSTHOOK: query: ALTER TABLE table3 ADD CONSTRAINT fk1 FOREIGN KEY (x) REFERENCES table2(a) DISABLE NOVALIDATE RELY +POSTHOOK: type: ALTERTABLE_ADDCONSTRAINT +PREHOOK: query: ALTER TABLE table6 ADD CONSTRAINT fk4 FOREIGN KEY (y) REFERENCES table1(a) DISABLE NOVALIDATE +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +POSTHOOK: query: ALTER TABLE table6 ADD CONSTRAINT fk4 FOREIGN KEY (y) REFERENCES table1(a) DISABLE NOVALIDATE +POSTHOOK: type: ALTERTABLE_ADDCONSTRAINT +PREHOOK: query: DESCRIBE FORMATTED table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table2 +POSTHOOK: query: DESCRIBE FORMATTED table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table2 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table2 +Constraint Name: pkt2 +Column Names: a +PREHOOK: query: DESCRIBE FORMATTED table3 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table3 +POSTHOOK: query: DESCRIBE FORMATTED table3 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table3 +# col_name data_type comment + +x string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table3 +Constraint Name: #### A masked pattern was here #### +Column Names: x + +# Foreign Keys +Table: default.table3 +Constraint Name: fk1 +Parent Column Name:default.table2.a Column Name:x Key Sequence:1 + +PREHOOK: query: DESCRIBE FORMATTED table6 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table6 +POSTHOOK: query: DESCRIBE FORMATTED table6 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table6 +# col_name data_type comment + +x string +y string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table6 +Constraint Name: #### A masked pattern was here #### +Column Names: x + +# Foreign Keys +Table: default.table6 +Constraint Name: fk4 +Parent Column Name:default.table1.a Column Name:y Key Sequence:1 + +Constraint Name: #### A masked pattern was here #### +Parent Column Name:default.table2.a Column Name:x Key Sequence:1 + PREHOOK: query: CREATE DATABASE dbconstraint PREHOOK: type: CREATEDATABASE PREHOOK: Output: database:dbconstraint @@ -995,3 +1167,101 @@ Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 +PREHOOK: query: ALTER TABLE dbconstraint.table2 ADD CONSTRAINT pk1 primary key (a) disable novalidate +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +POSTHOOK: query: ALTER TABLE dbconstraint.table2 ADD CONSTRAINT pk1 primary key (a) disable novalidate +POSTHOOK: type: ALTERTABLE_ADDCONSTRAINT +PREHOOK: query: DESCRIBE FORMATTED dbconstraint.table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: dbconstraint@table2 +POSTHOOK: query: DESCRIBE FORMATTED dbconstraint.table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: dbconstraint@table2 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: dbconstraint +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: dbconstraint.table2 +Constraint Name: pk1 +Column Names: a +PREHOOK: query: ALTER TABLE dbconstraint.table2 ADD CONSTRAINT fkx FOREIGN KEY (b) REFERENCES table1(a) DISABLE NOVALIDATE +PREHOOK: type: ALTERTABLE_ADDCONSTRAINT +POSTHOOK: query: ALTER TABLE dbconstraint.table2 ADD CONSTRAINT fkx FOREIGN KEY (b) REFERENCES table1(a) DISABLE NOVALIDATE +POSTHOOK: type: ALTERTABLE_ADDCONSTRAINT +PREHOOK: query: DESCRIBE FORMATTED dbconstraint.table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: dbconstraint@table2 +POSTHOOK: query: DESCRIBE FORMATTED dbconstraint.table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: dbconstraint@table2 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: dbconstraint +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: dbconstraint.table2 +Constraint Name: pk1 +Column Names: a + +# Foreign Keys +Table: dbconstraint.table2 +Constraint Name: fkx +Parent Column Name:default.table1.a Column Name:b Key Sequence:1 +
