Search found 14 matches

by sam
Tue Mar 31, 2015 12:29 pm
Forum: Vertica SQL
Topic: Query to get # of days in mutiple year range
Replies: 4
Views: 9173

Re: Query to get # of days in mutiple year range

Thanks, all! That query is pretty cool knicely87. It works fast enough for my needs.
by sam
Thu Mar 26, 2015 1:14 pm
Forum: Vertica SQL
Topic: Query to get # of days in mutiple year range
Replies: 4
Views: 9173

Query to get # of days in mutiple year range

Good morning! Can someone help me write a query that can be used to get the following: 1. Total number of days 2. Total number of week days (M-F) 3. Total number of weekend days (S-Su) ...that occur between two year ranges (i.e. 2012 - 2015). I am not sure how to handle leap years. Thanks in advance!
by sam
Thu Dec 11, 2014 5:34 pm
Forum: New to Vertica Database Administration
Topic: Set/Change the EXPORT_ADDRESS
Replies: 3
Views: 9253

Re: Set/Change the EXPORT_ADDRESS

I want to test native connection load balancing. Doc says the EXPORT_ADDRESS field is for "The IP address of the node (on the public network) used for import/export operations and native load-balancing." :)
by sam
Thu Dec 11, 2014 5:29 pm
Forum: New to Vertica Database Administration
Topic: Difference between inter-node and spread communications?
Replies: 3
Views: 8194

Re: Difference between inter-node and spread communications?

#norbertk, thanks for the explanation! Is there any documentation that goes into this topic in a little more detail?
by sam
Thu Dec 11, 2014 4:14 pm
Forum: New to Vertica Database Administration
Topic: Set/Change the EXPORT_ADDRESS
Replies: 3
Views: 9253

Set/Change the EXPORT_ADDRESS

How do a set/change the EXPORT_ADDRESS in the nodes table?
by sam
Thu Dec 11, 2014 4:12 pm
Forum: New to Vertica Database Administration
Topic: Difference between inter-node and spread communications?
Replies: 3
Views: 8194

Difference between inter-node and spread communications?

Regarding how nodes in a cluster interact with one another, is there a difference between "inter-node and spread communications"? I see this reference in th admin doc a lot.
by sam
Thu Apr 03, 2014 4:56 am
Forum: vSQL
Topic: Turn off feedback from DDL statements, etc.
Replies: 2
Views: 15810

Re: Turn off feedback from DDL statements, etc.

Thanks for your reply, however that solution does not work :(

Code: Select all

dbadmin=> \pset footer
Default footer is off.
dbadmin=> create table t (c int);
CREATE TABLE
The "CREATE TABLE" output is still visible...

Go to advanced search