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
Also required: --query or --table .
If your table has a primary key, --split-by is optional.
Detailed:
Have a look at sqoop documentation here http://sqoop.apache.org/docs/.
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
,field2... from table name WHERE \$CONDITIONS
conditions --target-dir name of directory if you want --split-by field1
-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
: Kartashov, Andy [mailto:andy.kartas...@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://host/database
Hi All,
Can any one share some example how to run sqoop Import results of SQL
'statement' ?
for example:
sqoop import -connect jdbc:. --driver xxx
after this if i am specifying --query select statement it is even not
recognizing as sqoop valid statement..