I think its to support the case when all columns of the table are part of primary key (and are used to construct the rowkey).
On Tue, Mar 31, 2015 at 6:23 AM, Anirudha Khanna <[email protected]> wrote: > Hi All, > > I am creating updatable views on a Phoenix table and inserting data into the > table through the views. When I inspect the table through the HBase shell, I > see an extra column there > > 0:_0 timestamp=1427807823285, value= > > Just curious why is this column created. > > My queries, > - CREATE TABLE IF NOT EXISTS BASE_TABLE (id UNSIGNED_LONG NOT NULL, vwId > TINYINT(2), someVal VARCHAR, CONSTRAINT "base_table_pk" PRIMARY KEY(id)); > - CREATE VIEW CHILD_TABLE_1 (settings VARCHAR, extId VARCHAR) AS SELECT * > FROM BASE_TABLE WHERE vwId = 1; > - CREATE VIEW CHILD_TABLE_2 (settings VARCHAR, extId VARCHAR) AS SELECT * > FROM BASE_TABLE WHERE vwId = 2; > > Help is much appreciated. > > Cheers, > Anirudha
