[
https://issues.apache.org/jira/browse/HIVE-20976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-20976:
-------------------------------------------
Description:
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}
was:
Druid queries that have joins against self table gives wrong results.
e.g.
{code}
SELECT
username AS `username`,
SUM(double1) AS `sum_double1`
FROM
druid_table_with_nulls `tbl1`
JOIN (
SELECT
username AS `username`,
SUM(double1) AS `sum_double2`
FROM druid_table_with_nulls
GROUP BY `username`
ORDER BY `sum_double2`
DESC LIMIT 10
)
`tbl2`
ON (`tbl1`.`username` = `tbl2`.`username`)
GROUP BY `tbl1`.`username`;
{code}
In this case one of the queries is a druid scan query and other is groupBy
query.
During planning, the properties of these queries are set to the tableDesc and
serdeInfo, while setting the map work, we overwrite the properties from the
properties present in serdeInfo, this causes the scan query results to be
deserialized using wrong column names and results in Null values.
> 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
>
> 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}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
