[ https://issues.apache.org/jira/browse/DRILL-4441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15167846#comment-15167846 ]
Stefán Baxter commented on DRILL-4441: -------------------------------------- This query targets Avro files in the latest 1.5 release: 0: jdbc:drill:zk=local> select count(*) from dfs.asa.`/streaming/venuepoint/transactions/` as s where s.sold_to = 'Customer/4-2492847'; +---------+ | EXPR$0 | +---------+ | 5788 | +---------+ 0: jdbc:drill:zk=local> select count(*) from dfs.asa.`/streaming/venuepoint/transactions/` as s where s.sold_to IN ('Customer/4-2492847'); +---------+ | EXPR$0 | +---------+ | 0 | +---------+ It shows that the IN operator does not work with Avro (works with Parquet). > IN operator does not work with Avro reader > ------------------------------------------ > > Key: DRILL-4441 > URL: https://issues.apache.org/jira/browse/DRILL-4441 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Other > Affects Versions: 1.5.0 > Environment: Ubuntu > Reporter: Stefán Baxter > Fix For: 1.6.0 > > > IN operator simply does not work. > (And I find it interesting that Storage-Avro is not available here in Jira as > a Storage component) -- This message was sent by Atlassian JIRA (v6.3.4#6332)