drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-323) Drill expression parser incorrectly handles expressions that involve math functions with more than 2 inputs
Date Thu, 12 Dec 2013 20:31:08 GMT

    [ https://issues.apache.org/jira/browse/DRILL-323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13846706#comment-13846706
] 

Mehant Baid commented on DRILL-323:
-----------------------------------

As a workaround we need to set the precedence for expression evaluation explicitly. For example
we need to change the project operator to the following for the above plan to work

{
pop : "project",
@id : 2,
exprs : [
{ ref : "output.EXPR$0", expr : " ((blue - blue) + 1) " }
],
child : 1
},


The same query would work if submitted via sqlline, reason being that Optiq surrounds the
expression with appropriate braces while generating the logical plan which is propagated to
the physical plan. 

> Drill expression parser incorrectly handles expressions that involve math functions with
more than 2 inputs
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-323
>                 URL: https://issues.apache.org/jira/browse/DRILL-323
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Mehant Baid
>            Assignee: Mehant Baid
>
> While executing the following plan:
> {
>   head : {
>     version : 1,
>     generator : {
>       type : "optiq",
>       info : "na"
>     },
>     type : "APACHE_DRILL_PHYSICAL"
>   },
>          graph:[
>          {
>              @id:1,
>              pop:"mock-scan",
>              url: "http://apache.org",
>              entries:[
>                  {records: 1, types: [
>                    {name: "blue", type: "BIGINT", mode: "REQUIRED"}
>                  ]}
>              ]
>          }, {
>     pop : "project",
>     @id : 2,
>     exprs : [ {
>       ref : "output.EXPR$0",
>       expr : " blue - blue + 1 "
>     } ],
>     child : 1
>   }, {
>     pop : "screen",
>     @id : 3,
>     child : 2
>   } ]
> }
> we will hit the following error: "Failure while running fragment. < UnsupportedOperationException:[
Missing function implementation: [add(BIGINT-REQUIRED, BIGINT-REQUIRED, BIGINT-REQUIRED)]
]"



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

Mime
View raw message