Greetings of the day. DB version is 220.127.116.11. Am trying to compress a big table which has lot of partitions.
Create test as select * from original_table - This creates table with data but the ddl of the test table shows without partitions.
How do i create the same table with all the paritions with CTAS?