Change datatype from identity to identity(1,1,1)
we have created vertica tables with ID column having datatype Identity. The issue is everytime a session is closed or table truncated the ID value jumps to 250000, 500000 so on. I understand that if we change the cache to 1, this wouldnt be an issue.
So my question is can we alter the column to change datatype from identity to identity(1,1,1) ?