Column pruner prunes essential columns in map join
--------------------------------------------------
Key: HIVE-1393
URL: https://issues.apache.org/jira/browse/HIVE-1393
Project: Hadoop Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.6.0
Reporter: Paul Yang
Run:
{code}
CREATE TABLE tmp_pyang_src2 (key STRING, value STRING);
INSERT OVERWRITE TABLE tmp_pyang_src2 SELECT key, value FROM src;
SELECT /*+ MAPJOIN(a) */ a.key, a.value
FROM tmp_pyang_src2 a JOIN src b ON a.key=b.key
LIMIT 10;
{code}
a.value will show up as null. Either removing the MAPJOIN hint or set
hive.optimize.cp=false; will produce the correct results.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
