Search found 149 matches
- 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.
- 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
- 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?
- 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');
- 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!
- 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!
- 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.
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.