Apache Drill - NULLIF(x,y)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select NULLIF(3,3) from (values(1));

Result

+---------+
| EXPR$0  |
+---------+
|  null   |
+---------+

Here both the arguments are same, so the result is NULL.

Kickstart Your Career

Get certified by completing the course

Get Started