RE: How to use sqoop import

rtas...@mpac.ca] Sent: Friday, March 01, 2013 9:21 AM To: user@hadoop.apache.org Subject: RE: How to use sqoop import There are two ways to import data from sqoop. Table dump (without select statements) Example: sqoop import --connect jdbc:mysql:/// --username --password <"*"&

RE: How to use sqoop import

NS --target-dir --split-by -m 3 Good luck. Rgds, AK-47 From: vasanth kumar [mailto:rj.vasanthku...@gmail.com] Sent: Friday, March 01, 2013 8:07 AM To: user@hadoop.apache.org Subject: Re: How to use sqoop import Try this ./sqoop import --connect jdbc:mysql://localhost/my --username user --passw

Re: How to use sqoop import

Also required: --query or --table . If your table has a primary key, --split-by is optional. Detailed: Have a look at sqoop documentation here . v1.4.2 user guide: http://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html Thanks, Abhijeet On Fri, Mar 1, 2013 at 6:36 P

Re: How to use sqoop import

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.h