[jira] [Resolved] (PHOENIX-509) can I create a phoenix view from a phoenix table?

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

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

Gabriel Reid resolved PHOENIX-509.
----------------------------------

    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 I create a phoenix view from a phoenix table?
> -------------------------------------------------
>
>                 Key: PHOENIX-509
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-509
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: gong-gong07
>
> how can I create a view when I create a new phoenix table ?
> this is query I tried .
> [step0] there is no hbase table, no phoenix table.
> [step1]create  phoenix table with sqlline 
> create table t1(
>  rowid varchar primary key,
>  id varchar(10)
> );
> [step2]upsert phoenix table with sqlline
> upsert into t1 values ( '001', 'val1');
> [step3]create view on phoenix with sqlline
> create view v1 (
>  rowid varchar primary key,
>  "T1"."ID" varchar(10)
> );
> I got "Table is read only."
> thanks



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