This article explains why Vertica automatically adds the ON PARTITION RANGE BETWEEN clause during projection refresh operations. It also provides steps to disable this behavior using a database-level parameter.
Environment
- Vertica Analytics Platform
- Projection refresh operations
- Database parameter:
UseIncrementalProjectionRefresh
Situation
A customer raised concerns about Vertica automatically applying the ON PARTITION RANGE BETWEEN clause during projection refresh. This behavior typically affects only the most recent partition and is tied to incremental projection refresh logic.
Cause
Vertica uses the ON PARTITION RANGE BETWEEN clause as part of its incremental projection refresh mechanism. This clause is automatically added to limit refresh operations to specific partitions, usually the most recent one, optimizing performance and reducing resource usage.
