phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ciureanu Constantin <ciureanu.constan...@gmail.com>
Subject Re: FOREIGN KEY
Date Thu, 12 May 2016 13:14:26 GMT
Just create a new first unique field CustomerID + TelephoneType to play the
PK role, something has to be unique there and a HBase table needs a Key
(this concatenation of 2 or more values is valid in case it's unique
otherwise invent some other 3rd part or risk to lose phone numbers that are
"duplicates" - eg. for the same CustomerID and Type).

2016-05-12 13:24 GMT+02:00 Mariana Medeiros <63msim@gmail.com>:

> Hello,
>
> Do you know how to create an HBase table with no primary key and with a
> foreign key?
>
> Something like:
>
> (TABLE) CUSTOMER:
> CustomerID (pk)
> CustomerName
>
>
> (TABLE) TELEPHONE:
> CustomerID (fk)
> TelephoneType
> TelephoneNumber
>
>
> How to create a telephone table like that?
>
> Thank you.
>

Mime
View raw message