CREATE TABLE <table-name> (column definitions) [REGISTER];

DROP TABLE <table-name> [PURGE];

INSERT INTO <table-name> PARTITION
‘path1_arch’[:’path1_upd’]  …   ‘pathN_arch’[:’pathN_upd’];

DELETE FROM <table-name> PARTITION
WHERE {VPART_ID = fileId}|{VPART_ID IN ( fileId1, …, fileIdN )} [PURGE];

UPDATE <table-name> SET PARTION {ONLINE|OFFLINE}
WHERE {VPART_ID = fileId}|{VPART_ID IN ( fileId1, …, fileIdN )};

DELETE FROM <table-name> EXPIRED BY <column-name>;

UPDATE <table-name> FROM FILE 'update-file-path'; 
		

PURGE TABLE <table-name>;