phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Can't UPSERT into a VIEW?
Date Mon, 06 Jul 2015 18:08:27 GMT
Phoenix inserts an empty key value for existing rows when you do a CREATE
TABLE on an existing HBase table. If it's a big table, just set your
timeouts really high so it has time to complete.
Thanks,
James

On Mon, Jul 6, 2015 at 7:43 AM, Martin Pernollet <mpernollet@octo.com>
wrote:

> 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 <mpernollet@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 <mpernollet@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
>>>
>>

Mime
View raw message