MichaelB.
7/29/2018 - 6:50 PM

Add partitions to a table

SQL statements have more functionality than graphical editor in HANA to partition tables. Can alter partitions, and add partitions to existing tables. Can drop partitions. See HANA Adminstration Guide.

sql
content_copyfile_download
CREATE COLUMN TABLE schema_name.first_table
(
    field1 datatype,
    field2 datatype(length)
    ...
    fieldn datatype,
)
PARTITION BY RANGE (field)
(PARTITION 1 <= VALUES < n,
PARTITION n+1 <= VALUES < m,
PARTITION VALUE = p, PARTITION OTHERS);