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 <ashok34...@yahoo.com> wrote: > hi, > > what is the equivalent to foreign keys in Hive? > > Thanks > > -- Want to work at Handy? Check out our culture deck and open roles <http://www.handy.com/careers> Latest news <http://www.handy.com/press> at Handy Handy just raised $50m <http://venturebeat.com/2015/11/02/on-demand-home-service-handy-raises-50m-in-round-led-by-fidelity/> led by Fidelity
