ROW_NUMBER() equivalent in Hive

2013-02-20 Thread kumar mr
Hi, This is Kumar, and this is my first question in this group. I have a requirement to implement ROW_NUMBER() from Teradata in Hive where partitioning happens on multiple columns along with multiple column ordering. It can be easily implemented in Hadoop MR, but I have to do in Hive. By doin

Re: ROW_NUMBER() equivalent in Hive

2013-02-21 Thread kumar mr
t 11:33 PM, kumar mr wrote: Hi, This is Kumar, and this is my first question in this group. I have a requirement to implement ROW_NUMBER() from Teradata in Hive where partitioning happens on multiple columns along with multiple column ordering. It can be easily implemented in Hadoop MR, but I

doubt with LEFT OUTER JOIN

2013-03-01 Thread kumar mr
Hi, Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE table doesn't have at least one record that matches JOIN condition in Hive? Regards, Kumar

Re: doubt with LEFT OUTER JOIN

2013-03-04 Thread kumar mr
statements, etc? What version of Hive? On Fri, Mar 1, 2013 at 2:13 PM, kumar mr wrote: Hi, Does LEFT OUTER JOIN returns zero rows when RIGHT SIDE table doesn't have at least one record that matches JOIN condition in Hive? Regards, Kumar -- Dean Wampler, Ph.D. thinkbiganalytics.c

Re: doubt with LEFT OUTER JOIN

2013-03-04 Thread kumar mr
with LEFT OUTER JOIN I just tried an experiment where the right-hand table was empty. It worked fine. Could you post more details, like the query, create table statements, etc? What version of Hive? On Fri, Mar 1, 2013 at 2:13 PM, kumar mr wrote: Hi, Does LEFT OUTER JOIN returns zero