Search found 5 matches
- Mon Jun 10, 2013 9:33 pm
- Forum: New to Vertica
- Topic: Performance After Creating Views in Vertica
- Replies: 3
- Views: 8395
Performance After Creating Views in Vertica
Hello, We are migrating the data from SQL Server to Hp Vertica. When we created the tables in Vertica we have renamed the tables along with their custom column names to more sensible naming conventions. For Example the table PPS_Group has been renamed as DIM_Group (Group is a dimension table). And t...
- Tue Jun 04, 2013 11:58 pm
- Forum: New to Vertica Database Development
- Topic: How to handle duplicates in vertica ?
- Replies: 2
- Views: 20512
Re: How to handle duplicates in vertica ?
Thanks Nnani for your reply.
- Tue Jun 04, 2013 11:54 pm
- Forum: New to Vertica SQL
- Topic: Less Than Constraint for a Column in Vertica
- Replies: 2
- Views: 6410
Re: Less Than Constraint for a Column in Vertica
Thanks Jim for your reply.
- Sat Jun 01, 2013 12:00 am
- Forum: New to Vertica Database Development
- Topic: How to handle duplicates in vertica ?
- Replies: 2
- Views: 20512
How to handle duplicates in vertica ?
Hello,
Vertica will allow to load the same data file into table any number of time and it will create duplicate rows.
Is there any way to handle this duplicates ??
While data loading if some rows goes to error then what is the best way to handle it?
Thanks in advance.
Vertica will allow to load the same data file into table any number of time and it will create duplicate rows.
Is there any way to handle this duplicates ??
While data loading if some rows goes to error then what is the best way to handle it?
Thanks in advance.
- Fri May 31, 2013 10:07 pm
- Forum: New to Vertica SQL
- Topic: Less Than Constraint for a Column in Vertica
- Replies: 2
- Views: 6410
Less Than Constraint for a Column in Vertica
Hello,
I am migrating some tables from oracle to vertica and i have some less than constraints created on some columns in oracle(for e.g CONSTRAINT "EMP_SALARY_MIN" CHECK (salary > 0) ENABLE,).
How I can add same constraint in vertica while creating the table ?
Thanks-
I am migrating some tables from oracle to vertica and i have some less than constraints created on some columns in oracle(for e.g CONSTRAINT "EMP_SALARY_MIN" CHECK (salary > 0) ENABLE,).
How I can add same constraint in vertica while creating the table ?
Thanks-