phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Pernollet <mpernol...@octo.com>
Subject Can't UPSERT into a VIEW?
Date Wed, 01 Jul 2015 14:03:56 GMT
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

Mime
View raw message