Search found 14 matches
- Tue Mar 31, 2015 12:29 pm
- Forum: Vertica SQL
- Topic: Query to get # of days in mutiple year range
- Replies: 4
- Views: 9254
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.
- Thu Mar 26, 2015 1:14 pm
- Forum: Vertica SQL
- Topic: Query to get # of days in mutiple year range
- Replies: 4
- Views: 9254
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!
- Thu Dec 11, 2014 5:34 pm
- Forum: New to Vertica Database Administration
- Topic: Set/Change the EXPORT_ADDRESS
- Replies: 3
- Views: 9310
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."
- Thu Dec 11, 2014 5:29 pm
- Forum: New to Vertica Database Administration
- Topic: Difference between inter-node and spread communications?
- Replies: 3
- Views: 8259
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?
- Thu Dec 11, 2014 4:14 pm
- Forum: New to Vertica Database Administration
- Topic: Set/Change the EXPORT_ADDRESS
- Replies: 3
- Views: 9310
Set/Change the EXPORT_ADDRESS
How do a set/change the EXPORT_ADDRESS in the nodes table?
- Thu Dec 11, 2014 4:12 pm
- Forum: New to Vertica Database Administration
- Topic: Difference between inter-node and spread communications?
- Replies: 3
- Views: 8259
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.
- Thu Apr 03, 2014 4:56 am
- Forum: vSQL
- Topic: Turn off feedback from DDL statements, etc.
- Replies: 2
- Views: 16371
Re: Turn off feedback from DDL statements, etc.
Thanks for your reply, however that solution does not work
The "CREATE TABLE" output is still visible...
Code: Select all
dbadmin=> \pset footer
Default footer is off.
dbadmin=> create table t (c int);
CREATE TABLE