Apache Drill - CAST( x AS y) Function

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select cast('3' as double) from (values(1));

Result

+———————-+
| EXPR$0 |
+———————-+
|  3.0   |
+———————-+

Here the input value integer 3 is casting as double 3.0.