Aswathy Chellammal Sreekumar created HIVE-15919:
---------------------------------------------------
Summary: Row count mismatch for count * query
Key: HIVE-15919
URL: https://issues.apache.org/jira/browse/HIVE-15919
Project: Hive
Issue Type: Bug
Components: HiveServer2
Reporter: Aswathy Chellammal Sreekumar
Attachments: table_14.q, table_6.q
The following query is returning different output when run against hive and
postgres.
Query:
SELECT COUNT (*)
FROM
(SELECT LAG(COALESCE(t2.int_col_14, t1.int_col_80),22) OVER (ORDER BY
t1.tinyint_col_52 DESC) AS int_col
FROM table_6 t1
INNER JOIN table_14 t2 ON ((t2.decimal0101_col_55) = (t1.decimal0101_col_9)))
AS FOO;
>From hive: 0
>From postgres: 66903279
Attaching ddl and data files for the tables.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
