Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Copy restricting duplicate entries

I need to load files in vertica using copy but i do not want duplicate entries. As unique constraint will not be helpful as it will load data and then i may have to delete duplicate entries from ananlyse_constraints().Other is using insert with bit of logic to check wether entry exist in table. I need some better logic which will restrict duplicate entries.With examples will be very helpful.




Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.