Hello Rakesh,
Exporting selective columns is not supported at the moment by Sqoop.
("--columns" is an import-specific option.) If you like to have exporting
selective columns in Sqoop , please file a JIRA at:
https://issues.apache.org/jira/browse/SQOOP
Thanks,
Cheolsoo
On Wed, Mar 21, 2012 at 11:56 AM, Bilung Lee <b...@cloudera.com> wrote:
> Hi Cheolsoo,
>
> Could you please take a look at this? From what I heard, it may no longer
> be an issue. Could you please verify?
>
> Thanks!
>
> - Bilung
>
> ---------- Forwarded message ----------
> From: ihavethepotential <ihavethepotent...@gmail.com>
> Date: Wed, Mar 21, 2012 at 4:00 AM
> Subject: [sqoop-user] Sqoop Export : exporting selective columns from a
> table in HDFS
> To: Sqoop Users <sqoop-u...@cloudera.org>
>
>
> Hi all,
>
> I am trying to export selective columns from HDFS to MySQL as follows:
>
> bin/sqoop export -connect jdbc:mysql://hadoop-namenode:3306/ladap -
> username root -password root -table ldp_port --columns
> ldp_id,ldp_port,ldp_date_created,ldp_date_modified --update-key ldp_id
> --export-dir /user/hive/warehouse/db_32.db/temp_impetus_conn1_port --
> input-fields-terminated-by '\001'
>
> But it seems sqoop currently doesn't support --columns(selective
> columns export) feature which is a known issue at Cloudera.(See
> https://issues.cloudera.org/browse/SQOOP-169)
>
> Can anyone help on this?
>
> Thanks in advance.
> Rakesh Kumar Rakshit
>
> --
> NOTE: The mailing list sqoop-u...@cloudera.org is deprecated in favor of
> Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please
> subscribe to it by sending an email to
> incubator-sqoop-user-subscr...@apache.org.
>
>
>
