Search found 49 matches

by Brett
Thu Oct 30, 2014 2:24 am
Forum: Vertica SQL Functions
Topic: now() <> sysdate
Replies: 6
Views: 27112

now() <> sysdate

Hi all, Can someone explain why these two functions return two different times? vertica=> select now(), sysdate; now | sysdate -------------------------------+---------------------------- 2014-10-29 16:11:42.624765-07 | 2014-10-29 18:20:17.089996 (1 row) Thank you
by Brett
Mon Oct 27, 2014 7:25 pm
Forum: Vertica Database Administration
Topic: Odd or Even Number of Nodes
Replies: 3
Views: 8941

Odd or Even Number of Nodes

Hi guys,

Is it better to have an odd or even number of nodes in a Vertica cluster?

Thanks
by Brett
Thu Sep 25, 2014 12:11 am
Forum: New to Vertica Database Administration
Topic: Projection ordering
Replies: 0
Views: 3975

Projection ordering

When creating a projection is it better to order by the columns involved in a group by first or the columns involved in a join first?
by Brett
Thu Sep 11, 2014 1:58 am
Forum: New to Vertica Database Administration
Topic: Composite Key vs. Surrogate Key
Replies: 10
Views: 19398

Composite Key vs. Surrogate Key

Hi all, I am curious about other opinions as to which is better in Vertica... a composite PK or a surrogate key. I prefer surrogate keys, but I have some team members who disagree stating that they are to difficult to use when moving data between databases/comparing data between database, etc. Pleas...
by Brett
Tue Sep 02, 2014 6:09 pm
Forum: New to Vertica Database Administration
Topic: Determine catalog size
Replies: 1
Views: 6033

Determine catalog size

Anyone know how to determine the size of a database catalog?
by Brett
Sun Jul 06, 2014 6:34 pm
Forum: New to Vertica SQL
Topic: Sub-set based on 1st and 2nd occurrence of day of week?
Replies: 2
Views: 6340

Sub-set based on 1st and 2nd occurrence of day of week?

Hi,

What's the best performing way that I can write a query to only give me the data for the first and second Monday of every month? The data in my table has rows for every day, but I (actually my boss) only wants to see the first and second Mondays :)
by Brett
Fri Jun 13, 2014 11:54 am
Forum: New to Vertica Database Administration
Topic: How do I run DBD on a single table?
Replies: 6
Views: 12764

How do I run DBD on a single table?

Hello,

How do I run DBD on a single table? Do I just provide it a "SELECT * FROM table_name;" query?

Thank you

Go to advanced search