From sqoop-user-return-245-apmail-incubator-sqoop-user-archive=incubator.apache.org@incubator.apache.org  Wed Feb 22 04:28:59 2012
Return-Path: <sqoop-user-return-245-apmail-incubator-sqoop-user-archive=incubator.apache.org@incubator.apache.org>
X-Original-To: apmail-incubator-sqoop-user-archive@minotaur.apache.org
Delivered-To: apmail-incubator-sqoop-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 515449A29
	for <apmail-incubator-sqoop-user-archive@minotaur.apache.org>; Wed, 22 Feb 2012 04:28:59 +0000 (UTC)
Received: (qmail 63864 invoked by uid 500); 22 Feb 2012 04:28:59 -0000
Delivered-To: apmail-incubator-sqoop-user-archive@incubator.apache.org
Received: (qmail 63822 invoked by uid 500); 22 Feb 2012 04:28:59 -0000
Mailing-List: contact sqoop-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:sqoop-user-help@incubator.apache.org>
List-Unsubscribe: <mailto:sqoop-user-unsubscribe@incubator.apache.org>
List-Post: <mailto:sqoop-user@incubator.apache.org>
List-Id: <sqoop-user.incubator.apache.org>
Reply-To: sqoop-user@incubator.apache.org
Delivered-To: mailing list sqoop-user@incubator.apache.org
Received: (qmail 63730 invoked by uid 99); 22 Feb 2012 04:28:57 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Feb 2012 04:28:57 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,WEIRD_PORT
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of narasimharaoc@gmail.com designates 209.85.160.47 as permitted sender)
Received: from [209.85.160.47] (HELO mail-pw0-f47.google.com) (209.85.160.47)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Feb 2012 04:28:48 +0000
Received: by pbcum15 with SMTP id um15so2339856pbc.6
        for <sqoop-user@incubator.apache.org>; Tue, 21 Feb 2012 20:28:27 -0800 (PST)
Received-SPF: pass (google.com: domain of narasimharaoc@gmail.com designates 10.68.222.194 as permitted sender) client-ip=10.68.222.194;
Authentication-Results: mr.google.com; spf=pass (google.com: domain of narasimharaoc@gmail.com designates 10.68.222.194 as permitted sender) smtp.mail=narasimharaoc@gmail.com; dkim=pass header.i=narasimharaoc@gmail.com
Received: from mr.google.com ([10.68.222.194])
        by 10.68.222.194 with SMTP id qo2mr83291686pbc.20.1329884907637 (num_hops = 1);
        Tue, 21 Feb 2012 20:28:27 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        bh=OYnA2iHqQInIYGsVjmiFYJ0xnjhKUCO0yPAIk4sWnE8=;
        b=Cf/bynFAlc+EEhEgENs26WpJM9EI24pG/cHS6RkB7y5qITUyVaaMqN0OI5nwlTvP2n
         T4MLjkSnXYopgOyZO003yS4VInkZynGwTziv88nsuUrX0q4IL+hjRsS2K3zNwyXnMnsQ
         MTwl8q72z5gZrRTA8Gixy7pSgcwrlNpFuOzKI=
MIME-Version: 1.0
Received: by 10.68.222.194 with SMTP id qo2mr68475512pbc.20.1329884907532;
 Tue, 21 Feb 2012 20:28:27 -0800 (PST)
Received: by 10.68.24.233 with HTTP; Tue, 21 Feb 2012 20:28:27 -0800 (PST)
In-Reply-To: <CA+48JY+jwJOjKi4zdwE8jXryECSzEgV_9QY5xw9XHOknbnAYLA@mail.gmail.com>
References: <CA+48JY+jwJOjKi4zdwE8jXryECSzEgV_9QY5xw9XHOknbnAYLA@mail.gmail.com>
Date: Wed, 22 Feb 2012 09:58:27 +0530
Message-ID: <CA+48JY+dS+G5W1y3WiqnG7rD4Tz-LvuU7oq2ps=bVJgKs1JaTw@mail.gmail.com>
Subject: Re: need help on merge tool in sqoop
From: chelikani narasimharao <narasimharaoc@gmail.com>
To: sqoop-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=047d7b2ed88781734c04b985f5ab
X-Virus-Checked: Checked by ClamAV on apache.org

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

