No error on executing 'IN' operator without specifying any column name

Posted by prabhatkashyap on Oct 28, 2016; 8:07am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/No-error-on-executing-IN-operator-without-specifying-any-column-name-tp2424.html

Hello,

I've tried to use the following query in carbon data and hive :

select * from mytable where IN(1,2);

While executing it on carbon data it gave me output of "No row selected" but I think there should be an exception/error. whereas when executed in Hive it gave me parse exception:

FAILED: ParseException line 1:31 cannot recognize input near 'IN' '(' '1' in expression specification

Please confirm.

Thanks