This worked fine for me.
In HBase shell:
create 't1', {NAME => 'f1'}
In Phoenix sqlline:
create view v1(a VARCHAR PRIMARY KEY, "f1".b INTEGER) as select * from "t1";
create view v2(a VARCHAR PRIMARY KEY, "f1".c INTEGER) as select * from "t1";
If your table name and column family name are not upper case, make
sure you surround them by double quotes when referencing in your
statement. You can also declare a default column family like this
instead:
create view v3(a VARCHAR PRIMARY KEY, d INTEGER) as select * from "t1"
default_column_family='f1';
Thanks,
James
On Thu, Mar 5, 2015 at 8:19 AM, Sergey Belousov
<[email protected]> wrote:
> Hi All
>
> It seems like impossible now to create more than one view (with different
> names and columns of course) on top of existent HBase table.
>
> It also seems impossible to provide view name other than original HBase
> table name you base you view of.
>
> Are thouse statements correct or I just missing something? and if they are
> is it something that can be implemented in historicity short time to make it
> possible? Is it even possible or there is some big underlying issues that
> will stop it from happening?
>
>
> Thank you
>
