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.