[jira] [Resolved] (PHOENIX-607) Can create table/view on existing hbase table with setting a rowkey filter?

["Gabriel Reid (JIRA)" <ji...@apache.org>]

     [ 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)