[HIVE-1903] Can't join HBase tables if one's name is the beginning of the other

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: HBase Handler
• Hadoop Flags: Reviewed
• Assignee: John Sichi
• Reporter: Jean-Daniel Cryans
• Created: 07/Jan/11 23:50
• Updated: 24/Jun/15 17:42
• Resolved: 11/Jan/11 07:00

Description

I tried joining two tables, let's call them "table" and "table_a", but I'm seeing an array of errors such as this:

java.lang.IndexOutOfBoundsException: Index: 3, Size: 3
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getRecordReader(HiveHBaseTableInputFormat.java:118)
	at org.apache.hadoop.hive.ql.io.HiveInputFormat.getRecordReader(HiveInputFormat.java:231)

The reason is that HiveInputFormat.pushProjectionsAndFilters matches the aliases with startsWith so in my case the mappers for "table_a" were getting the columns from "table" as well as its own (and since it had less column, it was trying to get one too far in the array).

I don't know if just changing it to "equals" fill fix it, my guess is it won't, since it may break RCFiles.

Issue Links

• is related to: HIVE-11097 HiveInputFormat uses String.startsWith to compare splitPath and PathToAliases