question Re: Phoenix Views with different column names compared to Hbase / Phoenix tables in Archives of Support Questions (Read Only)

Phoenix Views with different column names compared to Hbase / Phoenix tables

rrrajesh — Mon, 27 Mar 2017 09:03:39 GMT

My Phoenix table( "t1", column family "f1") has the following columns,

pk - Primary key

first_name varchar

last_name varchar

I want to create a view ("v1") like following which points to the above table.

pk - Primary key

fn varchar

ln varchar

I like to have the column names shorter when i create the views but not in the original table.

When i query "select * from v1" , i should get the table "t1" data.

Is there a way to achieve this in Phoenix ?

Re: Phoenix Views with different column names compared to Hbase / Phoenix tables

ssoldatov — Tue, 28 Mar 2017 01:36:30 GMT

No, view has the same column names.

Re: Phoenix Views with different column names compared to Hbase / Phoenix tables

rrrajesh — Tue, 28 Mar 2017 05:13:10 GMT

@Sergey SoldatovThanks for the response. Do you aware if there is any apache JIRA open to include this feature in future releases.

Re: Phoenix Views with different column names compared to Hbase / Phoenix tables

ssoldatov — Tue, 28 Mar 2017 05:31:45 GMT

Once we support custom select (PHOENIX-1505, PHOENIX-1506) it will be possible to do that (like ... select column_1 as c1, ... ). Honestly speaking I can't say when it will be done.