Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Sqlways.ini File - Section [Greenplum]

This article describes sqlways.ini file [Greenplum] section and the options it contains.

Option name Description
DISTRIBUTED_BY_ON_PK This option was created for Oracle to Greenplum direction of migration. When this option is set to ‘Yes’ (default value is ‘No’) DISTRIBUTED BY clause is added to CREATE TABLE statement during conversion.
The following rules are applied:
1) If converted table has primary key, DISTRIBUTED BY clause includes all columns that are included in primary key. All UNIQUE INDEXES and UNIQUE constrains are discarded.
2) If converted table has only UNIQUE INDEXES, DISTRIBUTED BY clause is based on the UNIQUE INDEX that has the least number of columns. All other UNIQUE INDEXES and UNIQUE CONSTRAINTS are discarded.

Example:

[greenplum]
DISTRIBUTED_BY_ON_PK=Yes


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/sqlways-ini/greenplum-section.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement