Search found 26 matches
- Wed Apr 22, 2015 9:50 am
- Forum: Vertica Certification
- Topic: HP2-N36 : Need sugession
- Replies: 3
- Views: 19509
Re: HP2-N36 : Need sugession
http://www.vertica.com/wp-content/uploa ... -guide.pdf <= Hope this help.
- Mon Nov 17, 2014 9:51 am
- Forum: Vertica SQL Functions
- Topic: now() <> sysdate
- Replies: 6
- Views: 27737
Re: now() <> sysdate
NOW() This function returns the start time of the current transaction; the value does not change during the transaction. The intent is to allow a single transaction to have a consistent notion of the "current" time, so that multiple modifications within the same transaction bear the same timestamp....
- Mon Nov 17, 2014 8:10 am
- Forum: New to Vertica
- Topic: How to push the data for Vertica Database ?
- Replies: 7
- Views: 16675
Re: How to push the data for Vertica Database ?
Oracle Net Listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server. https://docs.oracle.com/cd/E11882_01/network.112/e41945/listenercfg.htm I'm not sure what you mean by...
- Mon Nov 17, 2014 7:49 am
- Forum: Vertica Certification
- Topic: HP2-N45 Vertica Big Data Solutions Administrator
- Replies: 18
- Views: 57773
Re: HP2-N45 Vertica Big Data Solutions Administrator
I've passed the exam. Good luck for the lab portion.
- Mon Oct 20, 2014 3:46 am
- Forum: New to Vertica
- Topic: WOS and ROS
- Replies: 14
- Views: 46570
Re: WOS and ROS
Good discussion. What is the benefit of having WOS? Why do not we load it directly into ROS? I understand that WOS is for trickle feed and ROS is for bulk load. Why can not Vertica have just ROS? Vertica has limit on number of storage containers per projection. You can only have 1024 ROS containers...
- Wed Sep 17, 2014 1:42 pm
- Forum: Vertica SQL
- Topic: Performance tuning a COUNT DISTINCT
- Replies: 6
- Views: 12294
Re: Performance tuning a COUNT DISTINCT
There is the good article about count distinct on the link below.
Avoiding the OLAP Cliff for Count Distinct Queries in Vertica
http://www.vertica.com/2014/03/05/avoid ... n-vertica/
Avoiding the OLAP Cliff for Count Distinct Queries in Vertica
http://www.vertica.com/2014/03/05/avoid ... n-vertica/
- Tue Sep 16, 2014 10:15 am
- Forum: ODBC
- Topic: Connecting Vertica to MS SQL
- Replies: 6
- Views: 27064
Re: Connecting Vertica to MS SQL
Can you connect MS SQL from Linux (Vertica server)?
SQL Server ODBC Driver for Linux/Unix Getting Started Tutorial
http://www.easysoft.com/products/data_a ... arted.html
SQL Server ODBC Driver for Linux/Unix Getting Started Tutorial
http://www.easysoft.com/products/data_a ... arted.html