× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2013-09-18T23:06:43Z  · last modified 2013-09-27T20:51:34Z

SQL for relationships is generated in hive which is incorrect


Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version 14.0
Product: Aqua Data Studio
Version: 14.0.0-rc-22
Build #: 34051
Build Date: 2013-Sep-18 11:37:21 AM
 
SQL for relationships is generated in hive which is incorrect
 
 
1. Open a Hive ER Model
2. Add 2 tables and create a relationship between them
3. Go to Tools -> Generate Script and then select the 2 tables and generate the script. 
Below SQL is generated which is incorrect.

 

ALTER TABLE "Table_2"

        ADD CONSTRAINT "REL_1"

        FOREIGN KEY("a")

        REFERENCES "Table_1"("a")

GO

 

4. Sample ER attached - hive.xed

 

1 attachment

Issue #10057

Closed
Fixed
Resolved 2013-09-27T18:27:37Z
 
 
Completion
No due date
Fixed Build 14.0.0-rc-36
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017