As discussed in Bug #478, it would be nice, if the grammar permits, to allow a LIKE phrase to be used in the DISTRIBUTE clause when the CREATE TABLE statement uses the LIKE clause. Example:
CREATE TABLE child ( LIKE parent INCLUDING ALL ) DISTRIBUTE LIKE parent;
This will allow the DISTRIBUTE BY algorithm specified for the parent
table to be copied to the child
table.