hi guys,
              Can any one please help me for the below issue.

Advanced Thanks,
Narasimharao

On Thu, Feb 16, 2012 at 8:24 PM, chelikani narasimharao <
narasimharaoc@gmail.com> wrote:

> Hi All,
>
>     I am trying to merge the two datasets using the merge tool
> functionality in sqoop.But i got struck up with the following error.
>
> *java.lang.RuntimeException: java.lang.ClassNotFoundException:
> CNTCT_D.class*
>
> *---->below is my command executed to get the first data set specifying
> the location to store the first dataset to dataset1 under narasimharao
> directory*
>
> sqoop import --connect jdbc:hpt4jdbc://
> g4n0401a.houston.hp.com:18650/:schema=EDW_DEV --driver
> com.hp.t4jdbc.HPT4Driver --username narasimharoa@hp.com -P --verbose
> --split-by SRC_SYS_KY --table CNTCT_D --where "SRC_SYS_KY=363 and CNTCT_ID
> in('100838','101324','101474','102212','100654') and ACT_FG='Y'"
> --target-dir /home/narasimharao/dataset1
>
> successfully able to import the dataset1 and also the .class and .jar
> files were written to the following location
>
> */tmp/sqoop-narasimharao/compile/08c0cc665bd3e89124987a7c297827a2*
>
>
> *--->below is my command executed to get the second data set  after
> updating the few records which exists in the dataset1 with the same
> merge-key*
>
>
> sqoop import --connect jdbc:hpt4jdbc://
> g4n0401a.houston.hp.com:18650/:schema=EDW_DEV --driver
> com.hp.t4jdbc.HPT4Driver --username narasimharoa.chelikani@hp.com -P
> --verbose --split-by SRC_SYS_KY --table CNTCT_D --where "SRC_SYS_KY=363 and
> CNTCT_ID in('100838','101324','101474','102212','100654') and ACT_FG='Y'"
> --target-dir /home/narasimharao/dataset2
>
> successfully able to import the dataset1 and also the .class and .jar
> files were written to the following location
>
> *
> /tmp/sqoop-narasimharao/compile/e26282f14a672e7722352fb424781e5a/CNTCT_D.jar
> *
>
>
> *--->Now the actually Sqoop merge command was given like below:*
>
> *sqoop merge --new-data /home/narasimharao/dataset1 --onto
> /home/narasimharao/dataset2 --target-dir /home/narasimharao/merged
> --jar-file CNTCT_D.jar --class-name CNTCT_D.class --merge-key CNTCT_ID*
>
>
> Can you please help me which class name i need to mention over here under
> the class-name attribute and what's wrong in this statement.
>
> I tried the below options
>
> 1.copied the dataset1 corresponding class and jar files into my home
> direcotry and tried like below...but getting the same error as below
>
> sqoop merge --new-data /home/narasimharao/dataset2 --onto
> /home/narasimharao/dataset1 --target-dir /home/narasimharao/merged
> --jar-file ./CNTCT_D.jar --class-name CNTCT_D.class --merge-key CNTCT_ID
>
> Warning: /usr/lib/hbase does not exist! HBase imports will fail.
> Please set $HBASE_HOME to the root of your HBase installation.
>
> 12/02/16 13:56:08 INFO input.FileInputFormat: Total input paths to process
> : 2
> 12/02/16 13:56:08 WARN snappy.LoadSnappy: Snappy native library is
> available
> 12/02/16 13:56:08 INFO util.NativeCodeLoader: Loaded the native-hadoop
> library
> 12/02/16 13:56:08 INFO snappy.LoadSnappy: Snappy native library loaded
> 12/02/16 13:56:10 INFO mapred.JobClient: Running job: job_201202161202_0005
> 12/02/16 13:56:11 INFO mapred.JobClient:  map 0% reduce 0%
> 12/02/16 13:56:55 INFO mapred.JobClient: Task Id :
> attempt_201202161202_0005_m_000000_0, Status : FAILED
> *java.lang.RuntimeException: java.lang.ClassNotFoundException:
> CNTCT_D.class
> * at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:996)
>  at
> com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextMapper.java:45)
>  at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)
>  at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
>  at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
>  at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at javax.security.auth.Subject.doAs(Subject.java:396)
>  at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
>  at org.apache.hadoop.mapred.Child.main(Child.java:264)
> Caused by: java.lang.ClassNotFoundException: CNTCT_D.class
>  at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>  at java.lang.ClassLoader.loadClass(ClassLo
> 12/02/16 13:56:59 INFO mapred.JobClient: Task Id :
> attempt_201202161202_0005_m_000001_0, Status : FAILED
> *java.lang.RuntimeException: java.lang.ClassNotFoundException:
> CNTCT_D.class
> * at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:996)
>  at
> com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextMapper.java:45)
>  at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)
>  at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
>  at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
>  at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at javax.security.auth.Subject.doAs(Subject.java:396)
>  at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
>  at org.apache.hadoop.mapred.Child.main(Child.java:264)
> Caused by: java.lang.ClassNotFoundException: CNTCT_D.class
>  at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>  at java.lang.ClassLoader.loadClass(ClassLo
> 12/02/16 13:57:22 INFO mapred.JobClient: Task Id :
> attempt_201202161202_0005_m_000000_1, Status : FAILED
> java.lang.RuntimeException: java.lang.ClassNotFoundException: CNTCT_D.class
>  at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:996)
>  at
> com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextMapper.java:45)
>  at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)
>  at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
>  at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
>  at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at javax.security.auth.Subject.doAs(Subject.java:396)
>  at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
>  at org.apache.hadoop.mapred.Child.main(Child.java:264)
> Caused by: java.lang.ClassNotFoundException: CNTCT_D.class
>  at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>  at java.lang.ClassLoader.loadClass(ClassLo
> 12/02/16 13:57:23 INFO mapred.JobClient: Task Id :
> attempt_201202161202_0005_m_000001_1, Status : FAILED
> *java.lang.RuntimeException: java.lang.ClassNotFoundException:
> CNTCT_D.class
> * at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:996)
>  at
> com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextMapper.java:45)
>  at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)
>  at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
>  at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
>  at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at javax.security.auth.Subject.doAs(Subject.java:396)
>  at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
>  at org.apache.hadoop.mapred.Child.main(Child.java:264)
> Caused by: java.lang.ClassNotFoundException: CNTCT_D.class
>  at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>  at java.lang.ClassLoader.loadClass(ClassLo
> 12/02/16 13:57:50 INFO mapred.JobClient: Task Id :
> attempt_201202161202_0005_m_000000_2, Status : FAILED
> *java.lang.RuntimeException: java.lang.ClassNotFoundException:
> CNTCT_D.class
> * at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:996)
>  at
> com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextMapper.java:45)
>  at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)
>  at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
>  at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
>  at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at javax.security.auth.Subject.doAs(Subject.java:396)
>  at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
>  at org.apache.hadoop.mapred.Child.main(Child.java:264)
> Caused by: java.lang.ClassNotFoundException: CNTCT_D.class
>  at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>  at java.lang.ClassLoader.loadClass(ClassLo
> 12/02/16 13:57:51 INFO mapred.JobClient: Task Id :
> attempt_201202161202_0005_m_000001_2, Status : FAILED
> java.lang.RuntimeException: java.lang.ClassNotFoundException: CNTCT_D.class
>  at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:996)
>  at
> com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextMapper.java:45)
>  at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)
>  at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)
>  at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
>  at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at javax.security.auth.Subject.doAs(Subject.java:396)
>  at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
>  at org.apache.hadoop.mapred.Child.main(Child.java:264)
> Caused by: java.lang.ClassNotFoundException: CNTCT_D.class
>  at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>  at java.security.AccessController.doPrivileged(Native Method)
>  at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>  at java.lang.ClassLoader.loadClass(ClassLo
> attempt_201202161202_0005_m_000001_2: log4j:WARN No appenders could be
> found for logger (org.apache.hadoop.mapred.Task).
> attempt_201202161202_0005_m_000001_2: log4j:WARN Please initialize the
> log4j system properly.
> 12/02/16 13:58:27 INFO mapred.JobClient: Job complete:
> job_201202161202_0005
> 12/02/16 13:58:28 INFO mapred.JobClient: Counters: 7
> 12/02/16 13:58:28 INFO mapred.JobClient:   Job Counters
> 12/02/16 13:58:28 INFO mapred.JobClient:     SLOTS_MILLIS_MAPS=249623
> 12/02/16 13:58:28 INFO mapred.JobClient:     Total time spent by all
> reduces waiting after reserving slots (ms)=0
> 12/02/16 13:58:28 INFO mapred.JobClient:     Total time spent by all maps
> waiting after reserving slots (ms)=0
> 12/02/16 13:58:28 INFO mapred.JobClient:     Launched map tasks=8
> 12/02/16 13:58:28 INFO mapred.JobClient:     Data-local map tasks=8
> 12/02/16 13:58:28 INFO mapred.JobClient:     SLOTS_MILLIS_REDUCES=0
> 12/02/16 13:58:28 INFO mapred.JobClient:     Failed map tasks=1
> 12/02/16 13:58:28 ERROR tool.MergeTool: MapReduce job failed!
>
> 2. given second import dataset2 corresponding classname..but the same
> error it is also throwing
>
> 3.mentioned with full path for both .class and .jar file
>
> sqoop merge --new-data /home/narasimharao/dataset2 --onto
> /home/narasimharao/dataset1 --target-dir /home/narasimharao/merged
> --jar-file
> /tmp/sqoop-narasimharao/compile/08c0cc665bd3e89124987a7c297827a2/CNTCT_D.jar
> --class-name
> /tmp/sqoop-narasimharao/compile/08c0cc665bd3e89124987a7c297827a2/CNTCT_D.class
> --merge-key CNTCT_ID
> 4.tried the above stmt3 with second dataset .class and .jar files
> also..getting the same errors
>
>
>
> Any Help Appreciated!!!!!!
>
> Thanks,
> Narasimharao
>
>
>

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

hi guys,<div>=A0 =A0 =A0 =A0 =A0 =A0 =A0 Can any one please help me for the=
 below issue.=A0</div><div><br></div><div>Advanced Thanks,</div><div>Narasi=
mharao<br><br><div class=3D"gmail_quote">On Thu, Feb 16, 2012 at 8:24 PM, c=
helikani narasimharao <span dir=3D"ltr">&lt;<a href=3D"mailto:narasimharaoc=
@gmail.com">narasimharaoc@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>Hi All,</div><div>=A0</div><div>=A0=A0=
=A0 I am trying to merge the two datasets using the merge tool functionalit=
y in sqoop.But i got struck up with the following error.</div>
<p><strong><font color=3D"#ff0000">java.lang.RuntimeException: java.lang.Cl=
assNotFoundException: CNTCT_D.class</font></strong></p>
<p><strong><font color=3D"#3333ff">----&gt;below is my command executed to =
get the first data set specifying the location to store the first dataset t=
o dataset1 under narasimharao directory</font></strong></p><p>sqoop import =
--connect jdbc:hpt4jdbc://<a href=3D"http://g4n0401a.houston.hp.com:18650/:=
schema=3DEDW_DEV" target=3D"_blank">g4n0401a.houston.hp.com:18650/:schema=
=3DEDW_DEV</a> --driver com.hp.t4jdbc.HPT4Driver --username <a href=3D"mail=
to:narasimharoa@hp.com" target=3D"_blank">narasimharoa@hp.com</a> -P --verb=
ose --split-by SRC_SYS_KY --table CNTCT_D --where &quot;SRC_SYS_KY=3D363 an=
d CNTCT_ID in(&#39;100838&#39;,&#39;101324&#39;,&#39;101474&#39;,&#39;10221=
2&#39;,&#39;100654&#39;) and ACT_FG=3D&#39;Y&#39;&quot; --target-dir /home/=
narasimharao/dataset1</p>

<p>successfully able to import the dataset1 and also the .class and .jar fi=
les were written to the following location</p><p><strong>/tmp/sqoop-narasim=
harao/compile/08c0cc665bd3e89124987a7c297827a2</strong></p><p><br><strong><=
font color=3D"#3333ff">---&gt;below is my command executed to get the secon=
d data set=A0 after updating the few records which exists in the dataset1 w=
ith the same merge-key</font></strong></p>

<p><br>sqoop import --connect jdbc:hpt4jdbc://<a href=3D"http://g4n0401a.ho=
uston.hp.com:18650/:schema=3DEDW_DEV" target=3D"_blank">g4n0401a.houston.hp=
.com:18650/:schema=3DEDW_DEV</a> --driver com.hp.t4jdbc.HPT4Driver --userna=
me <a href=3D"mailto:narasimharoa.chelikani@hp.com" target=3D"_blank">naras=
imharoa.chelikani@hp.com</a> -P --verbose --split-by SRC_SYS_KY --table CNT=
CT_D --where &quot;SRC_SYS_KY=3D363 and CNTCT_ID in(&#39;100838&#39;,&#39;1=
01324&#39;,&#39;101474&#39;,&#39;102212&#39;,&#39;100654&#39;) and ACT_FG=
=3D&#39;Y&#39;&quot; --target-dir /home/narasimharao/dataset2</p>

<p>successfully able to import the dataset1 and also the .class and .jar fi=
les were written to the following location</p><p><strong>/tmp/sqoop-narasim=
harao/compile/e26282f14a672e7722352fb424781e5a/CNTCT_D.jar</strong></p>

<p><br><strong><font color=3D"#009900">---&gt;Now the actually Sqoop merge =
command was given like below:</font></strong></p><p><strong>sqoop merge --n=
ew-data /home/narasimharao/dataset1 --onto /home/narasimharao/dataset2 --ta=
rget-dir /home/narasimharao/merged --jar-file CNTCT_D.jar --class-name CNTC=
T_D.class --merge-key CNTCT_ID</strong></p>

<p><br>Can you please help me which class name i need to mention over here =
under the class-name attribute and what&#39;s wrong in this statement.</p><=
p>I tried the below options </p><p>1.copied the dataset1 corresponding clas=
s and jar files into my home direcotry and tried like below...but getting t=
he same error as below</p>

<p>sqoop merge --new-data /home/narasimharao/dataset2 --onto /home/narasimh=
arao/dataset1 --target-dir /home/narasimharao/merged --jar-file ./CNTCT_D.j=
ar --class-name CNTCT_D.class --merge-key CNTCT_ID</p><p>Warning: /usr/lib/=
hbase does not exist! HBase imports will fail.<br>

Please set $HBASE_HOME to the root of your HBase installation.</p><p>12/02/=
16 13:56:08 INFO input.FileInputFormat: Total input paths to process : 2<br=
>12/02/16 13:56:08 WARN snappy.LoadSnappy: Snappy native library is availab=
le<br>

12/02/16 13:56:08 INFO util.NativeCodeLoader: Loaded the native-hadoop libr=
ary<br>12/02/16 13:56:08 INFO snappy.LoadSnappy: Snappy native library load=
ed<br>12/02/16 13:56:10 INFO mapred.JobClient: Running job: job_20120216120=
2_0005<br>

12/02/16 13:56:11 INFO mapred.JobClient:=A0 map 0% reduce 0%<br>12/02/16 13=
:56:55 INFO mapred.JobClient: Task Id : attempt_201202161202_0005_m_000000_=
0, Status : FAILED<br><strong><font color=3D"#ff0000">java.lang.RuntimeExce=
ption: java.lang.ClassNotFoundException: CNTCT_D.class<br>

</font></strong>=A0at org.apache.hadoop.conf.Configuration.getClass(Configu=
ration.java:996)<br>=A0at com.cloudera.sqoop.mapreduce.MergeTextMapper.setu=
p(MergeTextMapper.java:45)<br>=A0at org.apache.hadoop.mapreduce.Mapper.run(=
Mapper.java:142)<br>

=A0at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)<br>=
=A0at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)<br>=A0at org.a=
pache.hadoop.mapred.Child$4.run(Child.java:270)<br>=A0at java.security.Acce=
ssController.doPrivileged(Native Method)<br>

=A0at javax.security.auth.Subject.doAs(Subject.java:396)<br>=A0at org.apach=
e.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)=
<br>=A0at org.apache.hadoop.mapred.Child.main(Child.java:264)<br>Caused by:=
 java.lang.ClassNotFoundException: CNTCT_D.class<br>

