join on a subquery with a group by does not work
------------------------------------------------
Key: HIVE-168
URL: https://issues.apache.org/jira/browse/HIVE-168
Project: Hadoop Hive
Issue Type: Bug
Reporter: Namit Jain
Assignee: Namit Jain
SELECT a.key, a.value, b.key, b.value
FROM
(
SELECT src1.key as key, count(src1.value) AS value FROM src src1 group by
src1.key
) a
FULL OUTER JOIN
(
SELECT src2.key as key, count(distinct(src2.value)) AS value
FROM src1 src2 group by src2.key
) b
ON (a.key = b.key);
does not generate the plan correctly
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
