Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Expert Contributor

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 ?

1 ACCEPTED SOLUTION

avatar
Super Collaborator

No, view has the same column names.

View solution in original post

3 REPLIES 3

avatar
Super Collaborator

No, view has the same column names.

avatar
Expert Contributor

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

avatar
Super Collaborator

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.