I know in Aster, we can add partitions to logically partitioned table. We can also remove partitions from a logically partition table.
My question is if you create a table and forget to partition it. How will you add partitioning?
Figured it out.
YOU CANNOT ALTER A TABLE AND ADD PARTITION
In Aster, you can only add partitions or remove partitions to a logically partitioned table.
( unlike in teradata where you can alter table primary index and add partition. Here you cannot)