Hi,
(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
rows.
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 <mpernol...@octo.com> 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 <mpernol...@octo.com> 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
>>
>
