You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by Jarek Jarcec Cecho <ja...@apache.org> on 2014/09/23 16:40:15 UTC
Re: Sqoop2 Sequence Output format
Hi Shakun,
please route technical questions about Sqoop to dev@sqoop.apache.org mailing list. All developers are signed up on that mailing list and you are far more likely to get answer to your question in much faster time :) Instructions how to join are at [1].
SequenceFile always contains key-value pairs - that is how the format is defined. However this doesn’t suite Sqoop as we consider entire row as “key” and hence we’re not using the “value” field - and that is the null that you’re observing.
Jarcec
Links:
1: http://sqoop.apache.org/mail-lists.html
On Sep 22, 2014, at 11:01 PM, Shakun Sachdeva <s2...@gmail.com> wrote:
> Hi Jarcec,
>
> Hope you are doing good!!
>
> I am coming across an issue i.e. when I do Sqoop2 Import and choose the output format as Sequence File , then it appends a (null) with the original value
>
> e.g.
> I transfer 'names' from a table to sqoop which has "Tom" as a name
> The output file that got created is a sequence file. When I do
>
> hadoop fs -text /tmp/Seq1/part-m-00001.seq
>
> it gave me the following output:
>
> 'Tom' (null)
>
> Can you please tell me why it is appending null with the output?
>
> Your help will be highly appreciated.
> Thanks in advance!!
>
> Regards,
> Shakun