phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: Creating multiple views off existent HBase table.
Date Thu, 05 Mar 2015 20:44:08 GMT
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

create view v3(a VARCHAR PRIMARY KEY, d INTEGER) as select * from "t1"


On Thu, Mar 5, 2015 at 8:19 AM, Sergey Belousov
<> 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

View raw message