| IS [NOT] DISTINCT FROM | Compares two expressions to determine whether they have the same or different values. NULLs are considered as comparable values. |
| ISDATE | Returns true if the input expression can be cast to a date. |
| IS [NOT] FALSE | Tests whether the input expression is either false or not false. If true in either case, returns a value of true. Alias for the function ISFALSE/ISNOTFALSE. |
| IS [NOT] NULL | Determines if an expression is NULL or not NULL. Alias for the function ISNULL/ISNOTNULL. |
| IS [NOT] TRUE | Tests whether the input expression is either true or not true. If true in either case, returns a value of true. Alias for the function ISTRUE/ISNOTTRUE. |
| IS_BIGINT | Returns TRUE if the input expression is an big integer value. |
| IS_INT | Returns TRUE if the input expression is an integer value. |
| IS_SUBSTR | Returns true if a string is contained within another string. The comparison is case-sensitive. |
| IS_VARCHAR | Returns TRUE if the input expression is a varchar value. |
| SIZE | Returns the number of entries in a map expression. |
| TYPEOF | Reports the type (in string format) of the input expression. |