Is this same issue as DRILL-4971?
https://issues.apache.org/jira/browse/DRILL-4971 On Fri, Nov 11, 2016 at 10:53 AM, rahul challapalli <challapallira...@gmail.com> wrote: > This is a bug and its weird that changing the literal in the condition > makes it work. Can you go ahead and raise a jira for the same? > > On Thu, Nov 10, 2016 at 10:58 AM, Josson Paul <jossonp...@gmail.com> wrote: > >> Hi, >> >> My query is below >> >> select MIN(case when (CMP__acIds like '%6%') then A__ln__intrRt else >> null end) acID2,MIN(case when (A__ln__intrRt > 4.0) then 1 else null >> end) acID1,MIN(case when (A__ln__intrRt > 4.0) and CMP__acIds like >> '%6%' then 1 else null end) acID3 from <table name> >> >> >> The above query returns >> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: >> CompileException: Line 151, Column 22: Statement "break AndOP0" is not >> enclosed by a breakable statement with label "AndOP0" Fragment 1:0 >> >> I am using drill 1.8 >> >> If I make different values for A__ln__intrRt greater than condition, then >> the query works. If both values are same, the query gives above error. >> Currently as you see in the query, both have 4.0 as values. Another way to >> make this query works is to remove one of the select field >> -- >> Thanks >> Josson >>
