phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ns G <nsgns...@gmail.com>
Subject Re: Table salting
Date Tue, 18 Aug 2015 17:27:32 GMT
How about loading the data as data frame or RDD and just save the data to
new salted table and drop earlier table. I feel spark is very very fast
than MR. Just my idea though
On 18-Aug-2015 10:42 pm, "James Taylor" <jamestaylor@apache.org> wrote:

> 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