Satoshi Iijima created HIVE-16241:
-------------------------------------
Summary: When PTF, explode AND join are used together, result is
duplicated
Key: HIVE-16241
URL: https://issues.apache.org/jira/browse/HIVE-16241
Project: Hive
Issue Type: Bug
Components: PTF-Windowing, Query Processor
Affects Versions: 2.1.0
Reporter: Satoshi Iijima
Example:
{code}
CREATE TABLE test (
key STRING,
type STRING,
value INT
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
LOAD DATA LOCAL INPATH '/tmp/test.gz' OVERWRITE INTO TABLE test;
SELECT * FROM test;
A type1 30000
B type2 20000
C type2 5000
SELECT l.*
FROM (
SELECT * FROM test LATERAL VIEW explode(ARRAY(key)) e AS dammy
) l JOIN (
SELECT key, rank() OVER (PARTITION BY type ORDER BY value DESC) rank
FROM test
) r ON l.key = r.key
A type1 30000 A
A type1 30000 A
B type2 20000 B
B type2 20000 B
C type2 5000 C
C type2 5000 C
{code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)