Apache Drill - Math Function CBRT(x)

This cubic root returns the output type as a float type.

Query

0: jdbc:drill:zk = local> values(CBRT(125));

Result

+---------+
| EXPR$0  |
+---------+
|   5.0   | 
+---------+