Admin: 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:

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