=A0at java.net.URLClassLoader$1.run(URLClassLoader.java:202)<br>=A0at java.=
security.AccessController.doPrivileged(Native Method)<br>=A0at java.net.URL=
ClassLoader.findClass(URLClassLoader.java:190)<br>=A0at java.lang.ClassLoad=
er.loadClass(ClassLo<br>

12/02/16 13:56:59 INFO mapred.JobClient: Task Id : attempt_201202161202_000=
5_m_000001_0, Status : FAILED<br><strong><font color=3D"#ff0000">java.lang.=
RuntimeException: java.lang.ClassNotFoundException: CNTCT_D.class<br></font=
></strong>=A0at org.apache.hadoop.conf.Configuration.getClass(Configuration=
.java:996)<br>

=A0at com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextMapper.ja=
va:45)<br>=A0at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)<br>=
=A0at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)<br>=
=A0at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)<br>

=A0at org.apache.hadoop.mapred.Child$4.run(Child.java:270)<br>=A0at java.se=
curity.AccessController.doPrivileged(Native Method)<br>=A0at javax.security=
.auth.Subject.doAs(Subject.java:396)<br>=A0at org.apache.hadoop.security.Us=
erGroupInformation.doAs(UserGroupInformation.java:1127)<br>

=A0at org.apache.hadoop.mapred.Child.main(Child.java:264)<br>Caused by: jav=
a.lang.ClassNotFoundException: CNTCT_D.class<br>=A0at java.net.URLClassLoad=
er$1.run(URLClassLoader.java:202)<br>=A0at java.security.AccessController.d=
oPrivileged(Native Method)<br>

