[jira] [Commented] (DRILL-4441) IN operator does not work with Avro reader

["Stefán Baxter (JIRA)" <ji...@apache.org>]

    [ 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)