phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Table salting
Date Tue, 18 Aug 2015 17:12:45 GMT
You can use UPSERT SELECT from the old table to the new table and do this
with a single statement:
https://phoenix.apache.org/language/index.html#upsert_select

Make sure you set your timeouts high if the table is big.

Thanks,
James

On Tue, Aug 18, 2015 at 9:40 AM, Sumanta Gh <sumanta.gh@tcs.com> wrote:

> Thanks for replying. We are ok with rewriting the whole data.
>
> Regards
> Sumanta
>
>
> -----anil gupta <anilgupta84@gmail.com> wrote: -----
> To: "user@phoenix.apache.org" <user@phoenix.apache.org>
> From: anil gupta <anilgupta84@gmail.com>
> Date: 08/18/2015 08:08PM
> Subject: Re: Table salting
>
>
> Adding salting to an existing table would mean changing Rowkey of each Row
> in HBase. I dont think it possible without re-writing entire table with new
> RowKey(salted). Are you ok with rewriting entire table with new Rowkey?
>
>
> On Tue, Aug 18, 2015 at 7:29 AM, Sumanta Gh <sumanta.gh@tcs.com> wrote:
>
>> Hi,
>> Is there a way to add salt buckets to an existing table with data?
>>
>> Regards
>> Sumanta
>>
>> =====-----=====-----=====
>> Notice: The information contained in this e-mail
>> message and/or attachments to it may contain
>> confidential or privileged information. If you are
>> not the intended recipient, any dissemination, use,
>> review, distribution, printing or copying of the
>> information contained in this e-mail message
>> and/or attachments to it are strictly prohibited. If
>> you have received this communication in error,
>> please notify us by reply e-mail or telephone and
>> immediately and permanently delete the message
>> and any attachments. Thank you
>>
>>
>
>
> --
> Thanks & Regards,
> Anil Gupta
>

Mime
View raw message