Not sure if this works for the view use-case you have but it's working for
a Phoenix table.
The table create statement should have just the stable columns.
CREATE TABLE IF NOT EXISTS TESTC (
TIMESTAMP BIGINT NOT NULL,
NAME VARCHAR NOT NULL
CONSTRAINT PK PRIMARY KEY (TIMESTAMP, NAME)
);
-- insert
Note: as your columns are all in small remember to qualify the table name,
column family and column names in double quotes "".
Below example i created should help with the rest .. i have used capital
letters for table names and cols to make it easy ;)
==
All,
We have a sparse hbase table with 3 column families and variable column
qualifiers in each row. Can someone help me how to create a phoenix view to map
this hbase table into phoenix ?
Sample of Hbase table :
Row1: Key cf1.name cf1.id cf2.age cf3.salary
Row2: K