phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anirudha Khanna <akha...@marinsoftware.com>
Subject Extra Column when creating views
Date Tue, 31 Mar 2015 13:23:23 GMT
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