[
https://issues.apache.org/jira/browse/HIVE-13339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gopal V updated HIVE-13339:
---------------------------
Description:
{code}
016-03-23T03:05:43,751 INFO [8fc926f7-721f-4bef-b4d3-60da6a6884f9 main]:
physical.Vectorizer (Vectorizer.java:process(910)) - MapWork Operator: SEL
could not be vectorized.
2016-03-23T03:05:43,751 INFO [8fc926f7-721f-4bef-b4d3-60da6a6884f9 main]:
physical.Vectorizer (Vectorizer.java:validateSelectOperator(1392)) - Cannot
vectorize select expression: GenericUDFBetween(Const boolean false,
Column[ss_sold_time_sk], Const int 1, Const int 2)
{code}
{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}
was:
{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}
> 016-03-23T03:05:43,751 INFO [8fc926f7-721f-4bef-b4d3-60da6a6884f9 main]:
> physical.Vectorizer (Vectorizer.java:process(910)) - MapWork Operator: SEL
> could not be vectorized.
> 2016-03-23T03:05:43,751 INFO [8fc926f7-721f-4bef-b4d3-60da6a6884f9 main]:
> physical.Vectorizer (Vectorizer.java:validateSelectOperator(1392)) - Cannot
> vectorize select expression: GenericUDFBetween(Const boolean false,
> Column[ss_sold_time_sk], Const int 1, Const int 2)
> {code}
> {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)
