phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravi Kiran <maghamraviki...@gmail.com>
Subject Re: Extra Column when creating views
Date Wed, 01 Apr 2015 17:38:21 GMT
Hi Anirudha,

   The following link
https://groups.google.com/forum/#!msg/phoenix-hbase-user/UWdBghSfePo/BmCxOUOPHn8J
can be helpful.

Regards
Ravi

On Wed, Apr 1, 2015 at 9:55 AM, Anirudha Khanna <akhanna@marinsoftware.com>
wrote:

> 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