hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-15870) MM tables - parquet_join test fails
Date Fri, 10 Feb 2017 01:16:41 GMT
Sergey Shelukhin created HIVE-15870:
---------------------------------------

             Summary: MM tables - parquet_join test fails
                 Key: HIVE-15870
                 URL: https://issues.apache.org/jira/browse/HIVE-15870
             Project: Hive
          Issue Type: Bug
            Reporter: Sergey Shelukhin


Either of the single-join queries produces results, but not the last query.
Looking at MM logs, it looks like the inputs are read correctly. Must be something parquet-specific
w.r.t. multiple files in a table.
{noformat}
set hive.optimize.index.filter = true;
set hive.auto.convert.join=false;

CREATE TABLE tbl1(id INT) STORED AS PARQUET;
INSERT INTO tbl1 VALUES(1), (2);

CREATE TABLE tbl2(id INT, value STRING) STORED AS PARQUET;
INSERT INTO tbl2 VALUES(1, 'value1');
INSERT INTO tbl2 VALUES(1, 'value2');

select tbl1.id, t1.value
FROM tbl1
JOIN (SELECT * FROM tbl2 WHERE value='value2') t1 ON tbl1.id=t1.id;
select tbl1.id, t1.value
FROM tbl1
JOIN (SELECT * FROM tbl2 WHERE value='value1') t1 ON tbl1.id=t1.id;

select tbl1.id, t1.value, t2.value
FROM tbl1
JOIN (SELECT * FROM tbl2 WHERE value='value1') t1 ON tbl1.id=t1.id
JOIN (SELECT * FROM tbl2 WHERE value='value2') t2 ON tbl1.id=t2.id;
{noformat}



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

Mime
View raw message