AnsweredAssumed Answered

MapR Drill problem with where 1=0

Question asked by fromamit81 on Oct 15, 2017
Latest reply on Oct 18, 2017 by arjunkr

Problem with Where clause ( I am using MapR odbc driver)

 

select * from Oracle.Active where 1=0;

 

[MapR][Drill] (1040) Drill failed to execute the query: select * from Oracle.Active where 1=0 [30029]Query execution error. Details:[ SYSTEM ERROR: NullPointerException [Error Id: bb4a66f3-314e-43a0-9aff-1122514b9642 on den00qvh.us.oracle.com:31010] ] QODBC3: Unable to execute statement

 

If I remove where 1=0 as below , It works fine.

 

select * from Oracle.Active 

 

Is this a bug ?

Outcomes