Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 28 Mar 2017 05:31:41 +0000 (UTC)
From: "Pengcheng Xiong (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13059631.1490678797000.139837.1490679101555@Atlassian.JIRA>
In-Reply-To: <JIRA.13059631.1490678797000@Atlassian.JIRA>
References: <JIRA.13059631.1490678797000@Atlassian.JIRA> <JIRA.13059631.1490678797039@jira-lw-us.apache.org>
Subject: [jira] [Commented] (HIVE-16310) Get the output operators of
 Reducesink when vectorization is on
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 28 Mar 2017 05:31:45 -0000


    [ https://issues.apache.org/jira/browse/HIVE-16310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15944557#comment-15944557 ] 

Pengcheng Xiong commented on HIVE-16310:
----------------------------------------

[~ashutoshc], could u take a look? Thanks.

> 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)