Vertica - Export table with IDENTITY
In Vertica, We have can created a table with IDENTITY or AUTO INCREMENT constraints or sequence for a field.
While using export command and taking dump and restore the dump into anther vertica setup, we facing error .
All rows are rejected due to above constraints .
Need help to take dump with constraint (IDENTITY or AUTO INCREMENT) and restore data dump with same constraint for backup process.