|
|
|
|
|
|
Explanation
When using range segmentation in Vertica V2.0 or later, the segmentation column must be a table-column, not a projection-column. Otherwise, you get a message similar to:
WARNING: DEPRECATED syntax. Segment expression "c1" is a projection column name, segmenting on attribute "pk1" of table "dim_tab" instead
Workaround
No workaround is needed. The message can be ignored unless you intend to use the CREATE PROJECTION statement again. In that case, change c1 to pk1.