phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anirudha Khanna <akha...@marinsoftware.com>
Subject Re: Extra Column when creating views
Date Wed, 01 Apr 2015 16:55:10 GMT
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 <tdsilva@salesforce.com>
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
> <akhanna@marinsoftware.com> 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
>

Mime
View raw message