You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hadoop.apache.org by Kumar Jayapal <kj...@gmail.com> on 2015/05/06 22:56:22 UTC
Sqoop --split by options
Hello All,
Can I use split-by option with multiple keys to import the data ?
please help and suggest me any link.
sqoop import \
--connect jdbc:mysql://mysql.example.com/sqoop \
--username sqoop \
--password sqoop \
--query 'SELECT normcities.id, \
countries.country, \
normcities.city \
FROM normcities \
JOIN countries USING(country_id) \
WHERE $CONDITIONS' \
--split-by id \
--target-dir cities
Thanks
Jay
Re: Sqoop --split by options
Posted by Ted Yu <yu...@gmail.com>.
Have you asked this on sqoop mailing list ?
http://sqoop.apache.org/mail-lists.html
On Wed, May 6, 2015 at 1:56 PM, Kumar Jayapal <kj...@gmail.com> wrote:
> Hello All,
>
> Can I use split-by option with multiple keys to import the data ?
>
> please help and suggest me any link.
>
> sqoop import \
> --connect jdbc:mysql://mysql.example.com/sqoop \
> --username sqoop \
> --password sqoop \
> --query 'SELECT normcities.id, \
> countries.country, \
> normcities.city \
> FROM normcities \
> JOIN countries USING(country_id) \
> WHERE $CONDITIONS' \
> --split-by id \
> --target-dir cities
>
>
>
>
>
>
> Thanks
> Jay
>
Re: Sqoop --split by options
Posted by Ted Yu <yu...@gmail.com>.
Have you asked this on sqoop mailing list ?
http://sqoop.apache.org/mail-lists.html
On Wed, May 6, 2015 at 1:56 PM, Kumar Jayapal <kj...@gmail.com> wrote:
> Hello All,
>
> Can I use split-by option with multiple keys to import the data ?
>
> please help and suggest me any link.
>
> sqoop import \
> --connect jdbc:mysql://mysql.example.com/sqoop \
> --username sqoop \
> --password sqoop \
> --query 'SELECT normcities.id, \
> countries.country, \
> normcities.city \
> FROM normcities \
> JOIN countries USING(country_id) \
> WHERE $CONDITIONS' \
> --split-by id \
> --target-dir cities
>
>
>
>
>
>
> Thanks
> Jay
>
Re: Sqoop --split by options
Posted by Ted Yu <yu...@gmail.com>.
Have you asked this on sqoop mailing list ?
http://sqoop.apache.org/mail-lists.html
On Wed, May 6, 2015 at 1:56 PM, Kumar Jayapal <kj...@gmail.com> wrote:
> Hello All,
>
> Can I use split-by option with multiple keys to import the data ?
>
> please help and suggest me any link.
>
> sqoop import \
> --connect jdbc:mysql://mysql.example.com/sqoop \
> --username sqoop \
> --password sqoop \
> --query 'SELECT normcities.id, \
> countries.country, \
> normcities.city \
> FROM normcities \
> JOIN countries USING(country_id) \
> WHERE $CONDITIONS' \
> --split-by id \
> --target-dir cities
>
>
>
>
>
>
> Thanks
> Jay
>
Re: Sqoop --split by options
Posted by Ted Yu <yu...@gmail.com>.
Have you asked this on sqoop mailing list ?
http://sqoop.apache.org/mail-lists.html
On Wed, May 6, 2015 at 1:56 PM, Kumar Jayapal <kj...@gmail.com> wrote:
> Hello All,
>
> Can I use split-by option with multiple keys to import the data ?
>
> please help and suggest me any link.
>
> sqoop import \
> --connect jdbc:mysql://mysql.example.com/sqoop \
> --username sqoop \
> --password sqoop \
> --query 'SELECT normcities.id, \
> countries.country, \
> normcities.city \
> FROM normcities \
> JOIN countries USING(country_id) \
> WHERE $CONDITIONS' \
> --split-by id \
> --target-dir cities
>
>
>
>
>
>
> Thanks
> Jay
>