Search found 77 matches
- Sun Oct 27, 2013 3:36 pm
- Forum: New to Vertica
- Topic: Left Join and Right Join - Are they the same?
- Replies: 1
- Views: 6351
Left Join and Right Join - Are they the same?
Is there a difference between a right outer join and a left outer join in Vertica? I friend told me that Vertica only supports a left outer join because that's what what most developers use. Is that true?
- Tue Oct 22, 2013 2:34 pm
- Forum: New to Vertica Database Administration
- Topic: Is PUBLIC a schema, role or user in Vertica?
- Replies: 1
- Views: 5580
Is PUBLIC a schema, role or user in Vertica?
Hi all, In the Admin Guide it has this info: PUBLIC role By default, every database has the special PUBLIC role. HP Vertica grants this role to each user automatically, and it is automatically enabled. You grant privileges to this role that every user should have by default. You can also grant acces...
- Tue Oct 08, 2013 3:31 pm
- Forum: Vertica Database Administration
- Topic: EXPORT_OBJECTS with View (with REPLACE option)
- Replies: 2
- Views: 6199
Re: EXPORT_OBJECTS with View (with REPLACE option)
nnani,
That will work! I can use this when I export all my views. Thanks a bunch
That will work! I can use this when I export all my views. Thanks a bunch
- Tue Oct 08, 2013 1:13 pm
- Forum: Vertica Database Administration
- Topic: EXPORT_OBJECTS with View (with REPLACE option)
- Replies: 2
- Views: 6199
EXPORT_OBJECTS with View (with REPLACE option)
Hello, This may seem like a silly question, but is it possible to get the export_objects function to output a CREATE statement that includes the REPLACE option? For instance, if I create a view called T_V using the CREATE OR REPLACE statement... dbadmin=> create table t (c varchar(10)); CREATE TABLE...
- Wed Sep 25, 2013 1:49 pm
- Forum: New to Vertica Database Administration
- Topic: REBALANCE_CLUSTER vs. START_REBALANCE_CLUSTER
- Replies: 6
- Views: 11017
Re: REBALANCE_CLUSTER vs. START_REBALANCE_CLUSTER
Okay, I see that info. now in the docs. So it's probably best I use START_REBALANCE_CLUSTER. That way I can disconnect from vsql and the process will continue in the background, right?
- Mon Sep 23, 2013 10:30 pm
- Forum: New to Vertica Database Administration
- Topic: REBALANCE_CLUSTER vs. START_REBALANCE_CLUSTER
- Replies: 6
- Views: 11017
REBALANCE_CLUSTER vs. START_REBALANCE_CLUSTER
Howdy,
What are the differences between the REBALANCE_CLUSTER and START_REBALANCE_CLUSTER functions? Don't they do the same thing? Is there a situation where I'd use one over the other?
Any input from your experience would be greatly appreciated!
What are the differences between the REBALANCE_CLUSTER and START_REBALANCE_CLUSTER functions? Don't they do the same thing? Is there a situation where I'd use one over the other?
Any input from your experience would be greatly appreciated!
- Sat Sep 07, 2013 3:43 pm
- Forum: New to Vertica
- Topic: intro!
- Replies: 1
- Views: 4725
Re: intro!
Congratulations