hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-8145) CBO: bail from Optiq planning if a Select list contains multiple references to the same name
Date Tue, 16 Sep 2014 20:58:36 GMT

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

Ashutosh Chauhan commented on HIVE-8145:
----------------------------------------

+1

> CBO: bail from Optiq planning if a Select list contains multiple references to the same
name
> --------------------------------------------------------------------------------------------
>
>                 Key: HIVE-8145
>                 URL: https://issues.apache.org/jira/browse/HIVE-8145
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO
>            Reporter: Harish Butani
>            Assignee: Harish Butani
>         Attachments: HIVE-8145.1.patch
>
>
> Optiq explicitly disallows this:
> {code}
> select x, x from t1
> {code}
> This is allowed in Hive (and also in mysql). Will check in Postgres. For now bailing
from Optiq planning if we see this. Will file an Optiq issue. 



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

Mime
View raw message