[
https://issues.apache.org/jira/browse/PHOENIX-1535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maryann Xue updated PHOENIX-1535:
---------------------------------
Attachment: 1535.patch
Moved getWrappedScanner() from ScanRegionObserver to BaseScanRegionObserver and
make GroupedAggregateRegionObserver and UngroupedAggregateRegionObserver both
use this method instead of using IndexUtil.wrapResultUsingOffset(). This allows
nesting different scanners in the correct order processing.
TODO: need to add plan check in the unit test and move table init logic to a
base class.
> Secondary local index casues Undefined column error with queries involving
> joins
> --------------------------------------------------------------------------------
>
> Key: PHOENIX-1535
> URL: https://issues.apache.org/jira/browse/PHOENIX-1535
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.2
> Environment: HBase 0.98.6; CDH-5.2.0-1.cdh5.2.0.p0.36
> Reporter: Joyce Lau
> Attachments: 1535.incomplete.patch, 1535.patch
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
