[ https://issues.apache.org/jira/browse/DRILL-3042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Neeraja resolved DRILL-3042. ---------------------------- Resolution: Fixed Not reproducible in 1.4 > where fails on fields converted to JSON > --------------------------------------- > > Key: DRILL-3042 > URL: https://issues.apache.org/jira/browse/DRILL-3042 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.9.0 > Reporter: Will Ochandarena > Fix For: Future > > Attachments: WHEREfail.json > > > See attached sample log from Google App Engine. When I create a view of that > data that extracts an inner field and converts it to JSON - > -- > create or replace view alltypes as select t3.line.status as status from > (select convert_from(line,'JSON') as line from (select t1.tp.logMessage as > line from(select flatten(t.protoPayload.line) as tp from > dfs.`/Users/wochandarena/Downloads/WHEREfail.json` t) as t1 where > t1.tp.logMessage LIKE '{%') as t2) as t3; > -- > Then query the view with a where clause, the error below is seen. > -- > 0: jdbc:drill:zk=local> select * from alltypes; > +------------+ > | status | > +------------+ > | Status | > +------------+ > 1 row selected (0.345 seconds) > 0: jdbc:drill:zk=local> select * from alltypes where status=Status; > Query failed: SYSTEM ERROR: Unexpected exception during fragment > initialization: null > [a1790b40-0055-4793-984f-b37ce72cb92f on 172.30.1.6:31010] > Error: exception while executing query: Failure while executing query. > (state=,code=0) -- This message was sent by Atlassian JIRA (v6.3.4#6332)