phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-622) Support multi-tenant tables as views
Date Fri, 02 May 2014 04:58:15 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

James Taylor resolved PHOENIX-622.
----------------------------------

    Resolution: Fixed

> Support multi-tenant tables as views
> ------------------------------------
>
>                 Key: PHOENIX-622
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-622
>             Project: Phoenix
>          Issue Type: Task
>    Affects Versions: 3.0.0, 4.0.0, 5.0.0
>            Reporter: elevine
>            Assignee: James Taylor
>            Priority: Blocker
>             Fix For: 3.0.0, 4.0.0, 5.0.0
>
>
> Support secondary indexes on tenant-specific tables by:
> * creating index on tenant-specific table by inserting indexed columns after the tenant_id
and type_id columns, but before the entity_id column either:
>   * in the same underlying HBase physical table, but with a different type_id for the
index table. We'd need to be careful when querying the data by filtering out index rows, as
they would not conform to the data table row key.
>   * have another separate physical HBase table that stores all index rows. In this case,
the same type_id could be used for the index and data table. Probably simplest to create this
separate physical HBase table upfront, when the base data table is created.
> Probably the latter approach is better/easier. We could also have different table/column
family configurations for the index table which is probably good.
> @elevine - what do you think?



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message