Strategy on joining on partial keys

[Yiannis Gkoufas <jo...@gmail.com>]

Hi there,

I have two tables I want to join.

TABLE_A: ( (A,B), C, D, E)  where (A,B) is the composite key
TABLE_B: ( (A), C, D, E) where A is the key

I basically want to join TABLE_A and TABLE_B on A and update TABLE_A with
the values C, D, E coming from TABLE_B
When I try to use UPSERT SELECT JOIN statement, it causes the regionserver
to die, without any logs.
TABLE_B is really small compared to TABLE_A

Any hints on how to approach this?

Thanks a lot!

Re: Strategy on joining on partial keys

[Maryann Xue <ma...@gmail.com>]

Hi Yiannis,

Could you please post your UPSERT query and the approximate size of both
tables? And does it happen every time you try to do the query?


Thanks,
Maryann

On Mon, Jun 29, 2015 at 6:19 AM, Yiannis Gkoufas <jo...@gmail.com>
wrote:

> Hi there,
>
> I have two tables I want to join.
>
> TABLE_A: ( (A,B), C, D, E)  where (A,B) is the composite key
> TABLE_B: ( (A), C, D, E) where A is the key
>
> I basically want to join TABLE_A and TABLE_B on A and update TABLE_A with
> the values C, D, E coming from TABLE_B
> When I try to use UPSERT SELECT JOIN statement, it causes the regionserver
> to die, without any logs.
> TABLE_B is really small compared to TABLE_A
>
> Any hints on how to approach this?
>
> Thanks a lot!
>