You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org> on 2010/08/18 11:23:17 UTC
[jira] Created: (HIVE-1552) Nulls are not handled in Sort Merge
MapJoin
Nulls are not handled in Sort Merge MapJoin
-------------------------------------------
Key: HIVE-1552
URL: https://issues.apache.org/jira/browse/HIVE-1552
Project: Hadoop Hive
Issue Type: Bug
Components: Query Processor
Reporter: Amareshwari Sriramadasu
Assignee: Amareshwari Sriramadasu
If SMBMAPJoinOperator finds null keys in Join it fails with NullPointerException :
{noformat}
Caused by: java.lang.NullPointerException
at org.apache.hadoop.io.IntWritable.compareTo(IntWritable.java:60)
at org.apache.hadoop.io.WritableComparator.compare(WritableComparator.java:115)
at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.compareKeys(SMBMapJoinOperator.java:389)
at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.processKey(SMBMapJoinOperator.java:438)
at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.processOp(SMBMapJoinOperator.java:205)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:458)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:698)
at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:45)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:458)
at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.fetchOneRow(SMBMapJoinOperator.java:479)
... 17 more
{noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1552) Nulls are not handled in Sort Merge
MapJoin
Posted by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12899811#action_12899811 ]
Amareshwari Sriramadasu commented on HIVE-1552:
-----------------------------------------------
Are NULL values allowed for a sorted column?
I think that the answer is Yes, because insert/load does not complain about null values.
> Nulls are not handled in Sort Merge MapJoin
> -------------------------------------------
>
> Key: HIVE-1552
> URL: https://issues.apache.org/jira/browse/HIVE-1552
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
>
> If SMBMAPJoinOperator finds null keys in Join it fails with NullPointerException :
> {noformat}
> Caused by: java.lang.NullPointerException
> at org.apache.hadoop.io.IntWritable.compareTo(IntWritable.java:60)
> at org.apache.hadoop.io.WritableComparator.compare(WritableComparator.java:115)
> at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.compareKeys(SMBMapJoinOperator.java:389)
> at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.processKey(SMBMapJoinOperator.java:438)
> at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.processOp(SMBMapJoinOperator.java:205)
> at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:458)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:698)
> at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:45)
> at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:458)
> at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.fetchOneRow(SMBMapJoinOperator.java:479)
> ... 17 more
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (HIVE-1552) Nulls are not handled in Sort Merge
MapJoin
Posted by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amareshwari Sriramadasu resolved HIVE-1552.
-------------------------------------------
Resolution: Duplicate
Being fixed as part of HIVE-741
> Nulls are not handled in Sort Merge MapJoin
> -------------------------------------------
>
> Key: HIVE-1552
> URL: https://issues.apache.org/jira/browse/HIVE-1552
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
>
> If SMBMAPJoinOperator finds null keys in Join it fails with NullPointerException :
> {noformat}
> Caused by: java.lang.NullPointerException
> at org.apache.hadoop.io.IntWritable.compareTo(IntWritable.java:60)
> at org.apache.hadoop.io.WritableComparator.compare(WritableComparator.java:115)
> at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.compareKeys(SMBMapJoinOperator.java:389)
> at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.processKey(SMBMapJoinOperator.java:438)
> at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.processOp(SMBMapJoinOperator.java:205)
> at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:458)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:698)
> at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:45)
> at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:458)
> at org.apache.hadoop.hive.ql.exec.SMBMapJoinOperator.fetchOneRow(SMBMapJoinOperator.java:479)
> ... 17 more
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.