You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Ravan (JIRA)" <ji...@apache.org> on 2017/01/10 07:47:58 UTC
[jira] [Created] (DRILL-5186) IS NOT NULL Working for where
condition on INTEGER Column where it has no rows to return
Ravan created DRILL-5186:
----------------------------
Summary: IS NOT NULL Working for where condition on INTEGER Column where it has no rows to return
Key: DRILL-5186
URL: https://issues.apache.org/jira/browse/DRILL-5186
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.8.0
Reporter: Ravan
Query1: (Working)
select * from orcl.SOLIX_DEV.emp where ename is null
O/P: No Results Found
Query2: (Working)
select * from orcl.SOLIX_DEV.emp where comm is null
Query3: (Getting below Exception)
select * from orcl.DEV.emp where empno is null
Getting below exception:-
Query Failed: An Error Occurred
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: NullPointerException
No use even after altering as
alter session set `drill.exec.functions.cast_empty_string_to_null` = true;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)