=A0at java.net.URLClassLoader.findClass(URLClassLoader.java:190)<br>=A0at j=
ava.lang.ClassLoader.loadClass(ClassLo<br>12/02/16 13:57:22 INFO mapred.Job=
Client: Task Id : attempt_201202161202_0005_m_000000_1, Status : FAILED<br>

java.lang.RuntimeException: java.lang.ClassNotFoundException: CNTCT_D.class=
<br>=A0at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:=
996)<br>=A0at com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextM=
apper.java:45)<br>

=A0at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)<br>=A0at org.=
apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)<br>=A0at org.ap=
ache.hadoop.mapred.MapTask.run(MapTask.java:323)<br>=A0at org.apache.hadoop=
.mapred.Child$4.run(Child.java:270)<br>

=A0at java.security.AccessController.doPrivileged(Native Method)<br>=A0at j=
avax.security.auth.Subject.doAs(Subject.java:396)<br>=A0at org.apache.hadoo=
p.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)<br>=A0=
at org.apache.hadoop.mapred.Child.main(Child.java:264)<br>

Caused by: java.lang.ClassNotFoundException: CNTCT_D.class<br>=A0at java.ne=
t.URLClassLoader$1.run(URLClassLoader.java:202)<br>=A0at java.security.Acce=
ssController.doPrivileged(Native Method)<br>=A0at java.net.URLClassLoader.f=
indClass(URLClassLoader.java:190)<br>

