There is no magic. Hopefully one table is smaller then the other. You could
make a UDTF to do something like this MR job is doing

Make a mapper that runs over table A.
InputFormat.setInputPath("/path/to/table/a")

Then inside the mapper

private Conf c
setup(Conf c){
  this.c = c
}
public void map(Text key, Text value, Collector c){
  FileSystem fs = Filesystem.get(c);
  file f =fs.open("/path/to/table/b")
  for (line in f){
    c.collect( value + line);
  }
}



On Thu, Jul 10, 2014 at 12:56 PM, Malligarjunan S <malligarju...@gmail.com>
wrote:

> Hello Edward,
>
> Thank you very much for helping me.
> I am new to hive.  Could you please provide the sample map reduce job?
>
> Regards,
> Sankar S
>
>
>
>
> On Thu, Jul 10, 2014 at 8:19 AM, Edward Capriolo <edlinuxg...@gmail.com>
> wrote:
>
>> Hive cross product stinks . I have a map reduce job that will do it
>>
>>
>> On Wednesday, July 9, 2014, Navis류승우 <navis....@nexr.com> wrote:
>>
>>> Yes, 2M x 1M makes 2T pairing in single reducer.
>>>
>>> Thanks,
>>> Navis
>>>
>>>
>>> 2014-07-10 1:50 GMT+09:00 Malligarjunan S <malligarju...@gmail.com>:
>>>
>>>> Hello All,
>>>> Is that the expected behavior from hive to take so much of time?
>>>>
>>>>
>>>> Thanks and Regards,
>>>> Sankar S
>>>>
>>>>
>>>> On Tue, Jul 8, 2014 at 11:23 PM, Malligarjunan S <
>>>> malligarju...@gmail.com> wrote:
>>>>
>>>>> Hello All,
>>>>>
>>>>> Can any one help me to answer to my question posted on Stackoverflow?
>>>>>
>>>>> http://stackoverflow.com/questions/24416373/hive-udf-performance-too-slow
>>>>> It is pretty urgent. Please help me.
>>>>>
>>>>> Thanks and Regards,
>>>>> Sankar S.
>>>>>
>>>>
>>>>
>>>
>>
>> --
>> Sorry this was sent from mobile. Will do less grammar and spell check
>> than usual.
>>
>
>

Reply via email to