CREATE TABLE IF NOT EXISTS TELEPHONE ( CustomerID INT, TelephoneType VARCHAR, TelephoneNumber VARCHAR CONSTRAINT PK PRIMARY KEY (CustomerID, TelephoneType) );
In case it's still not unique, add the TelephoneNumber too. ... CONSTRAINT PK PRIMARY KEY (CustomerID, TelephoneType, TelephoneNumber ) 2016-05-12 15:14 GMT+02:00 Ciureanu Constantin < [email protected]>: > 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 <[email protected]>: > >> 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. >> > >