=A0at java.lang.ClassLoader.loadClass(ClassLo<br>12/02/16 13:57:23 INFO map=
red.JobClient: Task Id : attempt_201202161202_0005_m_000001_1, Status : FAI=
LED<br><strong><font color=3D"#ff0000">java.lang.RuntimeException: java.lan=
g.ClassNotFoundException: CNTCT_D.class<br>

</font></strong>=A0at org.apache.hadoop.conf.Configuration.getClass(Configu=
ration.java:996)<br>=A0at com.cloudera.sqoop.mapreduce.MergeTextMapper.setu=
p(MergeTextMapper.java:45)<br>=A0at org.apache.hadoop.mapreduce.Mapper.run(=
Mapper.java:142)<br>

=A0at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)<br>=
=A0at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)<br>=A0at org.a=
pache.hadoop.mapred.Child$4.run(Child.java:270)<br>=A0at java.security.Acce=
ssController.doPrivileged(Native Method)<br>

=A0at javax.security.auth.Subject.doAs(Subject.java:396)<br>=A0at org.apach=
e.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)=
<br>=A0at org.apache.hadoop.mapred.Child.main(Child.java:264)<br>Caused by:=
 java.lang.ClassNotFoundException: CNTCT_D.class<br>

=A0at java.net.URLClassLoader$1.run(URLClassLoader.java:202)<br>=A0at java.=
security.AccessController.doPrivileged(Native Method)<br>=A0at java.net.URL=
ClassLoader.findClass(URLClassLoader.java:190)<br>=A0at java.lang.ClassLoad=
er.loadClass(ClassLo<br>

12/02/16 13:57:50 INFO mapred.JobClient: Task Id : attempt_201202161202_000=
5_m_000000_2, Status : FAILED<br><strong><font color=3D"#ff0000">java.lang.=
RuntimeException: java.lang.ClassNotFoundException: CNTCT_D.class<br></font=
></strong>=A0at org.apache.hadoop.conf.Configuration.getClass(Configuration=
.java:996)<br>

=A0at com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextMapper.ja=
va:45)<br>=A0at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)<br>=
=A0at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)<br>=
=A0at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)<br>

