hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laljo John Pullokkaran (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10400) CBO (Calcite Return Path): Exception when column name contains dot or colon characters
Date Mon, 20 Apr 2015 18:45:58 GMT

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

Laljo John Pullokkaran commented on HIVE-10400:
-----------------------------------------------

+1

> CBO (Calcite Return Path): Exception when column name contains dot or colon characters
> --------------------------------------------------------------------------------------
>
>                 Key: HIVE-10400
>                 URL: https://issues.apache.org/jira/browse/HIVE-10400
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>             Fix For: 1.2.0
>
>         Attachments: HIVE-10400.patch
>
>
> If return path is on, this query produces the problem:
> {noformat}
> select cbo_t3.c_int, c, count(*)
> from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1
> where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)
> group by c_float, cbo_t1.c_int, key order by a) cbo_t1
> join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2
> where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)
> group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc) cbo_t2 on cbo_t1.a=p
> join cbo_t3 on cbo_t1.a=key
> where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0)
> group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c;
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message