drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josson Paul <jossonp...@gmail.com>
Subject SYSTEM ERROR: CompileException
Date Thu, 10 Nov 2016 18:58:39 GMT

  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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message