POWER - Amazon Kinesis Data Analytics SQL Reference
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

POWER

POWER ( <base>, <exponent> ) <base> := <number-expression> <exponent> := <number-expression>

Returns the value of the first argument (the base) raised to the power of the second argument (the exponent). Returns null if either the base or the exponent is null, and raises an exception if the base is zero and the exponent is negative, or if the base is negative and the exponent is not a whole number.

Examples

Function Result

POWER(3,2)

9

POWER(-2,3)

-8

POWER(4,-2)

1/16 ..or.. 0.0625

POWER(10.1,2.5)

324.19285157140644