drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jinfeng Ni <...@apache.org>
Subject Re: SYSTEM ERROR: CompileException
Date Fri, 11 Nov 2016 19:29:19 GMT
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
<challapallirahul@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 <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
View raw message