You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by Remus Rusanu <rr...@hortonworks.com> on 2017/04/19 11:12:22 UTC

Review Request 58531: HIVE-16317 CASE .. NULL in JOIN condition can trigger SemanticException

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/58531/
-----------------------------------------------------------

Review request for hive and Ashutosh Chauhan.


Repository: hive-git


Description
-------

Case TOK_NULL is not expected in join condition. Query 31, after Calcite 1.12, can push an expression like `CASE WHEN ... ELSE NULL END < CASE WHEN ... ELSE NULL END` from where into the join condition and trigger SemanticException.


Diffs
-----

  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 77fc35d 
  ql/src/test/results/clientpositive/perf/query31.q.out 4de6eb6 


Diff: https://reviews.apache.org/r/58531/diff/1/


Testing
-------


Thanks,

Remus Rusanu