[ https://issues.apache.org/jira/browse/DRILL-7264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16842113#comment-16842113 ]
Arina Ielchiieva commented on DRILL-7264: ----------------------------------------- [~teroz] please provide dataset and details which plugin is used. > Using LIMIT causes ClassCastException > ------------------------------------- > > Key: DRILL-7264 > URL: https://issues.apache.org/jira/browse/DRILL-7264 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.16.0 > Environment: ubuntu 18.04 > Reporter: Terence Namusonge Sifuna > Priority: Major > > a simple select on one table throws and exception if *IN* operater is used > and *LIMIT* as well > ```_select id,lid,what,pid,ppid,uid,gid,euid,eguid,exe,tty,cmdline,`start` > from procs WHERE lid in > ('5cdd87378082155f3dd4fa71','5cdd885a8082155f3dd4fa72') limit 1000;_``` > > same select works if the limit is removed -- This message was sent by Atlassian JIRA (v7.6.3#76005)