Please don't think I am sermonizing or preaching and please don't mind what I am saying :-)
This community is there is help u and there is no doubt about that.
However I am assuming you tried out a few options by yourself before you reached out to the community with your question.
Since the whole community is opensource and everyone is busy in projects , I think it will be better utilization of everyones time if you spend a few minutes first playing around a few options, juxtapose syntax if needed and see what errors you get (if any) and then ask your question.
There are many times an error for a syntax might give new ideas to community developers.
If this makes sense, I am happy…..if not, I don't mind :-)
Good luck with Hive…its a great technology and there are many people working very hard to make this better every day
From: Ramasubramanian Narayanan <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Friday, July 26, 2013 1:17 AM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Need help in joining 2 tables
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.
from EMP_MASTER MAST, EMP_ADDRESS ADDR
MAST.row_create_date = (select max(row_create_date) from EMP_MASTER where Emp_Id = MAST.Emp_Id)
and ADDR.row_create_date = (select max(row_create_date) from EMP_ADDRESS where Emp_Id = ADDR.Emp_Id)
=====================This email message and any attachments are for the exclusive use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message along with any attachments, from your computer system. If you are the intended recipient, please be advised that the content of this message is subject to access, review and disclosure by the sender's Email System Administrator.