Search found 61 matches

by Jbaskin
Thu Aug 29, 2013 4:39 pm
Forum: Employment
Topic: Full Time Vertica positions with HP
Replies: 1
Views: 16950

Re: Full Time Vertica positions with HP

Hello,

How much travel would be involved? Are these positions with HP as a consultant?

Thank you,
Josh
by Jbaskin
Thu Aug 29, 2013 4:35 pm
Forum: New to Vertica
Topic: How do I remove a comment from view?
Replies: 2
Views: 6546

How do I remove a comment from view?

How can I delete a comment that was added to a view? dbadmin=> select comment from comments where object_name = 'store_location_dim'; comment ---------------------------------------- Location dimension for store locations (1 row) I tried this: dbadmin=> delete from comments where object_name = 'stor...
by Jbaskin
Fri Aug 23, 2013 12:37 am
Forum: New to Vertica Database Administration
Topic: Meaning of the 4th line displayed by DISPLAY_LICENSE()?
Replies: 1
Views: 4754

Meaning of the 4th line displayed by DISPLAY_LICENSE()?

Does anyone know what the 30 means from the output from the DISPLAY_LICENSE() function?

Code: Select all

vertica=> SELECT DISPLAY_LICENSE();
              DISPLAY_LICENSE              
-------------------------------------------
 XXX XXXX XXXXX
3/1/2013
Perpetual
30
2TB
by Jbaskin
Mon Nov 26, 2012 5:14 pm
Forum: Vertica SQL
Topic: LAST_VALUE bug?
Replies: 2
Views: 6803

Re: LAST_VALUE bug?

Thank you!

From the documentation I found that I need to specify the windowing clause "ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING" when using LAST_VALUE.

Cool.
by Jbaskin
Sat Nov 17, 2012 12:24 am
Forum: New to Vertica Database Administration
Topic: K-Safety > 2
Replies: 5
Views: 12660

Re: K-Safety > 2

Thanks, guys.

But which are the wrong nodes? For instance, if I have 100 nodes, how do I know which ones are the critical two? There isn't a master node, right?

Sorry, I'm new to the admin. side of things.
by Jbaskin
Fri Nov 16, 2012 8:05 pm
Forum: New to Vertica Database Administration
Topic: K-Safety > 2
Replies: 5
Views: 12660

Re: K-Safety > 2

Thanks for for the reply!

Say I have 10, 100 or 1000 nodes... Does having a max K = 2 mean that if any 2 of those servers fail then my whole cluster will fail?
by Jbaskin
Thu Nov 15, 2012 8:18 pm
Forum: New to Vertica Database Administration
Topic: K-Safety > 2
Replies: 5
Views: 12660

K-Safety > 2

On page 13 of the "Concept's Guide" it states the following: Note: Vertica does not officially support values of K higher than 2. What exactly does that mean? Can we use a higher values of K if we buy more than 5 nodes? I find that to be a weird comment made by Vertica who keeps telling us we can sc...

Go to advanced search