[jira] [Resolved] (HIVE-8145) CBO: bail from Optiq planning if a Select list contains multiple references to the same name

["Harish Butani (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-8145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Harish Butani resolved HIVE-8145.
---------------------------------
    Resolution: Fixed

Committed to CBO branch. Thanks for reviewing [~ashutoshc]

> 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)