Database Plugins: Yellowbrick "Add Distribution type" configuration setting

A change was implemented for Yellowbrick clients to create the temp tables using the HASH distribution and specifying the PK/resolution key.

For example:

SQL

CREATE TABLE RPI_BC_1506_1_D AS
SELECT o.*
FROM "mcrmrpi"."RPI_BC_1506_1" o
JOIN "mcrmrpi"."RPI_210104110419910_pks_f7193d88f41a4c37b91acc8054" t
    ON t."RP_UniqueID" = o."RP_UniqueID"
DISTRIBUTE ON (RP_UniqueID);

If a key is not provided, it will default to using the first column in the table.

A new configuration option has been added that would allow the client to disable the replicate distribution where it's not suitable (larger environments):

Configuration > System Configuration
YellowbrickDistributionType
- Group = Database
- Default value = 0
- Description = If set, DISTRIBUTE is used for all RPI-generated tables. Values are 0=COLUMN, 1=REPLICATE, 2=RANDOM

These changes are included in RPI 6.1.21027.1336 and higher versions. Download the latest version(s) here: RPI 6.1 Download Center.