Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Sqoop import Format Issue


Copy link to this message
-
Re: Sqoop import Format Issue
This cannot be achieved with Sqoop.

Thanks,
Abhijeet
On Jan 18, 2013 6:01 PM, "Vineet Mishra" <[EMAIL PROTECTED]> wrote:

>
> Hallo All,
>
> Can we customize the *--split-by* option in Sqoop import statement so
> that the output would be single file with comma delimited and having a
> fixed maximum number of values in each rows, like for fetching a single
> Column from the DB the output should be like,
>
> 1234,1235,1564,1674
> 1546,2546,5653,6434
> 6543,6534,7763,6567
>
> so it will be single file that can be done with option *-m 1* and each
> row will have a maximum no. of values(comma separated), i.e in this case
> its 4.
>
> Kindly let me if any one of you has worked this case. . .
>
> Thanks in Advance!
>
>
> On Fri, Jan 18, 2013 at 4:50 PM, Vineet Mishra <[EMAIL PROTECTED]
> > wrote:
>
>> Hallo All,
>>
>> I am working with Sqoop to query from the database to for my Map/Reduce
>> job, the issue I am struggling with is
>>
>> 1) Is there a way to directly pass the Sqoop Import Result to the Map for
>> processing rather than storing it to file system and then processing.
>>
>> If above can't be done then let me know whether,
>>
>> 2) I want the format of the file which is coming from the sqoop import
>> command  to be comma(,) separated single line file, but my output is coming
>> as a multi row file.
>>
>>
>> I am querying from the Database fetching a single column of some random
>> values, which is coming in the format,
>>
>> 1234
>> 1235
>> 1564
>> 1674
>> 1546
>> 2546
>> 5653
>> 6434
>>
>> the output which I was expecting was,
>>
>> 1234,1235,1564,1674,1546,2546,5653,6434
>>
>> and so on. . .
>>
>> Urgent!!!
>> Sqoop Developers/Users please reply!
>>
>>
>> --
>> Thanks and Regards
>> Vineet Mishra
>>
>
>
>
> --
> Thanks and Regards
> Vineet Mishra
>