Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution

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

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

Accepted Solutions

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

Super Collaborator

No, view has the same column names.

3 REPLIES 3

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

Super Collaborator

No, view has the same column names.

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

Contributor

@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

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.

Don't have an account?
Coming from Hortonworks? Activate your account here