[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Carl Steinbach (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Carl Steinbach updated HIVE-2827:
-

  Resolution: Fixed
Hadoop Flags: Reviewed
  Status: Resolved  (was: Patch Available)

Committed to trunk. Thanks Navis!

 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Fix For: 0.9.0

 Attachments: HIVE-2827.D1971.1.patch, HIVE-2827.D1971.2.patch, 
 HIVE-2827.D1971.3.patch, HIVE-2827.D1971.4.patch, HIVE-2827.D1971.5.patch, 
 HIVE-2827.D1971.6.patch, HIVE-2827.D1971.7.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Phabricator (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-2827:
--

Attachment: HIVE-2827.D1971.7.patch

navis updated the revision HIVE-2827 [jira] Implement nullsafe equi-join.
Reviewers: JIRA, cwsteinbach

  Removed not-used error message

REVISION DETAIL
  https://reviews.facebook.net/D1971

AFFECTED FILES
  data/files/in8.txt
  data/files/in9.txt
  ql/src/java/org/apache/hadoop/hive/ql/exec/AbstractMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/CommonJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/JoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/MapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/SMBMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/AbstractMapJoinKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinDoubleKeys.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinObjectKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinSingleKey.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/MapJoinProcessor.java
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/GenMRSkewJoinProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/QBJoinTree.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/JoinDesc.java
  ql/src/test/queries/clientpositive/join_nullsafe.q
  ql/src/test/results/clientpositive/join_nullsafe.q.out
  ql/src/test/results/compiler/plan/join1.q.xml
  ql/src/test/results/compiler/plan/join2.q.xml
  ql/src/test/results/compiler/plan/join3.q.xml
  ql/src/test/results/compiler/plan/join4.q.xml
  ql/src/test/results/compiler/plan/join5.q.xml
  ql/src/test/results/compiler/plan/join6.q.xml
  ql/src/test/results/compiler/plan/join7.q.xml
  ql/src/test/results/compiler/plan/join8.q.xml
  serde/src/java/org/apache/hadoop/hive/serde2/SerDeUtils.java


 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2827.D1971.1.patch, HIVE-2827.D1971.2.patch, 
 HIVE-2827.D1971.3.patch, HIVE-2827.D1971.4.patch, HIVE-2827.D1971.5.patch, 
 HIVE-2827.D1971.6.patch, HIVE-2827.D1971.7.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Navis (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Navis updated HIVE-2827:


Fix Version/s: 0.9.0
   Status: Patch Available  (was: Open)

 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Fix For: 0.9.0

 Attachments: HIVE-2827.D1971.1.patch, HIVE-2827.D1971.2.patch, 
 HIVE-2827.D1971.3.patch, HIVE-2827.D1971.4.patch, HIVE-2827.D1971.5.patch, 
 HIVE-2827.D1971.6.patch, HIVE-2827.D1971.7.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Carl Steinbach (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Carl Steinbach updated HIVE-2827:
-

Status: Open  (was: Patch Available)

 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2827.D1971.1.patch, HIVE-2827.D1971.2.patch, 
 HIVE-2827.D1971.3.patch, HIVE-2827.D1971.4.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Phabricator (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-2827:
--

Attachment: HIVE-2827.D1971.4.patch

navis updated the revision HIVE-2827 [jira] Implement nullsafe equi-join.
Reviewers: JIRA

  Rebased on HIVE-2810

REVISION DETAIL
  https://reviews.facebook.net/D1971

AFFECTED FILES
  common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
  data/files/in8.txt
  data/files/in9.txt
  ql/src/java/org/apache/hadoop/hive/ql/exec/AbstractMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/CommonJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/JoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/MapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/SMBMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/AbstractMapJoinKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinDoubleKeys.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinObjectKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinSingleKey.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/MapJoinProcessor.java
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/GenMRSkewJoinProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/ErrorMsg.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/QBJoinTree.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/JoinDesc.java
  ql/src/test/queries/clientpositive/join_nullsafe.q
  ql/src/test/results/clientpositive/join_nullsafe.q.out
  ql/src/test/results/compiler/plan/join1.q.xml
  ql/src/test/results/compiler/plan/join2.q.xml
  ql/src/test/results/compiler/plan/join3.q.xml
  ql/src/test/results/compiler/plan/join4.q.xml
  ql/src/test/results/compiler/plan/join5.q.xml
  ql/src/test/results/compiler/plan/join6.q.xml
  ql/src/test/results/compiler/plan/join7.q.xml
  ql/src/test/results/compiler/plan/join8.q.xml
  serde/src/java/org/apache/hadoop/hive/serde2/SerDeUtils.java


 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2827.D1971.1.patch, HIVE-2827.D1971.2.patch, 
 HIVE-2827.D1971.3.patch, HIVE-2827.D1971.4.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Navis (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Navis updated HIVE-2827:


Status: Patch Available  (was: Open)

Passed all tests.

 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2827.D1971.1.patch, HIVE-2827.D1971.2.patch, 
 HIVE-2827.D1971.3.patch, HIVE-2827.D1971.4.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Phabricator (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-2827:
--

Attachment: HIVE-2827.D1971.1.patch

navis requested code review of HIVE-2827 [jira] Implement nullsafe equi-join.
Reviewers: JIRA

  DPAL-873 Implement nullsafe equi-join

  was part of HIVE-2810, but separated because it affected more classes than 
expected.

  SELECT * FROM a JOIN b ON a.key = b.key

TEST PLAN
  EMPTY

REVISION DETAIL
  https://reviews.facebook.net/D1971

AFFECTED FILES
  common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
  data/files/in8.txt
  data/files/in9.txt
  ql/src/java/org/apache/hadoop/hive/ql/exec/AbstractMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/CommonJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/ConditionalTask.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/JoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/MapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/SMBMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/AbstractMapJoinKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinDoubleKeys.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinObjectKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinSingleKey.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/MapJoinProcessor.java
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/GenMRSkewJoinProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/ErrorMsg.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/ParseDriver.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/QBJoinTree.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/JoinDesc.java
  ql/src/test/queries/clientpositive/join_nullsafe.q
  ql/src/test/results/clientpositive/join_nullsafe.q.out
  serde/src/java/org/apache/hadoop/hive/serde2/SerDeUtils.java

MANAGE HERALD DIFFERENTIAL RULES
  https://reviews.facebook.net/herald/view/differential/

WHY DID I GET THIS EMAIL?
  https://reviews.facebook.net/herald/transcript/4185/

Tip: use the X-Herald-Rules header to filter Herald messages in your client.


 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2827.D1971.1.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Phabricator (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-2827:
--

Attachment: HIVE-2827.D1971.2.patch

navis updated the revision HIVE-2827 [jira] Implement nullsafe equi-join.
Reviewers: JIRA

  Removed debugging message

REVISION DETAIL
  https://reviews.facebook.net/D1971

AFFECTED FILES
  common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
  data/files/in8.txt
  data/files/in9.txt
  ql/src/java/org/apache/hadoop/hive/ql/exec/AbstractMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/CommonJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/JoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/MapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/SMBMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/AbstractMapJoinKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinDoubleKeys.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinObjectKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinSingleKey.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/MapJoinProcessor.java
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/GenMRSkewJoinProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/ErrorMsg.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/ParseDriver.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/QBJoinTree.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/JoinDesc.java
  ql/src/test/queries/clientpositive/join_nullsafe.q
  ql/src/test/results/clientpositive/join_nullsafe.q.out
  serde/src/java/org/apache/hadoop/hive/serde2/SerDeUtils.java


 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2827.D1971.1.patch, HIVE-2827.D1971.2.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-2827) Implement nullsafe equi-join

[Phabricator (Updated) (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HIVE-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-2827:
--

Attachment: HIVE-2827.D1971.3.patch

navis updated the revision HIVE-2827 [jira] Implement nullsafe equi-join.
Reviewers: JIRA

  Fix test failures (uniquejoin.q, etc.)

REVISION DETAIL
  https://reviews.facebook.net/D1971

AFFECTED FILES
  common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
  data/files/in8.txt
  data/files/in9.txt
  ql/src/java/org/apache/hadoop/hive/ql/exec/AbstractMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/CommonJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/JoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/MapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/SMBMapJoinOperator.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/AbstractMapJoinKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinDoubleKeys.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinObjectKey.java
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinSingleKey.java
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/MapJoinProcessor.java
  
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/GenMRSkewJoinProcessor.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/ErrorMsg.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/ParseDriver.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/QBJoinTree.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/java/org/apache/hadoop/hive/ql/plan/JoinDesc.java
  ql/src/test/queries/clientpositive/join_nullsafe.q
  ql/src/test/results/clientpositive/join_nullsafe.q.out
  ql/src/test/results/compiler/plan/join1.q.xml
  ql/src/test/results/compiler/plan/join2.q.xml
  ql/src/test/results/compiler/plan/join3.q.xml
  ql/src/test/results/compiler/plan/join4.q.xml
  ql/src/test/results/compiler/plan/join5.q.xml
  ql/src/test/results/compiler/plan/join6.q.xml
  ql/src/test/results/compiler/plan/join7.q.xml
  ql/src/test/results/compiler/plan/join8.q.xml
  serde/src/java/org/apache/hadoop/hive/serde2/SerDeUtils.java


 Implement nullsafe equi-join
 

 Key: HIVE-2827
 URL: https://issues.apache.org/jira/browse/HIVE-2827
 Project: Hive
  Issue Type: Improvement
  Components: Query Processor
 Environment: ubuntu 10.04
Reporter: Navis
Assignee: Navis
Priority: Minor
 Attachments: HIVE-2827.D1971.1.patch, HIVE-2827.D1971.2.patch, 
 HIVE-2827.D1971.3.patch


 was part of HIVE-2810, but separated because it affected more classes than 
 expected.
 {noformat}
 SELECT * FROM a JOIN b ON a.key = b.key
 {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira