Question

Create Table AS (CTAS), does it distribute data randomly or based on the table on which it received data?

Answer 1

Response: Newly created table from CTAS gets distribution from the original table.