You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Vineet Garg (JIRA)" <ji...@apache.org> on 2016/08/11 21:11:20 UTC
[jira] [Created] (HIVE-14522) CBO: Calcite Operator To Hive
Operator(Calcite Return Path): Fix test failure for auto_join_filters
Vineet Garg created HIVE-14522:
----------------------------------
Summary: CBO: Calcite Operator To Hive Operator(Calcite Return Path): Fix test failure for auto_join_filters
Key: HIVE-14522
URL: https://issues.apache.org/jira/browse/HIVE-14522
Project: Hive
Issue Type: Sub-task
Components: CBO
Reporter: Vineet Garg
Assignee: Vineet Garg
{code}
CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS;
CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS;
LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input1;
LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input1;
LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input2;
LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input2;
SET hive.optimize.bucketmapjoin = true;
SET hive.optimize.bucketmapjoin.sortedmerge = true;
SET hive.input.format = org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat;
SET hive.outerjoin.supports.filters = false;
{code}
{code} SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value; {code}
{code} Expected result: 3078400 Actual result: 4937935 {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)