[
https://issues.apache.org/jira/browse/HIVE-15919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15870470#comment-15870470
]
Matt McCline commented on HIVE-15919:
-------------------------------------
I see. After adding the comparisons the list ought to be complete. Ok let's
proceed with this approach.
> 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
> Assignee: Jason Dere
> Attachments: HIVE-15919.1.patch, 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 files for the tables.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
