Search found 302 matches

by scutter
Tue Aug 07, 2012 2:17 am
Forum: Vertica SQL
Topic: De-Duplication in Vertica
Replies: 16
Views: 35249

Re: De-Duplication in Vertica

Can you de-duplicate as a separate step during the load process for duplicate records within the same batch. For removing records from different loads, and thus different epochs, you can use the undocumented 'epoch' column.

select *,epoch from duplicate_table;

Go to advanced search