hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-20976) JDBC queries containing joins gives wrong results
Date Wed, 28 Nov 2018 00:47:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-20976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16701229#comment-16701229
] 

Jesus Camacho Rodriguez commented on HIVE-20976:
------------------------------------------------

[~ashutoshc], could you take a look? Thanks

> JDBC queries containing joins gives wrong results
> -------------------------------------------------
>
>                 Key: HIVE-20976
>                 URL: https://issues.apache.org/jira/browse/HIVE-20976
>             Project: Hive
>          Issue Type: Bug
>          Components: JDBC, StorageHandler
>            Reporter: Nishant Bangarwa
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>         Attachments: HIVE-20976.patch
>
>
> JDBC queries that have joins against self table gives wrong results. 
> e.g. 
> {code} 
> SELECT
> username AS `username`,
> SUM(double1) AS `sum_double1`
> FROM
> jdbc_table_with_nulls `tbl1`
>   JOIN (
>     SELECT
>     username AS `username`,
>     SUM(double1) AS `sum_double2`
>     FROM jdbc_table_with_nulls
>     GROUP BY `username`
>     ORDER BY `sum_double2`
>     DESC  LIMIT 10
>   )
>   `tbl2`
>     ON (`tbl1`.`username` = `tbl2`.`username`)
> GROUP BY `tbl1`.`username`;
> {code} 
> Similar to HIVE-19762.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message