Manoj Patrick created PHOENIX-3780:
--------------------------------------
Summary: Undefined Column Error while Using index hint
Key: PHOENIX-3780
URL: https://issues.apache.org/jira/browse/PHOENIX-3780
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.10.0
Reporter: Manoj Patrick
When I force an index with the index hint , I am getting an error. Is this a
known error ?
Error: ERROR 504 (42703): Undefined column. columnName=:REPORT_INSTANCE_ID
(state=42703,code=504)
Table Schema:
3 columns: ORGANIZATION_ID,REPORT_INSTANCE_ID,ROWNUM
Tenant Specific View Schema: dynamic columns including ACCOUNTNAME
index script: create index my_index_filter_1 on
pherf.rrs_custom_view1(ACCOUNTNAME) include(ROWNUM);
Query: select /*+ INDEX(pherf.rrs_custom_view1 my_index_filter_1) */ ROWNUM
from PHERF.RRS_CUSTOM_VIEW1 where ACCOUNTNAME = 'Account_7' ORDER BY
CUSTOMFIELD2;
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
