You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/07/23 19:22:00 UTC
[jira] [Commented] (PHOENIX-3547) Promote CATALOG.VIEW_INDEX_ID to
an int
[ https://issues.apache.org/jira/browse/PHOENIX-3547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16553288#comment-16553288 ]
ASF GitHub Bot commented on PHOENIX-3547:
-----------------------------------------
GitHub user m2je opened a pull request:
https://github.com/apache/phoenix/pull/312
PHOENIX-3547 Supporting more number of indices per table.
https://issues.apache.org/jira/browse/PHOENIX-3547
Currently the number of indices per Phoenix table is bound to maximum of 65535 (java.lang.short) which may limit some application requiring to have arbitrary unlimited number of indices.
This change will consider any new table created in Phoenix to support indices ids to be in -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 (java.lang.Long) range which is undoubtably big enough to cover this requirement.
Any existing Phoenix Phoenix table will still continue to support only maximum of 65535 of indices and will be able to maintain this limits as enforced before.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/m2je/phoenix support-large-number-of-indecies
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/312.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #312
----
commit 93bf44780867e313cfc3ee31c019c33e28d48e04
Author: Mahdi Salarkia <ms...@...>
Date: 2018-07-19T22:23:58Z
PHOENIX-3547 Supporting more number of indecies per table.
----
> Promote CATALOG.VIEW_INDEX_ID to an int
> ---------------------------------------
>
> Key: PHOENIX-3547
> URL: https://issues.apache.org/jira/browse/PHOENIX-3547
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Jeremy Huffman
> Priority: Minor
>
> Increase the size of CATALOG.VIEW_INDEX_ID from smallint to int to support a large number of indexed views on a single table.
> Per James: "The code would just need to be tolerant when reading the data if the length is two byte short versus four byte int. At write time, we'd just always write an int."
> See: https://lists.apache.org/thread.html/22849e4fc73452cee3bea763cf6d5af7164dedcb44573ba6b9f452a2@%3Cuser.phoenix.apache.org%3E
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)