phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manoj Patrick (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3780) Undefined Column Error while Using index hint
Date Tue, 11 Apr 2017 20:32:41 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15964922#comment-15964922
] 

Manoj Patrick commented on PHOENIX-3780:
----------------------------------------

I will upload the needed data sets to reproduce the issue.

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

Mime
View raw message