Hi pk132007, You can take the HP2-N36 certification exam from your home computer. This pdf tells you what is on the exam (kind of). http://www.vertica.com/wp-content/uploads/2013/02/HP2-N36-exam-prep-guide.pdf Also, read the Concepts Guide which is available online here: https://my.vertica.com/docs...

Hey i am planning to give HP2-N36 exam in next month. I am preparing for it from vertica online videos and documnets avaliable on vertica website. I have few queries - 1. Are the web videos sufficient enough for this exam. If not, what other documents/sites/books i should refer. 2. I have gone thro...

I am trying to run a vertica sql query Select SUM(column1) from table; If column1 has null value for all the records, then the query will return a single character. I have to capture it in a varaible in unix so that i can compare it. var=$(/opt/vertica/bin/vsql -c "Select SUM(column1) from table;") ...

Hi, Boot camp training is not a mandatory one for the exam.web training available in my vertica portal is enough to attend the exam. I have one quesiton,Have any body taken HP2-N36 exam in India.Please let me know if some body attempted for it in India. Thanks in advance. Hey i am planning to give ...

We have a requirement where we calling V_CATALOG.VIEW_COLUMNS catalog table iteratively inside a script to get the metadata for aroung 300 columns. We are quering V_CATALOG.VIEW_COLUMNS table one by one for each column. The query is taking a lot of time to fetch the data. Is there any way we can red...

Thanks Julie and sKwa.
This is what i was looking for.

I have a requirement where i need to remove the trailing zeroes from the decimal values. But in case there is no digit after decimal then a single zero should come. Example : 0.0000 => 0.0 123.45600 => 123.456 27.0000 => 27.0 I have tried using TRIM and other cast functions, but nothing worked out. ...