[
https://issues.apache.org/jira/browse/DRILL-5186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ravan updated DRILL-5186:
-------------------------
Description:
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;
was:
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;
> IS 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.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)
