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

[#1]

Hi

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 ?

[#2 · Accepted solution]

No, view has the same column names.

[#3]

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

[#4]

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.