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-16310) Get the output operators of Reducesink when vectorization is on
Date Tue, 28 Mar 2017 05:28:41 GMT

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

Pengcheng Xiong updated HIVE-16310:
-----------------------------------
    Description: 
{code}
set hive.compute.query.using.stats=false;
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
set hive.optimize.ppd=true;
set hive.ppd.remove.duplicatefilters=true;
set hive.tez.dynamic.partition.pruning=true;
set hive.tez.dynamic.semijoin.reduction=true;
set hive.optimize.metadataonly=false;
set hive.optimize.index.filter=true;
set hive.tez.bigtable.minsize.semijoin.reduction=1;
set hive.tez.min.bloom.filter.entries=1;
set hive.tez.dynamic.semijoin.reduction.threshold=-999999999999;
set hive.auto.convert.join=false;

set hive.vectorized.execution.enabled=true;

CREATE TABLE `table_1`(
  `bigint_col_7` bigint,
  `decimal2016_col_26` decimal(20,16),
  `tinyint_col_3` tinyint,
  `decimal2612_col_77` decimal(26,12),
  `timestamp_col_9` timestamp);

CREATE TABLE `table_18`(
  `tinyint_col_15` tinyint,
  `decimal2709_col_9` decimal(27,9),
  `tinyint_col_20` tinyint,
  `smallint_col_19` smallint,
  `decimal1911_col_16` decimal(19,11),
  `timestamp_col_18` timestamp);

explain formatted select t2.tinyint_col_20 from table_1 t1 join table_18 t2 on t1.tinyint_col_3
= t2.tinyint_col_20 where t2.tinyint_col_20 > 3
;

drop table table_1;
drop table table_18;
{code}

> Get the output operators of Reducesink when vectorization is on
> ---------------------------------------------------------------
>
>                 Key: HIVE-16310
>                 URL: https://issues.apache.org/jira/browse/HIVE-16310
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>
> {code}
> set hive.compute.query.using.stats=false;
> set hive.mapred.mode=nonstrict;
> set hive.explain.user=false;
> set hive.optimize.ppd=true;
> set hive.ppd.remove.duplicatefilters=true;
> set hive.tez.dynamic.partition.pruning=true;
> set hive.tez.dynamic.semijoin.reduction=true;
> set hive.optimize.metadataonly=false;
> set hive.optimize.index.filter=true;
> set hive.tez.bigtable.minsize.semijoin.reduction=1;
> set hive.tez.min.bloom.filter.entries=1;
> set hive.tez.dynamic.semijoin.reduction.threshold=-999999999999;
> set hive.auto.convert.join=false;
> set hive.vectorized.execution.enabled=true;
> CREATE TABLE `table_1`(
>   `bigint_col_7` bigint,
>   `decimal2016_col_26` decimal(20,16),
>   `tinyint_col_3` tinyint,
>   `decimal2612_col_77` decimal(26,12),
>   `timestamp_col_9` timestamp);
> CREATE TABLE `table_18`(
>   `tinyint_col_15` tinyint,
>   `decimal2709_col_9` decimal(27,9),
>   `tinyint_col_20` tinyint,
>   `smallint_col_19` smallint,
>   `decimal1911_col_16` decimal(19,11),
>   `timestamp_col_18` timestamp);
> explain formatted select t2.tinyint_col_20 from table_1 t1 join table_18 t2 on t1.tinyint_col_3
= t2.tinyint_col_20 where t2.tinyint_col_20 > 3
> ;
> drop table table_1;
> drop table table_18;
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message