Search found 45 matches

by piglet
Thu Jun 18, 2015 7:44 pm
Forum: Vertica SQL Functions
Topic: Get ADD_MONTH() function to not truncate time?
Replies: 1
Views: 960

Get ADD_MONTH() function to not truncate time?

Howdy! How do I get the add_months() function to not truncate the time on a timestamp? dbadmin=> select now(), add_months(now(), 1)::timestamp; now | add_months -------------------------------+--------------------- 2015-06-18 14:35:51.644416-04 | 2015-07-18 00:00:00 (1 row) I want to keep the time! ...
by piglet
Thu Mar 12, 2015 10:05 pm
Forum: New to Vertica Database Administration
Topic: Bug in NOT NULL constraint naming ?
Replies: 1
Views: 736

Bug in NOT NULL constraint naming ?

Hello all, Is there some sort of bug in the naming of not null constraints in Vertica? If I create a table with 5 columns making them all not null, the constraint name for each column is the same. I would expect 5 different names. dbadmin=> create table tab1 (a int not null, b int not null, c int no...
by piglet
Thu Dec 11, 2014 7:02 pm
Forum: New to Vertica
Topic: Number of projections needed for k safety
Replies: 3
Views: 1065

Re: Number of projections needed for k safety

Hmm. The picture posted shows 5 nodes and 5 buddy projections for k=1... :?

Buddy Projection = 1
Buddy Projection = 2
Buddy Projection = 3
Buddy Projection = 4
Buddy Projection = 5
by piglet
Thu Dec 11, 2014 6:11 pm
Forum: New to Vertica
Topic: Number of projections needed for k safety
Replies: 3
Views: 1065

Number of projections needed for k safety

Hi, I have a question about the number of projections needed for k safety. There seems to be a discrepancy in the documentation. First it says in the "Designing Segmented Projections for K-Safety" section: Create segmented buddy projections for each of these projections. The total number of projecti...
by piglet
Thu Sep 12, 2013 9:29 pm
Forum: New to Vertica SQL
Topic: Return a range of dates between 2 given dates
Replies: 7
Views: 3262

Re: Return a range of dates between 2 given dates

Cool! Thank guys! sKwa, which option would you recommend for best performance?
by piglet
Thu Sep 12, 2013 3:20 pm
Forum: New to Vertica SQL
Topic: Do not update null values in table with merge
Replies: 2
Views: 880

Re: Do not update null values in table with merge

Thanks Jim! So simple! That solution is perfect.

Go to advanced search