ALTER TABLE "Table_2"
ADD CONSTRAINT "REL_1"
FOREIGN KEY("a")
REFERENCES "Table_1"("a")
GO
![]() |
1 KB
fixed in 14.0.0-rc-36.
Hive doesn't support foreign key constraints. ERM will allow the user to visually model the relationships, but no underlying SQL will be generated for the relationships.
Issue #10057 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 14.0.0-rc-36 |
No time estimate |
1 issue link |
relates to #10205
Issue #10205ER-Diagram-> Constraints can be added to the Table, which is not supported in Hive |
fixed in 14.0.0-rc-36.
Hive doesn't support foreign key constraints. ERM will allow the user to visually model the relationships, but no underlying SQL will be generated for the relationships.