phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Pernollet <>
Subject Re: Can't UPSERT into a VIEW?
Date Mon, 06 Jul 2015 14:43:12 GMT

(using phoenix 4.2.2 on HDP 2.2)

I would like to map an existing table from phoenix. Once mapped, the table
should support addition of new rows.

I first started by CREATE VIEW. I can query rows, but I can't insert new
I now try *CREATE TABLE*. Unfortunately, the command either *fails with a
timeout or hangs "forever"*.

*What does phoenix tries to do when calling CREATE TABLE on an existing
table, compared to CREATE VIEW?*

I see nothing particular in the region server logs (simply INFO/DEBUG) :
* RpcServer connection-disconnections
* LruBlockCache debug reports
* Zookeeper informing on opened regions
* PostOpenDeployTasks

thanks in advance for your suggestions.

Le mer. 1 juil. 2015 à 17:09, Martin Pernollet <> a
écrit :

> I seems
> - CREATE TABLE returns the error "Table already exists" if you earlier
> created and dropped a view for the HBase table (bug?).
> - but one can actually run CREATE TABLE for an existing hbase table
> according to the documentation
> I can't be sure for the moment as the CREATE TABLE statement on a
> re-generated hbase table fails for another reason (timeout).
> Le mer. 1 juil. 2015 à 16:04, Martin Pernollet <> a
> écrit :
>> Hi,
>> I got an existing HBase table, so I mapped to phoenix using a *view*. I
>> can select, create index, so I am happy.
>> Now I want to add a row (I assume it is not compulsory to have all column
>> values defined - would be boring otherwise with numerous columns):
>> upsert into "table" ("family1"."column1", "family2"."column2") values
>> ("value1", "value2")
>> says* ERROR 505 (42000): Table is read only. (state=42000, code=505)*
>> What does it mean? Can we use phoenix to append rows to an existing HBase
>> table?
>> Thanks in advance
>> Martin

View raw message