O'Reilly logo

HP Vertica - Architecture and SQL by Leslie Nolander, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14 – Interrogating the Data

"The difference between genius and stupidity is that genius has its limits"

- Albert Einstein

Numeric Manipulation Functions

image

The functions above are often used for algebraic, trigonometric, or geometric calculations.

Finding the Cube Root

image

Find the cube root with the cbrt function.

Ceiling Gets the Smallest Integer Not Smaller Than X

image

Find the smallest integer not smaller than x by using the ceil command. This stands ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required