hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pengcheng Xiong (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-10804) CBO: Calcite Operator To Hive Operator (Calcite Return Path): optimizer for limit 0 does not work
Date Tue, 26 May 2015 23:31:18 GMT

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

Pengcheng Xiong updated HIVE-10804:
-----------------------------------
    Attachment: HIVE-10804.01.patch

> CBO: Calcite Operator To Hive Operator (Calcite Return Path): optimizer for limit 0 does
not work
> -------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-10804
>                 URL: https://issues.apache.org/jira/browse/HIVE-10804
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>         Attachments: HIVE-10804.01.patch
>
>
> {code}
> explain
> select key,value from src order by key limit 0
> POSTHOOK: type: QUERY
> STAGE DEPENDENCIES:
>   Stage-1 is a root stage
>   Stage-0 depends on stages: Stage-1
> STAGE PLANS:
>   Stage: Stage-1
>     Map Reduce
>       Map Operator Tree:
>           TableScan
>             alias: src
>             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
>             Select Operator
>               expressions: key (type: string), value (type: string)
>               outputColumnNames: key, value
>               Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column
stats: NONE
>               Reduce Output Operator
>                 key expressions: key (type: string)
>                 sort order: +
>                 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column
stats: NONE
>                 value expressions: value (type: string)
>       Reduce Operator Tree:
>         Select Operator
>           expressions: KEY.reducesinkkey0 (type: string), VALUE.value (type: string)
>           outputColumnNames: key, value
>           Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
>           Limit
>             Number of rows: 0
>             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
>             File Output Operator
>               compressed: false
>               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
>               table:
>                   input format: org.apache.hadoop.mapred.TextInputFormat
>                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
>                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
> {code}



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

Mime
View raw message