VectorH Limitations
VectorH has the following limitations:
• Adding and removing nodes dynamically, and using more or less cores per node are not supported. Nodes can be added or removed with manual intervention. Repartitioning may be needed.
• Proper partitioning is essential because non-local queries, especially joins, are expensive.
• Deleted space is reclaimed but only if all data of a horizontal split is deleted (by default 1 GB). So worst case scenario, no space is reclaimed; best case scenario, all space is reclaimed. This applies only to data that is deleted through a DELETE statement, not to data deleted through DROP TABLE, MODIFY TO TRUNCATED, or MODIFY TO COMBINE operations, where space is always reclaimed.