Sent: 10 January 2016 19:10
To: user@hive.apache.org; 'Ashok Kumar'
Subject: RE: foreign keys in Hive
Hi,
Primary key and foreign key constraints are really more applicable to
transactional databases where the transaction logic needs to be enforced. That
is once a unit of work is complet
Hi,
Primary key and foreign key constraints are really more applicable to
transactional databases where the transaction logic needs to be enforced. That
is once a unit of work is completed it is either committed or rolled back.
It does not really make sense to enforce the same logic in Hi
You can join on any equality criterion, just like in any other relational
database. Foreign keys in "standard" relational databases are primarily an
integrity constraint. Hive in general lacks integrity constraints.
On Sun, Jan 10, 2016 at 9:45 AM, Ashok Kumar wrote:
> hi,
>
> what is the equiva
