You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Gopal V (JIRA)" <ji...@apache.org> on 2016/03/23 08:07:25 UTC

[jira] [Updated] (HIVE-13339) Vectorization: GenericUDFBetween in Projection mode

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

Gopal V updated HIVE-13339:
---------------------------
    Description: 
{code}
hive> set hive.explain.user=false;
hive> explain select ss_sold_time_sk between 1 and 2 from store_sales;
OK
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Tez
      DagId: gopal_20160323010940_4e7cdfe1-b1e2-4443-acff-fa83f8428bff:9
      DagName: 
      Vertices:
        Map 1 
            Map Operator Tree:
                TableScan
                  alias: store_sales
                  Statistics: Num rows: 575995635 Data size: 50918178412 Basic stats: COMPLETE Column stats: NONE
                  Select Operator
                    expressions: ss_sold_time_sk BETWEEN 1 AND 2 (type: boolean)
                    outputColumnNames: _col0
                    Statistics: Num rows: 575995635 Data size: 50918178412 Basic stats: COMPLETE Column stats: NONE
                    File Output Operator
                      compressed: false
                      Statistics: Num rows: 575995635 Data size: 50918178412 Basic stats: COMPLETE Column stats: NONE
                      table:
                          input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                          output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                          serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
            Execution mode: llap
            LLAP IO: no inputs

  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        ListSink

Time taken: 1.258 seconds, Fetched: 35 row(s)
{code}

> Vectorization: GenericUDFBetween in Projection mode 
> ----------------------------------------------------
>
>                 Key: HIVE-13339
>                 URL: https://issues.apache.org/jira/browse/HIVE-13339
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Gopal V
>
> {code}
> hive> set hive.explain.user=false;
> hive> explain select ss_sold_time_sk between 1 and 2 from store_sales;
> OK
> STAGE DEPENDENCIES:
>   Stage-1 is a root stage
>   Stage-0 depends on stages: Stage-1
> STAGE PLANS:
>   Stage: Stage-1
>     Tez
>       DagId: gopal_20160323010940_4e7cdfe1-b1e2-4443-acff-fa83f8428bff:9
>       DagName: 
>       Vertices:
>         Map 1 
>             Map Operator Tree:
>                 TableScan
>                   alias: store_sales
>                   Statistics: Num rows: 575995635 Data size: 50918178412 Basic stats: COMPLETE Column stats: NONE
>                   Select Operator
>                     expressions: ss_sold_time_sk BETWEEN 1 AND 2 (type: boolean)
>                     outputColumnNames: _col0
>                     Statistics: Num rows: 575995635 Data size: 50918178412 Basic stats: COMPLETE Column stats: NONE
>                     File Output Operator
>                       compressed: false
>                       Statistics: Num rows: 575995635 Data size: 50918178412 Basic stats: COMPLETE Column stats: NONE
>                       table:
>                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
>                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
>                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
>             Execution mode: llap
>             LLAP IO: no inputs
>   Stage: Stage-0
>     Fetch Operator
>       limit: -1
>       Processor Tree:
>         ListSink
> Time taken: 1.258 seconds, Fetched: 35 row(s)
> {code}



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