Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientnegative
/
alter_table_constraint_invalid_fk_tbl2.q
blob: f019eb577035d1aa2131b3f39dbbc276ebc95515 [
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 table3
(
a
)
disable novalidate
;