[ https://issues.apache.org/jira/browse/DRILL-5186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15814371#comment-15814371 ]
Khurram Faraaz commented on DRILL-5186: --------------------------------------- Can you please share the stack trace from drillbit.log ? Is the data in parquet format or text ?, or is the query run over a table in Oracle database ? > IS NULL not 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.DEV.emp where ename is null > O/P: No Results Found > Query2: (Working) > select * from orcl.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)