Return-Path: 
 <user-return-5608-apmail-hadoop-mapreduce-user-archive=hadoop.apache.org@hadoop.apache.org>
X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org
Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id EE296EDEB
	for <apmail-hadoop-mapreduce-user-archive@minotaur.apache.org>;
 Fri,  1 Mar 2013 13:07:15 +0000 (UTC)
Received: (qmail 27401 invoked by uid 500); 1 Mar 2013 13:07:10 -0000
Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org
Received: (qmail 27100 invoked by uid 500); 1 Mar 2013 13:07:10 -0000
Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hadoop.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hadoop.apache.org>
List-Post: <mailto:user@hadoop.apache.org>
List-Id: <user.hadoop.apache.org>
Reply-To: user@hadoop.apache.org
Delivered-To: mailing list user@hadoop.apache.org
Received: (qmail 27079 invoked by uid 99); 1 Mar 2013 13:07:09 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Mar 2013 13:07:09 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of rj.vasanthkumar@gmail.com
 designates 74.125.82.42 as permitted sender)
Received: from [74.125.82.42] (HELO mail-wg0-f42.google.com) (74.125.82.42)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Mar 2013 13:07:02 +0000
Received: by mail-wg0-f42.google.com with SMTP id 12so7239733wgh.3
        for <user@hadoop.apache.org>; Fri, 01 Mar 2013 05:06:42 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:x-received:in-reply-to:references:date:message-id
         :subject:from:to:content-type;
        bh=o8lPs9K8K9nc7lvouFP0H7shwzzknXEqVuKy0/c9qc4=;
        b=OOfvl5EJ0o5rf5CFzcOeLVGOukYjBcevBFGqIt4SYw0PB9KqDzWFEjM4e5UZDv8yJb
         ho77MKb5RdPkyM5A6EEDOIqkinNTRAYmjLIXjvH2mNEVMNzJfyb0Wwa3TT13e5iBE24C
         Tdo2eEmIgIgmrQl6M9shdY2jWCfTFbNuqeKUyOyoEgGGD9d4yF4ivCtIxHkiVY0/ZJQW
         8hNC5iDvzX9PeyCWwOYEkmB21FNPCmPtBoOxNGWg16Naoxsbllfy60ZUztU4y19NZV5T
         WQjm2S6T29lRlUpqoUSRnF2cCtzMJWEl8xv74r5TNZgI5FGyi0P2AuzUqaPD58Vk5WYy
         98Yw==
MIME-Version: 1.0
X-Received: by 10.180.81.193 with SMTP id c1mr3778189wiy.19.1362143201883;
 Fri, 01 Mar 2013 05:06:41 -0800 (PST)
Received: by 10.194.40.194 with HTTP; Fri, 1 Mar 2013 05:06:41 -0800 (PST)
In-Reply-To: 
 <CAG4QEv5Z1LgpO=6XkD-M16sHqww235rZ=3e4wFMvQLd_2Hn-vw@mail.gmail.com>
References: 
 <CAG4QEv5Z1LgpO=6XkD-M16sHqww235rZ=3e4wFMvQLd_2Hn-vw@mail.gmail.com>
Date: Fri, 1 Mar 2013 18:36:41 +0530
Message-ID: 
 <CADHSSLO2=hmH=8q+R93qe9aJZzwcfJsZWHFQCSkRDc_nNQB=AA@mail.gmail.com>
Subject: Re: How to use sqoop import
From: vasanth kumar <rj.vasanthkumar@gmail.com>
To: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=f46d044401d0ae829c04d6dcad7f
X-Virus-Checked: Checked by ClamAV on apache.org

--f46d044401d0ae829c04d6dcad7f
Content-Type: text/plain; charset=ISO-8859-1

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

--f46d044401d0ae829c04d6dcad7f
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Try this <br>./sqoop import --connect jdbc:mysql://lo=
calhost/my --username user --password 1234 --query &#39;select * from table=
 where id=3D5 AND $CONDITIONS&#39; --split-by <a href=3D"http://table.id" t=
arget=3D"_blank">table.id</a> --target-dir /dir<br>

<br></div>you must specify --split-by and --target-dir<br><div><br><br></di=
v></div><div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Fr=
i, Mar 1, 2013 at 12:32 PM, samir das mohapatra <span dir=3D"ltr">&lt;<a hr=
ef=3D"mailto:samir.helpdoc@gmail.com" target=3D"_blank">samir.helpdoc@gmail=
.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div><div><div><div>Hi All,=
<br></div>=A0 Can any one share some example how to run sqoop &quot;Import =
results of SQL &#39;statement&#39;&quot;=A0=A0 ?<br>
</div>=A0for example: <br>=A0=A0=A0=A0=A0=A0=A0=A0 sqoop import -connect jd=
bc:.........=A0 --driver xxxxxxxxxxx <br>
<br></div>after this if i am specifying=A0 --query &quot;select statement &=
quot; it is even not recognizing as sqoop=A0 valid statement..<br><br></div=
>Regards,<br>samir.<br><div><div><div>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 <br></div></div>

</div></div>
</blockquote></div><br><br clear=3D"all"><br>-- <br>Regards<br>Vasanth kuma=
r RJ
</div>

--f46d044401d0ae829c04d6dcad7f--