The LOG2 function returns a log value whose antilogarithm is x and base is 2. The return value is a DOUBLE type. If the antilogarithm is 0 or a negative number, an error is returned.
LOG2 ( x )
SELECT log2(1), log2(8);
log2(1) log2(8)
======================================================
0.000000000000000e+00 3.000000000000000e+00