Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientnegative
/
alter_table_constraint_invalid_fk_col2.q
blob: cfc07574b037710ffbdb37c3905ebb9eedb4397d [
file
] [
log
] [
blame
]
CREATE TABLE table1
(
a STRING
,
b STRING
,
primary key
(
a
)
disable
);
CREATE TABLE table2
(
a STRING
,
b STRING
,
primary key
(
a
)
disable rely
);
alter table table2 add constraint fk1 foreign key
(
b
)
references table1
(
c
)
disable novalidate
;