Search found 49 matches
- 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
- 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
Is it better to have an odd or even number of nodes in a Vertica cluster?
Thanks
- 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?
- 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...
- 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?
- 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
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
- 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
How do I run DBD on a single table? Do I just provide it a "SELECT * FROM table_name;" query?
Thank you