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 Wed, 01 Jul 2015 15:09:38 GMT
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