hadoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vasanth kumar <rj.vasanthku...@gmail.com>
Subject Re: How to use sqoop import
Date Fri, 01 Mar 2013 13:06:41 GMT
Try this
./sqoop import --connect jdbc:mysql://localhost/my --username user
--password 1234 --query 'select * from table where id=5 AND $CONDITIONS'
--split-by table.id --target-dir /dir

you must specify --split-by and --target-dir




On Fri, Mar 1, 2013 at 12:32 PM, samir das mohapatra <
samir.helpdoc@gmail.com> wrote:

> Hi All,
>   Can any one share some example how to run sqoop "Import results of SQL
> 'statement'"   ?
>  for example:
>          sqoop import -connect jdbc:.........  --driver xxxxxxxxxxx
>
> after this if i am specifying  --query "select statement " it is even not
> recognizing as sqoop  valid statement..
>
> Regards,
> samir.
>
>



-- 
Regards
Vasanth kumar RJ

Mime
View raw message