[ https://issues.apache.org/jira/browse/PHOENIX-3780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Manoj Patrick updated PHOENIX-3780: ----------------------------------- Attachment: Analytics_reports_scenario.xml create_pherf_REPORT_INSTANCE_DATA_DETAIL.sql This is how you need to setup the data: Step1: Deploy the phoenix Schema and Scenario File to create the Table and the View. Step2: To Load the generated data , run the following Pherf script, The scenario files also has Query Sets defined , Please do not run those. Just use the scenario file to load data into the view. Step 3: create index my_index_filter_1 on pherf.rrs_custom_view1(ACCOUNTNAME) include(ROWNUM); Step4: Run a query on the view having the index. select /*+ INDEX(pherf.rrs_custom_view1 my_index_filter_1) */ ROWNUM from PHERF.RRS_CUSTOM_VIEW1 where ACCOUNTNAME = 'Account_7' ORDER BY CUSTOMFIELD2; > 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 > Attachments: Analytics_reports_scenario.xml, > create_pherf_REPORT_INSTANCE_DATA_DETAIL.sql > > > 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)