[PHOENIX-1535] Secondary local index casues Undefined column error with queries involving joins

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2.0
• Fix Version/s: 4.3.0

Environment

HBase 0.98.6; CDH-5.2.0-1.cdh5.2.0.p0.36

• Assignee: Wei Xue
• Reporter: Joyce Lau
• Created: 17/Dec/14 00:46
• Updated: 21/Nov/15 02:18
• Resolved: 22/Dec/14 06:33

Description

Create 2 tables with a local index
create table tab1 (col1 bigint, col2 bigint, col3 bigint, constraint pk_tab1 primary key (col1));
create table tab2 (col1 bigint, col2 bigint, col3 bigint, constraint pk_tab1 primary key (col1));
create local index ind_tab1 on tab1(col2);

Executing a query with a condition on the local index column and select a column not in the index results in an error:
explain
select tab1.col3
from tab1 join tab2 on tab1.col1 = tab2.col1
where tab1.col2 = 1
=======
Error: ERROR 504 (42703): Undefined column. columnName=0:COL3
SQLState: 42703
ErrorCode: 504
=======

Select * is ok:
explain select tab1.* from tab1 where tab1.col2 = 1

If I drop the local index, the first query runs successfully.

Issue Links

• duplicates: PHOENIX-1087 Support joining back to data table from local index table for join queries

Sub-Tasks

• Reduce number of arguments for local index join fix: Resolved