@nnani: This is not correct. Before commiting the new data loaded, you can run ANALYZE_CONSTRAINTS() to ask the engine to check constraint violations.
Check this thread:
viewtopic.php?f=48&t=845
Search found 20 matches
- Sat Jan 11, 2014 6:44 pm
- Forum: New to Vertica
- Topic: INSERT IGNORE
- Replies: 3
- Views: 9806
- Sat Jan 11, 2014 6:37 pm
- Forum: New to Vertica
- Topic: Can not create buddy projection ?
- Replies: 3
- Views: 12179
Re: Can not create buddy projection ?
4GB per node?? Come on! I have 16GB in my laptop... Buy some RAM.
- Sat Jan 11, 2014 6:30 pm
- Forum: Vertica Data Load
- Topic: ERROR 2344: Cannot allocate sufficient memory for COPY ...
- Replies: 4
- Views: 11796
Re: ERROR 2344: Cannot allocate sufficient memory for COPY
Check the resource pool you are using to load the data.
- Sat Jan 11, 2014 6:22 pm
- Forum: Vertica Database Administration
- Topic: Projection Encoding Design
- Replies: 4
- Views: 9713
Re: Projection Encoding Design
How is your projection segmented?
- Sat Jan 04, 2014 8:00 pm
- Forum: New to Vertica
- Topic: Projection questions sort order
- Replies: 3
- Views: 8897
Re: Projection questions sort order
Just because you can do it doesn't mean you should! Every query can use only one projection per table for the entire query. This means that once the optimizer has determined which one it will use, the other ones become useless! This means that your query will mostly run on one node only if you don't...
- Sat Jan 04, 2014 7:56 pm
- Forum: New to Vertica
- Topic: Running multiple databases concurrently
- Replies: 3
- Views: 11076
Re: Running multiple databases concurrently
It is technically possible to run multiple instances of Vertica on the same cluster at the same time. They would use different port numbers and you have to start them up "by hand" on the command line, not by using admintools. However, this is not supported and obviously not recommended to use in pro...
- Fri Jan 03, 2014 6:09 pm
- Forum: Vertica Performance Tuning
- Topic: Can't optimize query
- Replies: 2
- Views: 7060
Re: Can't optimize query
Make sure you have foreign keys and primary keys defined.