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.