Search found 149 matches

by jpcavanaugh
Fri Jan 18, 2013 5:36 pm
Forum: New to Vertica Database Administration
Topic: What is the Initiator Node?
Replies: 3
Views: 8730

Re: What is the Initiator Node?

In the context of a client connection, the initiator node is the node associated with the specific host to which the connection was made. The initiator node can, and usually does, also function as an executor node.
by jpcavanaugh
Thu Jan 10, 2013 7:34 pm
Forum: New to Vertica Database Administration
Topic: WOS Overflow
Replies: 4
Views: 8680

Re: WOS Overflow

At that rate, the default settings for WOS/Tuple mover should be fine
by jpcavanaugh
Thu Jan 10, 2013 4:58 pm
Forum: New to Vertica Database Administration
Topic: WOS Overflow
Replies: 4
Views: 8680

Re: WOS Overflow

WOS size is determined by the WOSDATA resource pool (http://my.vertica.com/docs/6.1.0/HTML/i ... #14361.htm). Are you trickle loading data? If so, how much and how often?
by jpcavanaugh
Mon Dec 17, 2012 8:50 pm
Forum: Vertica SQL
Topic: Command to See SQL That Created A View
Replies: 4
Views: 16974

Re: Command to See SQL That Created A View

Also - select export_objects('','view_name');
by jpcavanaugh
Mon Dec 17, 2012 4:43 pm
Forum: New to Vertica Database Administration
Topic: The ENABLE_JOIN_SPILL option
Replies: 2
Views: 10209

Re: The ENABLE_JOIN_SPILL option

Can you send me the explain without the enable_join_spill? Thanks!
by jpcavanaugh
Mon Dec 17, 2012 3:49 pm
Forum: New to Vertica Database Administration
Topic: Limit rows by user?
Replies: 5
Views: 9515

Re: Limit rows by user?

Glad it worked!
by jpcavanaugh
Mon Dec 17, 2012 2:28 pm
Forum: New to Vertica Database Administration
Topic: Limit rows by user?
Replies: 5
Views: 9515

Re: Limit rows by user?

The wording of the documentation is confusing.

The owner of the view has to have the select privilege not the user who is running the query. So, User1 owns the view and User1 must have select privs on the base table. User2 just needs privs on the view and then it should work fine.

Go to advanced search