=A0at org.apache.hadoop.mapred.Child$4.run(Child.java:270)<br>=A0at java.se=
curity.AccessController.doPrivileged(Native Method)<br>=A0at javax.security=
.auth.Subject.doAs(Subject.java:396)<br>=A0at org.apache.hadoop.security.Us=
erGroupInformation.doAs(UserGroupInformation.java:1127)<br>

=A0at org.apache.hadoop.mapred.Child.main(Child.java:264)<br>Caused by: jav=
a.lang.ClassNotFoundException: CNTCT_D.class<br>=A0at java.net.URLClassLoad=
er$1.run(URLClassLoader.java:202)<br>=A0at java.security.AccessController.d=
oPrivileged(Native Method)<br>

=A0at java.net.URLClassLoader.findClass(URLClassLoader.java:190)<br>=A0at j=
ava.lang.ClassLoader.loadClass(ClassLo<br>12/02/16 13:57:51 INFO mapred.Job=
Client: Task Id : attempt_201202161202_0005_m_000001_2, Status : FAILED<br>

java.lang.RuntimeException: java.lang.ClassNotFoundException: CNTCT_D.class=
<br>=A0at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:=
996)<br>=A0at com.cloudera.sqoop.mapreduce.MergeTextMapper.setup(MergeTextM=
apper.java:45)<br>

