While INSERT- SELECT from a UPI table to a NOPI table the data from the source table will not be distributed and will be locally appended to the target table.
The rows will be placed on the same AMP as of the original table row.
Will the rows be sorted??
The rows will be insertd as-is, i.e. no additional sort.