[MADLIB-1298] MADLIB doesn't work with gp_distribution_policy changes in Greenplum 6

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.16
• Assignee: Unassigned
• Reporter: Heikki Linnakangas
• Created: 01/Feb/19 16:15
• Updated: 06/Jun/19 00:39
• Resolved: 06/Jun/19 00:39

Description

Recent commits in Greenplum master branch - which will eventually become Greenplum 6 - changed the gp_distribution_policy catalog table's layout. See https://github.com/greenplum-db/gpdb/commit/69ec6926c2284ff97d8b82282072b5b205e8aa27 and https://github.com/greenplum-db/gpdb/commit/242783ae9f573bb03da3d89dc689c6743dfce510.

 

That broke get_distribution_policy() function, in utilities.py_in, because it looks at the renamed gp_distribution_policy.attrnums column. The recommended way to deparse the DISTRIBUTED BY clause of a table is now to use the new pg_catalog.pg_get_table_distributedby() helper function. MADLIB should use that too, when running against GPDB 6.

 

(I'll open a pull request for this shortly)