[
https://issues.apache.org/jira/browse/PHOENIX-7304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836778#comment-17836778
]
Himanshu Gwalani commented on PHOENIX-7304:
-------------------------------------------
[~tkhurana] The idea is to use it for Hbase level scan (via MR jobs). For
example, during migration of data from one cluster to another, if HBase level
copy is done for all the tables, the copy operation will be issued for
_IDX_<data-table>s and we would need the list of unique view index IDs to allow
skip scan for such usecase.
> Add support for getting list of View Index IDs for any View Index Physical
> Table
> --------------------------------------------------------------------------------
>
> Key: PHOENIX-7304
> URL: https://issues.apache.org/jira/browse/PHOENIX-7304
> Project: Phoenix
> Issue Type: Task
> Reporter: Himanshu Gwalani
>
> The first 2 bytes of any View Index row are reserved for view index Ids. If
> there is an API to get list all existing unique view index IDs, client can
> leverage it for different usecase
> Eg: If a client need to scan and filter view index table, based on the list
> of data table keys, skip-scan filter cannot be directly leveraged since row
> key is not the prefix of view index. Instead if a list of unique view index
> IDs is already available, skip scan filter can be used with combination of
> view index IDs and knonw keys of data table, which would ultimately improve
> scan performance by avoiding a full table scan.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
