hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aswathy Chellammal Sreekumar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-15919) Row count mismatch for count * query
Date Tue, 14 Feb 2017 22:16:41 GMT
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)

Mime
View raw message