[IMPALA-7039] Frontend HBase tests cannot tolerate HBase running on a different port

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 3.1.0
• Fix Version/s: Impala 3.1.0
• Component/s: Frontend
• Labels: broken-build
• Epic Color: ghx-label-4
• Assignee: Taras Bobrovytsky
• Reporter: Joe McDonnell
• Created: 15/May/18 23:41
• Updated: 29/May/18 19:14
• Resolved: 22/May/18 20:34

Description

When HBase doesn't get the same ports as usual, org.apache.impala.planner.PlannerTest.testHbase and org.apache.impala.planner.PlannerTest.testJoins fail with the following errors:

section SCANRANGELOCATIONS of query:
select * from functional_hbase.alltypessmall
where id < 5
Actual does not match expected result:
  HBASE KEYRANGE port=16020 <unbounded>:3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  HBASE KEYRANGE port=16022 3:7
  HBASE KEYRANGE port=16023 7:<unbounded>
NODE 0:

Expected:
  HBASE KEYRANGE port=16201 <unbounded>:3
  HBASE KEYRANGE port=16202 3:7
  HBASE KEYRANGE port=16203 7:<unbounded>
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where id = '5'
and tinyint_col = 5
Actual does not match expected result:
  HBASE KEYRANGE port=16022 5:5\0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 5:5\0
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where id > '5'
and tinyint_col = 5
Actual does not match expected result:
  HBASE KEYRANGE port=16022 5\0:7
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  HBASE KEYRANGE port=16023 7:<unbounded>
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 5\0:7
  HBASE KEYRANGE port=16203 7:<unbounded>
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where id >= '5'
and tinyint_col = 5
Actual does not match expected result:
  HBASE KEYRANGE port=16022 5:7
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  HBASE KEYRANGE port=16023 7:<unbounded>
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 5:7
  HBASE KEYRANGE port=16203 7:<unbounded>
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where id < '5'
and tinyint_col = 5
Actual does not match expected result:
  HBASE KEYRANGE port=16020 <unbounded>:3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  HBASE KEYRANGE port=16022 3:5
NODE 0:

Expected:
  HBASE KEYRANGE port=16201 <unbounded>:3
  HBASE KEYRANGE port=16202 3:5
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where id > '4' and id < '5'
and tinyint_col = 5
Actual does not match expected result:
  HBASE KEYRANGE port=16022 4\0:5
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 4\0:5
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where id >= '4' and id < '5'
and tinyint_col = 5
Actual does not match expected result:
  HBASE KEYRANGE port=16022 4:5
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 4:5
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where id > '4' and id <= '5'
and tinyint_col = 5
Actual does not match expected result:
  HBASE KEYRANGE port=16022 4\0:5\0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 4\0:5\0
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where id >= '4' and id <= '5'
and tinyint_col = 5
Actual does not match expected result:
  HBASE KEYRANGE port=16022 4:5\0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 4:5\0
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where string_col = '4' and tinyint_col = 5 and id >= '4' and id <= '5'
Actual does not match expected result:
  HBASE KEYRANGE port=16022 4:5\0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 4:5\0
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.stringids
where string_col = '4' and tinyint_col = 5
  and id >= concat('', '4') and id <= concat('5', '')
Actual does not match expected result:
  HBASE KEYRANGE port=16022 4:5\0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
NODE 0:

Expected:
  HBASE KEYRANGE port=16202 4:5\0
NODE 0:
section SCANRANGELOCATIONS of query:
select * from functional_hbase.alltypesagg
where bigint_col is not null and bool_col = true
Actual does not match expected result:
  HBASE KEYRANGE port=16020 <unbounded>:3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  HBASE KEYRANGE port=16022 3:7
  HBASE KEYRANGE port=16023 7:<unbounded>
NODE 0:

Expected:
  HBASE KEYRANGE port=16201 <unbounded>:3
  HBASE KEYRANGE port=16202 3:7
  HBASE KEYRANGE port=16203 7:<unbounded>
NODE 0: