Can you explain that a little more please. I dont think I follow. Anirudha
On Wed, Apr 1, 2015 at 12:56 AM, Thomas D'Silva <[email protected]> wrote: > 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 >
