Identity column to be used in referential integrity
I am migrating data from MySQL to Vertica.
ID(Auto Increment)key in one table is referenced as the foreign key by another table. This FK implementation is on multiple tables in MySQL and is intrinsic to the functionality.
Vertica doesnt allow FK referencing on an Identity column,simply creating a ID key with int datatype wont work as the column has to be autoincrementing, how would i go about resolving this?