[
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)
