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
