O'Reilly logo

Tera-Tom Genius Series - Hadoop Architecture and SQL by Jason 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 16 – Statistical Aggregate Functions

“You can make more friends in two months by becoming interested in other people than you will in two years by trying to get other people interested in you."

- Dale Carnegie

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

Find the smallest integer not smaller than x by using the ceil command. This stands for a number’s ...

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