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.

apache_drill_sql_operations.htm
Advertisements