right) on the ID1 column.
> Something like this (untested by me):
> SELECT
>table1.*,
>table2.*
> FROM
>table1
>RIGHT OUTER JOIN table2
>ON (table1.id=table2.id_1);
>
> Mark
>
>
> On Thu, Dec 27, 2012 at 9:26 PM, Souvik Banerjee > wrote:
query
> efficiently. If you want columns from the right table in your select list,
> just do the regular (aka inefficient way) inner join.
>
> Of course, you can optimize inner joins as map joins, sorted merge join or
> sorted merge bucketed joins depending on your use case.
>
&
t 12:36 PM, Souvik Banerjee
wrote:
> Thanks for the help.
> What I did earlier is that I changed the configuration in HDFS and created
> the table. I expected that the block size of the new Table to be of 32 MB.
> But I found that while using Cloudera Manager you need to deploy Change in
>
KS
>
> Sent from remote device, Please excuse typos
> --
> *From: * Souvik Banerjee
> *Date: *Thu, 13 Dec 2012 12:00:16 -0600
> *To: *;
> *Subject: *Re: Map side join
>
> Hi Bejoy,
>
> The input files are non-compressed text file.
> There
table compression codec?
>
> Do you have enough free slots while this job is running?
>
> Make sure that the job is not running locally.
>
> Regards
> Bejoy KS
>
> Sent from remote device, Please excuse typos
> --
> *From: * Souvik Banerje
g skeptical in
> task, Tasktracker or jobtracker logs?
>
>
> Regards
> Bejoy KS
>
> Sent from remote device, Please excuse typos
> ------
> *From: * Souvik Banerjee
> *Date: *Tue, 11 Dec 2012 17:12:20 -0600
> *To: *;
> *ReplyTo: * user
On Fri, Dec 7, 2012 at 2:32 PM, Souvik Banerjee wrote:
> Hi Bejoy,
>
> That's wonderful. Thanks for your reply.
> What I was wondering if HIVE can do map side join with more than one
> condition on JOIN clause.
> I'll simply try it out and post the result.
>
&
if you are joining a small table with a large one,
> in terms of data size. By small, better to have the smaller table size in
> range of MBs.
> Regards
> Bejoy KS
>
> Sent from remote device, Please excuse typos
> --
> *From: *Souvik Banerjee
Hello everybody,
I have got a question. I didn't came across any post which says somethign
about this.
I have got two tables. Lets say A and B.
I want to join A & B in HIVE. I am currently using HIVE 0.9 version.
The join would be on few columns. like on (A.id1 = B.id1) AND (A.id2 =
B.id2) AND (A.
