Apache Drill - CONVERT_TO() Function

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select CONVERT_TO(2,'int') as conversion from (values(1));

Result

++
| conversion  |
+-+
|  00000040   |
+-+

Here the output is returned as the hexadecimal value for 2.