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.help...@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