drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rahul challapalli <challapallira...@gmail.com>
Subject Re: SYSTEM ERROR: CompileException
Date Fri, 11 Nov 2016 18:53:09 GMT
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 <jossonpaul@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
>

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