Re: Need help in joining 2 tables

Ramasubramanian Narayanan mailto:ramasubramanian.naraya...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Friday, July 26, 2013 1:17 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>"

Re: Need help in joining 2 tables

Hi Rama, Have a look !! Both sql and hiveql looks similar.. try this one.. *How to create view??* * * *Ans:* * * create view v1 as select m.Emp_id, m.Name, m.Dob, a.address1, a.address2, a.address3, a.address4, a.city, a.state, a.zip, a.country from EMP_MASTER m join EMP_ADDRESS a on (m.Emp_id=a

Re: Need help in joining 2 tables

Hi Have a look at link below. They have enough examples to clarify usage https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-Joins Richa On Fri, Jul 26, 2013 at 1:47 PM, Ramasubramanian Narayanan < ramasubramanian.naraya...@gmail.com> wrote: > Hi, > > Need to create a view in H

Need help in joining 2 tables

Hi, Need to create a view in HIVE as per the below query (written in Oracle). Need help to provide the equivalent query in HIVE to create view. *EMP_ADDRESS* Emp_Id Address1 Address2 Address3 Address4 City State Pin Country Alternate_Address1 Alternate_Address2 Alternate_Address3 Alternate_Addr