× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2012-12-05T22:45:55Z  · last modified 2012-12-21T18:55:02Z

Distribution key is missing in Greenplum ER Modeler


Dev
Fun Fun
funfun
QA
Sachin Prakash
SachinPrakash
Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version 13.0

Product: Aqua Data Studio
Version: 13.0-dev-42
Build #: 30427
Build Date: 2012-Dec-04 10:21:38 AM

1. Created a table in Greenplum with distribution key

CREATE TABLE "campus"."dist_test"  (
    "a1"    varchar(25) NOT NULL,
    "a2"    varchar(25) NOT NULL,
    "a3"    varchar(25) NOT NULL,
    "a4"    varchar(25) NOT NULL
    )
DISTRIBUTED BY (a3)
 

2. Generated ER Model

3. When i try to script it back, the "DISTRIBUTED BY (a3)" is missing because the ER Modeler column parameter doesnt have a field to capture that distribution information

4. In the ER Model Storage Tab you can see a Distribution Policy which i can select but the value doesnt get reflected

1 attachment

Issue #8019

Closed
Fixed
Resolved 2012-12-20T23:23:49Z
 
 
Completion
No due date
Fixed Build trunk/30699
No time estimate

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