[ https://issues.apache.org/jira/browse/DRILL-2227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14522318#comment-14522318 ]
Daniel Barclay (Drill) commented on DRILL-2227: ----------------------------------------------- This seems to be fixed. Running the reported querying (a copy of) the attached data file does not yield an error. > Using flatten in a project, filter (where in ...), and order by throws an > ClassCastException > -------------------------------------------------------------------------------------------- > > Key: DRILL-2227 > URL: https://issues.apache.org/jira/browse/DRILL-2227 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Reporter: Rahul Challapalli > Assignee: Daniel Barclay (Drill) > Fix For: 1.0.0 > > Attachments: data.json, error.log > > > git.commit.id.abbrev=3d863b5 > The below query fails : > {code} > select uid, flatten(lst_lst[0]) from `data.json` where 2 in (select > flatten(lst_lst[1]) from `data.json`) order by flatten(lst_lst[1]); > Query failed: RemoteRpcException: Failure while running fragment., > org.apache.drill.exec.vector.BigIntVector cannot be cast to > org.apache.drill.exec.vector.RepeatedVector > {code} > However if we apply flatten on the same column in the "select" part, it > succeeds > {code} > 0: jdbc:drill:schema=dfs_eea> select uid, flatten(lst_lst[1]) from > `data.json` where 2 in (select flatten(lst_lst[1]) from `data.json`) order by > flatten(lst_lst[1]); > +------------+------------+ > | uid | EXPR$1 | > +------------+------------+ > | 1 | 2 | > | 2 | 2 | > | 1 | 3 | > | 2 | 3 | > | 1 | 4 | > | 2 | 4 | > | 1 | 5 | > | 2 | 5 | > | 1 | 6 | > | 2 | 6 | > +------------+------------+ > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)