You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2018/05/03 16:15:00 UTC

[jira] [Commented] (PHOENIX-4623) Inconsistent physical view index name

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

James Taylor commented on PHOENIX-4623:
---------------------------------------

[~tdsilva] - is this a bug? [~akshita.malhotra] - how about a patch?

> Inconsistent physical view index name
> -------------------------------------
>
>                 Key: PHOENIX-4623
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4623
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.13.0
>            Reporter: Akshita Malhotra
>            Priority: Major
>              Labels: easyfix
>             Fix For: 4.14.0
>
>
> The physical view indexes are incorrectly named when table has a schema. For instance, if a table name is "SCH.TABLE", during creation the physical index table is named as "_IDX_SCH.TABLE" which doesn't look right. In case namespaces are enabled, the physical index table is named as "SCH:_IDX_TABLE"
> The client APIs on the other hand such as MetaDataUtil.getViewIndexName(String schemaName, String tableName) API to retrieve the phyisical view index name returns "SCH._IDX_TABLE" which as per convention returns the right name but functionally leads to wrong results as this is not how the physical indexes are named during construction.
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)