sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chalcy <cha...@gmail.com>
Subject Re: Joins in Sqoop
Date Thu, 16 Jan 2014 13:48:59 GMT
Hi Sambit,

I would import all the relevant tables into hive and then do the join there
if you have enough space in the hadoop cluster.

Hope this helps,
Chalcy


On Thu, Jan 16, 2014 at 8:20 AM, Sambit Tripathy (RBEI/PJ-NBS) <
Sambit.Tripathy@in.bosch.com> wrote:

>  Hi,
>
> I have written query which has 5 Join clauses and I am passing this query
> in Sqoop import.
>
> Problem: This produces a large temp file in the MySQL server temp
> directory and throws back an error saying No Space left on the device. Yes
> this can be fixed by increasing the size of the temp directory in the MySQL
> server, but what if you actually don’t have any space left on MySQL server.
> Are there any workarounds for this? I mean something like a batch import
> which does not create a big temp file in the server.
>
>
> Regards,
> Sambit.
>
>

Mime
View raw message