- The issue is that Hive implemented a non-standard SQL version of the "is null" check.
- We support only the SQL version, which is IS NULL (or IS NOT NULL for the inverse). This command can be verified by running a simple check in the odb tool (or through the workspace tab in the 1.0+ UI):
SELECT 1 IS NULL;
SELECT NULL IS NULL;
- If you amend the query, it should work as an internal view as requested.