[
https://issues.apache.org/jira/browse/HIVE-8159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14137429#comment-14137429
]
Harish Butani edited comment on HIVE-8159 at 9/17/14 3:51 PM:
--------------------------------------------------------------
[~ashutoshc] I have filed OPTIQ-411. [~julianhyde] pointed out that this is
supported in Optiq at the AST level, but not at the RelNode level.
He suggested we look at how this is done in Optiq and do the same in Hive when
we go from Hive AST to Optiq RelNodes
was (Author: rhbutani):
[~ashutoshc] I have filed OPTIQ-411. [~julianhyde] pointed point that this is
supported in Optiq at the AST level, but not at the RelNode level.
He suggested we look at how this is done in Optiq and do the same in Hive when
we go from Hive AST to Optiq RelNodes
> CBO: bail from Optiq planning if a Select list contains multiple references
> to the same name
> --------------------------------------------------------------------------------------------
>
> Key: HIVE-8159
> URL: https://issues.apache.org/jira/browse/HIVE-8159
> Project: Hive
> Issue Type: Sub-task
> Components: CBO
> Reporter: Ashutosh Chauhan
> Assignee: Ashutosh Chauhan
> Fix For: 0.14.0
>
> Attachments: HIVE-8159.cbo.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)
