[
https://issues.apache.org/jira/browse/PHOENIX-607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-607.
----------------------------------
Resolution: Fixed
Bulk resolve of closed issues imported from GitHub. This status was reached by
first re-opening all closed imported issues and then resolving them in bulk.
> Can create table/view on existing hbase table with setting a rowkey filter?
> ---------------------------------------------------------------------------
>
> Key: PHOENIX-607
> URL: https://issues.apache.org/jira/browse/PHOENIX-607
> Project: Phoenix
> Issue Type: Task
> Reporter: zuanfan
>
> I have a table with several type of rowkeys. Is this a way to create a
> table/view on partial rowkeys？
> for example, I have a table :
> rowkey Qualifier value
> 123Profile F:NAME Jack
> 124Profile F:NAME Tim
> 123Checkin F:LOCATION Locaton1
> How to create a table only with rowkeys which use "Profile" as suffix?
> Does phoenix support create view like:
> create view t1(UID VARCHAR PRIMARY KEY, F.NAME VARCHAR) as select * from
> hbase_t1 where row_key rlike "(.*)(Profile)";
--
This message was sent by Atlassian JIRA
(v6.2#6252)