=A0at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:142)<br>=A0at org.=
apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:647)<br>=A0at org.ap=
ache.hadoop.mapred.MapTask.run(MapTask.java:323)<br>=A0at org.apache.hadoop=
.mapred.Child$4.run(Child.java:270)<br>

=A0at java.security.AccessController.doPrivileged(Native Method)<br>=A0at j=
avax.security.auth.Subject.doAs(Subject.java:396)<br>=A0at org.apache.hadoo=
p.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)<br>=A0=
at org.apache.hadoop.mapred.Child.main(Child.java:264)<br>

Caused by: java.lang.ClassNotFoundException: CNTCT_D.class<br>=A0at java.ne=
t.URLClassLoader$1.run(URLClassLoader.java:202)<br>=A0at java.security.Acce=
ssController.doPrivileged(Native Method)<br>=A0at java.net.URLClassLoader.f=
indClass(URLClassLoader.java:190)<br>

=A0at java.lang.ClassLoader.loadClass(ClassLo<br>attempt_201202161202_0005_=
m_000001_2: log4j:WARN No appenders could be found for logger (org.apache.h=
adoop.mapred.Task).<br>attempt_201202161202_0005_m_000001_2: log4j:WARN Ple=
ase initialize the log4j system properly.<br>

12/02/16 13:58:27 INFO mapred.JobClient: Job complete: job_201202161202_000=
5<br>12/02/16 13:58:28 INFO mapred.JobClient: Counters: 7<br>12/02/16 13:58=
:28 INFO mapred.JobClient:=A0=A0 Job Counters <br>12/02/16 13:58:28 INFO ma=
pred.JobClient:=A0=A0=A0=A0 SLOTS_MILLIS_MAPS=3D249623<br>

12/02/16 13:58:28 INFO mapred.JobClient:=A0=A0=A0=A0 Total time spent by al=
l reduces waiting after reserving slots (ms)=3D0<br>12/02/16 13:58:28 INFO =
mapred.JobClient:=A0=A0=A0=A0 Total time spent by all maps waiting after re=
serving slots (ms)=3D0<br>

12/02/16 13:58:28 INFO mapred.JobClient:=A0=A0=A0=A0 Launched map tasks=3D8=
<br>12/02/16 13:58:28 INFO mapred.JobClient:=A0=A0=A0=A0 Data-local map tas=
ks=3D8<br>12/02/16 13:58:28 INFO mapred.JobClient:=A0=A0=A0=A0 SLOTS_MILLIS=
_REDUCES=3D0<br>12/02/16 13:58:28 INFO mapred.JobClient:=A0=A0=A0=A0 Failed=
 map tasks=3D1<br>

12/02/16 13:58:28 ERROR tool.MergeTool: MapReduce job failed!</p><p>2. give=
n second import dataset2 corresponding classname..but the same error it is =
also throwing</p><p>3.mentioned with full path for both .class and .jar fil=
e</p>

<p>sqoop merge --new-data /home/narasimharao/dataset2 --onto /home/narasimh=
arao/dataset1 --target-dir /home/narasimharao/merged --jar-file /tmp/sqoop-=
narasimharao/compile/08c0cc665bd3e89124987a7c297827a2/CNTCT_D.jar --class-n=
ame /tmp/sqoop-narasimharao/compile/08c0cc665bd3e89124987a7c297827a2/CNTCT_=
D.class --merge-key CNTCT_ID</p>

<div>4.tried the above stmt3 with second dataset .class and .jar files also=
..getting the same errors</div><div>=A0</div><div>=A0</div><div>=A0</div><d=
iv>Any Help Appreciated!!!!!!</div><div>=A0</div><div>Thanks,</div><div>Nar=
asimharao</div>

<p>=A0</p>
</blockquote></div><br></div>

--047d7b2ed88781734c04b985f5ab--