How to Fix ERROR: CANNOT PARALLELIZE AN UPDATE STATEMENT THAT UPDATES THE DISTRIBUTION COLUMNS Printable View

Error: [DataDirect][ODBC Greenplum Wire Protocol driver][Greenplum]ERROR: Cannot parallelize an UPDATE statement that updates the distribution columns(File cdbmutate.c;Line 709;Routine apply_motion;)

Cause: 

When Executing UPDATE Statement on Distribution Key we will see above errors. 

Solution:

As Greenplum will not allow to make Updates on Distribution Key. We have to update the logic to get  the required values through SELECT