[ 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.