hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-8462) CBO duplicates columns
Date Tue, 14 Oct 2014 23:17:33 GMT

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

Sergey Shelukhin updated HIVE-8462:
-----------------------------------
    Component/s: CBO

> CBO duplicates columns
> ----------------------
>
>                 Key: HIVE-8462
>                 URL: https://issues.apache.org/jira/browse/HIVE-8462
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>            Priority: Critical
>
> {noformat}
> select *, rank() over(partition by key order by value) as rr from src1
> {noformat}
> Original plan appears to be incorrect:
> {noformat}
> HiveProjectRel(key=[$0], value=[$1], (tok_function rank (tok_windowspec (tok_partitioningspec
(tok_distributeby (tok_table_or_col key)) (tok_orderby (tok_tabsortcolnameasc (tok_table_or_col
value))))))=[$5], rr=[$5])
>   HiveProjectRel(key=[$0], value=[$1], block__offset__inside__file=[$2], input__file__name=[$3],
row__id=[$4], (tok_function rank (tok_windowspec (tok_partitioningspec (tok_distributeby (tok_table_or_col
key)) (tok_orderby (tok_tabsortcolnameasc (tok_table_or_col value))))))=[rank() OVER (PARTITION
BY $0 ORDER BY $1 ROWS BETWEEN 2147483647 FOLLOWING AND 2147483647 PRECEDING)])
>     HiveTableScanRel(table=[[default.src1]])
> {noformat}
> and final AST has {noformat}
>          TOK_SELEXPR
>             .
>                TOK_TABLE_OR_COL
>                   $hdt$_0
>                (tok_function rank (tok_windowspec (tok_partitioningspec (tok_distributeby
(tok_table_or_col key)) (tok_orderby (tok_tabsortcolnameasc (tok_table_or_col value))))))
>             (tok_function rank (tok_windowspec (tok_partitioningspec (tok_distributeby
(tok_table_or_col key)) (tok_orderby (tok_tabsortcolnameasc (tok_table_or_col value))))))
>          TOK_SELEXPR
>             .
>                TOK_TABLE_OR_COL
>                   $hdt$_0
>                (tok_function rank (tok_windowspec (tok_partitioningspec (tok_distributeby
(tok_table_or_col key)) (tok_orderby (tok_tabsortcolnameasc (tok_table_or_col value))))))
>             rr
> {noformat}



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

Mime
View raw message