From user-return-1179-apmail-sqoop-user-archive=sqoop.apache.org@sqoop.apache.org Tue May 21 12:56:43 2013 Return-Path: X-Original-To: apmail-sqoop-user-archive@www.apache.org Delivered-To: apmail-sqoop-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 706F5DC8C for ; Tue, 21 May 2013 12:56:43 +0000 (UTC) Received: (qmail 88829 invoked by uid 500); 21 May 2013 12:56:43 -0000 Delivered-To: apmail-sqoop-user-archive@sqoop.apache.org Received: (qmail 88741 invoked by uid 500); 21 May 2013 12:56:43 -0000 Mailing-List: contact user-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@sqoop.apache.org Delivered-To: mailing list user@sqoop.apache.org Received: (qmail 88720 invoked by uid 99); 21 May 2013 12:56:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 May 2013 12:56:42 +0000 X-ASF-Spam-Status: No, hits=2.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_REPLYTO_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.136.218.147] (HELO nm3-vm4.bullet.mail.gq1.yahoo.com) (98.136.218.147) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 May 2013 12:56:37 +0000 Received: from [98.137.12.62] by nm3.bullet.mail.gq1.yahoo.com with NNFMP; 21 May 2013 12:56:16 -0000 Received: from [98.137.12.233] by tm7.bullet.mail.gq1.yahoo.com with NNFMP; 21 May 2013 12:56:16 -0000 Received: from [127.0.0.1] by omp1041.mail.gq1.yahoo.com with NNFMP; 21 May 2013 12:56:16 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 915870.4788.bm@omp1041.mail.gq1.yahoo.com Received: (qmail 13373 invoked by uid 60001); 21 May 2013 12:56:16 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1369140976; bh=6u3KGv3o9DmiUVCCXSXA7ePeqgn5hYwPCuZM47JR9o8=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=sCW1NHOKIviAiCJ5/JFKLvTUO+SNy8OUUU6EGEHoaaAjC+F3lbqEf4eZeJ2rcg2HksU5/Km2qWK9R3wk6mai+Orf5tcZuXyWFt76Dss6unXxGE5AUAPHt5yaju8CTLBSjOQ4zew3lHG7JAmB7lhEpWB8RdrAeJUY+OgGyQuQmQ4= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=PpvuHe1A23/g4oW+89RUjfSY3KU8M7v+MsO0TM/5lDqLbKVoyx45JFdBqkM35dNiinWNUe5mkOLJcrsXGIREtAXJ/p+Z9a9wJCDPJBu9XPvBmLBf1IYriaFTnYhTURKriC632d63V0N0Efh3YTgoGfb4mKoG42wAS11Aii0huWE=; X-YMail-OSG: 0VQB1ZAVM1llrZzXUzhlUVzIgfjVVDfcahTL1TRj1eJUZNA hez0dr47_JgBayLQzGjKeuzdFwj8_HnD6vEguF4FscwFKdDSsCUgyHvDeInb SzQ6Vko14faqMTYs4crYQRVIlupPZg8Q2rXY0GUKyUtJH9Vq0IXPjiEip2rD 8Fqgwim2lVFRuMqyP9pgIXj2xoH.zklUCKiyCp_lLDE1iVoX1CejbK09VlNE wEtVtm74L0ZWPeXNDJt957.AE79FN8_z9RsnxUKKwKKFAf7UTwlY6pWWdq6a H0Z_BlTNDia.lQbOp53VaNsDezJtWRzV.2Kp5O._wJ5wMBYTDvCKOiDD..t5 _xER0pKh41vU9MUnjz_YlrS9TtTf6zkqJ0Zqebp9VgIbFp6egGz3nAWnRd9Z RHsMvHIgvOyy6RiNtWBa7xBRYu82O56r3.VvP14dyGz_Cld2EMAAoBV.VAfR cQG9ioyFNLw1tH9CpuupdO9j1SRdiQAziNSCXW_tlsaEce5jGL70764v9qh4 FfWiciNlZGykCORBDSieV9G3HYfpFRtpctIFcEhqd5Mvq98E5E8dCrrIMBXR TtWHblvmbWTk7_0uSMke6FMScpnSkmdTvGq6KW8igVC5CJDzwPExdQNia8eK Px6yzxSgJ2JVCIZEChW5qyKHTO0vgBTEXAsw7bRpwVoZXHeW8JQwQQy9zFHN igzBY.5dJGt.GzSNRCuJj_CpBK2BNfIKyqXnXtEf_INT8oAh1aqvYcKcmCBY q.cQsg60- Received: from [99.238.18.148] by web163901.mail.gq1.yahoo.com via HTTP; Tue, 21 May 2013 05:56:16 PDT X-Rocket-MIMEInfo: 002.001,R3JlZXRpbmcgZXhwZXJ0cywKCsKgwqAgSSBoYXZlIGEgdGFibGUgIkNIUllTTEVSX0FuYW1ldHJpeF9BZ2dyZWdhdGVkIiBpbiBIaXZlIGFuZCBpbiBNeVNRTC4gClNpbWlsYXJseSBJIGNhbiBmaW5kIHRoaXMgdGFibGUgaW4gaGRmcyAtLSAKL3VzZXIvaGl2ZS93YXJlaG91c2UvY2hyeXNsZXJfYW5hbWV0cml4X2FnZ3JlZ2F0ZWQuCgoKwqDCoCBJIGNhbiBzdWNjZXNzZnVsbHkgZXhlY3V0ZSB0aGUgZm9sbG93aW5nIFNRT09QIGNvbW1hbmQgZnJvbSBuYW1lbm9kZSBDTEkgLQoKwqDCoCBzcW9vcCBleHBvcnQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.142.542 Message-ID: <1369140976.13284.YahooMailNeo@web163901.mail.gq1.yahoo.com> Date: Tue, 21 May 2013 05:56:16 -0700 (PDT) From: Han Sen Tey Reply-To: Han Sen Tey Subject: SQOOP export from Hadoop Hive to MySQL To: "user@sqoop.apache.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1137503753-1610986544-1369140976=:13284" X-Virus-Checked: Checked by ClamAV on apache.org ---1137503753-1610986544-1369140976=:13284 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Greeting experts,=0A=0A=A0=A0 I have a table "CHRYSLER_Anametrix_Aggregated= " in Hive and in MySQL. =0ASimilarly I can find this table in hdfs -- =0A/u= ser/hive/warehouse/chrysler_anametrix_aggregated.=0A=0A=0A=A0=A0 I can succ= essfully execute the following SQOOP command from namenode CLI -=0A=0A=A0= =A0 sqoop export --verbose --connect =0Ajdbc:mysql://ec2-23-22-223-47.compu= te-1.amazonaws.com:3306/test --table =0ACHRYSLER_Anametrix_Aggregated --upd= ate-key =0AVisitorID,VisitorDay,VisitorMonth,VisitorYear,VisitorSession =0A= --update-mode allowinsert --export-dir =0A/user/hive/warehouse/chrysler_ana= metrix_aggregated --username root -m 1 =0A--input-fields-terminated-by '|' = --input-null-string '\\N' =0A--input-null-non-string '\\N'=0A=0A=A0=A0 Howe= ver, when I want to run the above as part of Oozie workflow action ... =0A= =0A=0A=A0=A0=A0 =0A=A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = ${jobTracker}=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 ${nameNode}=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =0A =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 sqoop= .connection.factories=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 com.cloudera.sqoop.manager.DefaultManagerFactory=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=0A mapred.job.queue.name= =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ${queue= Name}=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 mapred.compress.map.out= put=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 true=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=0A =0A=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 oozie.service.Workfl= owAppService.system.libpath=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 ${nameNode}/user/oozie/share/lib/sqoop= =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =0A export --verbose --connect =0Ajdbc:mysql://ec2-23-22-223-47.co= mpute-1.amazonaws.com:3306/test --table =0ACHRYSLER_Anametrix_Aggregated --= update-key =0AVisitorID,VisitorDay,VisitorMonth,VisitorYear,VisitorSession = =0A--update-mode allowinsert --export-dir=0A /user/hive/warehouse/chrysler_= anametrix_aggregated --username root -m 1=0A --input-fields-terminated-by '= |' --input-null-string '\\N' =0A--input-null-non-string '\\N'=0A= =A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0=A0=A0=A0=A0=A0 =0A= =A0=A0=A0=A0=A0=A0=A0 =0A=A0=A0=A0 =0A=0A=A0= =A0 I get the following error message. I have "mysql-connector-java.5.1.24-= bin.jar" shared library - /user/oozie/share/lib/sqoop.=0A=0A=A0=A0 Hadoop v= ersion - 2.00 - CDH4.2.0=0A=A0=A0 Sqoop version - 1.4.2. - CDH4.2.0=0A=0A= =0A=A0=A0 Can you experts please guide me=A0 ... a rookie to Hadoop and its= projects.=0A=0A2013-05-21 00:48:35,135 WARN mapreduce.Counters: Group org.= apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapr= educe.TaskCounter instead 2013-05-21 00:48:37,394 WARN org.apache.hadoop.co= nf.Configuration: session.id is deprecated. Instead, use dfs.metrics.sessio= n-id 2013-05-21 00:48:37,408 INFO org.apache.hadoop.metrics.jvm.JvmMetrics:= Initializing JVM Metrics with processName=3DMAP, sessionId=3D 2013-05-21 0= 0:48:38,042 INFO org.apache.hadoop.util.ProcessTree: setsid exited with exi= t code 0 2013-05-21 00:48:38,058 INFO org.apache.hadoop.mapred.Task: Using= ResourceCalculatorPlugin : org.apache.hadoop.util.LinuxResourceCalculatorP= lugin@5dce1bea 2013-05-21 00:48:38,423 INFO org.apache.hadoop.mapred.MapTas= k: Processing split: hdfs://ip-10-147-191-48.ec2.internal:8020/user/ubuntu/= oozie-oozi/0000042-130520131050057-oozie-oozi-W/sqoop-node--sqoop/input/dum= my.txt:0+5 2013-05-21 00:48:38,453 WARN mapreduce.Counters: Counter name MA= P_INPUT_BYTES is deprecated. Use FileInputFormatCounters as group name and BYTES_READ a= s counter name instead 2013-05-21 00:48:38,459 INFO org.apache.hadoop.mapre= d.MapTask: numReduceTasks: 0 2013-05-21 00:48:39,743 WARN org.apache.sqoop.= tool.SqoopTool: $SQOOP_CONF_DIR has not been set in the environment. Cannot= check for additional configuration. 2013-05-21 00:48:40,032 DEBUG org.apac= he.sqoop.tool.BaseSqoopTool: Enabled debug logging. 2013-05-21 00:48:40,036= WARN org.apache.sqoop.SqoopOptions: Character argument '|' has multiple ch= aracters; only the first will be used. 2013-05-21 00:48:40,084 DEBUG org.ap= ache.sqoop.ConnFactory: sqoop.connection.factories is set; ignoring manager= s.d 2013-05-21 00:48:40,139 DEBUG org.apache.sqoop.ConnFactory: Loaded mana= ger factory: com.cloudera.sqoop.manager.DefaultManagerFactory 2013-05-21 00= :48:40,139 DEBUG org.apache.sqoop.ConnFactory: Trying ManagerFactory: com.c= loudera.sqoop.manager.DefaultManagerFactory 2013-05-21 00:48:40,140 DEBUG org.apache.sqoop.manager.DefaultManagerFactory: Trying with scheme: = jdbc:mysql: 2013-05-21 00:48:40,183 INFO org.apache.sqoop.manager.MySQLMana= ger: Preparing to use a MySQL streaming resultset. 2013-05-21 00:48:40,183 = DEBUG org.apache.sqoop.ConnFactory: Instantiated ConnManager org.apache.sqo= op.manager.MySQLManager@795e0c2b 2013-05-21 00:48:40,184 INFO org.apache.sq= oop.tool.CodeGenTool: Beginning code generation 2013-05-21 00:48:40,233 DEB= UG org.apache.sqoop.manager.SqlManager: No connection paramenters specified= . Using regular API for making connection. 2013-05-21 00:48:40,911 DEBUG or= g.apache.sqoop.manager.SqlManager: Using fetchSize for next query: -2147483= 648 2013-05-21 00:48:40,911 INFO org.apache.sqoop.manager.SqlManager: Execu= ting SQL statement: SELECT t.* FROM `CHRYSLER_Anametrix_Aggregated` AS t LI= MIT 1 2013-05-21 00:48:40,930 DEBUG org.apache.sqoop.orm.ClassWriter: selec= ted columns: 2013-05-21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter: VisitorID 2013-05-21 00:48:40,931 DEBU= G org.apache.sqoop.orm.ClassWriter: VisitorDay 2013-05-21 00:48:40,931 DE= BUG org.apache.sqoop.orm.ClassWriter: VisitorMonth 2013-05-21 00:48:40,93= 1 DEBUG org.apache.sqoop.orm.ClassWriter: VisitorYear 2013-05-21 00:48:40= ,931 DEBUG org.apache.sqoop.orm.ClassWriter: VisitorSession 2013-05-21 00= :48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter: Brand 2013-05-21 00:48= :40,931 DEBUG org.apache.sqoop.orm.ClassWriter: DeviceType 2013-05-21 00:= 48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter: DeviceBrowser 2013-05-2= 1 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter: TrafficSource 2013= -05-21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter: SiteID 2013-0= 5-21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter: BuyID 2013-05-2= 1 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter: AdvertisementID 20= 13-05-21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter: =20 PlacementID 2013-05-21 00:48:40,934 DEBUG org.apache.sqoop.orm.ClassWriter= : CreativeID 2013-05-21 00:48:40,934 DEBUG org.apache.sqoop.orm.ClassWrit= er: PaidKeyword 2013-05-21 00:48:40,934 DEBUG org.apache.sqoop.orm.ClassW= riter: Model200 2013-05-21 00:48:40,934 DEBUG org.apache.sqoop.orm.ClassW= riter: Model200Conv 2013-05-21 00:48:40,934 DEBUG org.apache.sqoop.orm.Cl= assWriter: Model300 2013-05-21 00:48:40,934 DEBUG org.apache.sqoop.orm.Cl= assWriter: Model300TownCountry 2013-05-21 00:48:40,934 DEBUG org.apache.s= qoop.orm.ClassWriter: BMOLineup 2013-05-21 00:48:40,935 DEBUG org.apache.= sqoop.orm.ClassWriter: BMOModels 2013-05-21 00:48:40,935 DEBUG org.apache= .sqoop.orm.ClassWriter: BMOColors 2013-05-21 00:48:40,935 DEBUG org.apach= e.sqoop.orm.ClassWriter: BMOOptions 2013-05-21 00:48:40,935 DEBUG org.apa= che.sqoop.orm.ClassWriter: BMOSummary 2013-05-21 00:48:40,935 DEBUG org.a= pache.sqoop.orm.ClassWriter: BrochureLineup 2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWriter: BrochureForm 2013-0= 5-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWriter: BrochureMailLin= k 2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWriter: Brochur= eDownloadLink 2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWrite= r: PreDL 2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWriter: = DealerLocate 2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWrit= er: DLHours 2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWrite= r: DLServices 2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.orm.ClassWri= ter: DLDealerSite 2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.orm.Clas= sWriter: PreSNI 2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.orm.ClassW= riter: SearchNewInventory 2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.= orm.ClassWriter: SNIVIN 2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.or= m.ClassWriter: SNIDetails 2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.orm.ClassWriter: SNIDealer 2013-05-21 00:48:40,936 DEBU= G org.apache.sqoop.orm.ClassWriter: TestDriveForm 2013-05-21 00:48:40,936= DEBUG org.apache.sqoop.orm.ClassWriter: TestDriveComplete 2013-05-21 00:= 48:40,936 DEBUG org.apache.sqoop.orm.ClassWriter: Inventives 2013-05-21 0= 0:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: PreCal 2013-05-21 00:= 48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: PaymentCalculator 2013-= 05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: PreGAQ 2013-05= -21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: GetAQuote 2013-0= 5-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: LandingPage 201= 3-05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: Models 2013-= 05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: PhotosGallery = 2013-05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: Interior = 2013-05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: =20 Exterior 2013-05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter: = Performance 2013-05-21 00:48:40,938 DEBUG org.apache.sqoop.orm.ClassWriter= : Safety 2013-05-21 00:48:40,938 DEBUG org.apache.sqoop.orm.ClassWriter: = Specifications 2013-05-21 00:48:40,938 DEBUG org.apache.sqoop.orm.ClassWr= iter: ModelHighlights 2013-05-21 00:48:40,938 DEBUG org.apache.sqoop.orm.= ClassWriter: Dimensions 2013-05-21 00:48:40,938 DEBUG org.apache.sqoop.or= m.ClassWriter: Warranty 2013-05-21 00:48:40,965 DEBUG org.apache.sqoop.ma= nager.SqlManager: Using fetchSize for next query: -2147483648 2013-05-21 00= :48:40,965 INFO org.apache.sqoop.manager.SqlManager: Executing SQL statemen= t: SELECT t.* FROM `CHRYSLER_Anametrix_Aggregated` AS t LIMIT 1 2013-05-21 = 00:48:40,990 DEBUG org.apache.sqoop.orm.ClassWriter: Writing source file: /= tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/CHRYSLER_Anametri= x_Aggregated.java 2013-05-21 00:48:40,990 DEBUG org.apache.sqoop.orm.ClassWriter: Table name: CHRYSLER_Anametrix_Aggregate= d 2013-05-21 00:48:40,990 DEBUG org.apache.sqoop.orm.ClassWriter: Columns: = VisitorID:12, VisitorDay:12, VisitorMonth:12, VisitorYear:12, VisitorSessio= n:4, Brand:12, DeviceType:12, DeviceBrowser:12, TrafficSource:12, SiteID:12= , BuyID:12, AdvertisementID:12, PlacementID:12, CreativeID:12, PaidKeyword:= 12, Model200:4, Model200Conv:4, Model300:4, Model300TownCountry:4, BMOLineu= p:4, BMOModels:4, BMOColors:4, BMOOptions:4, BMOSummary:4, BrochureLineup:4= , BrochureForm:4, BrochureMailLink:4, BrochureDownloadLink:4, PreDL:4, Deal= erLocate:4, DLHours:4, DLServices:4, DLDealerSite:4, PreSNI:4, SearchNewInv= entory:4, SNIVIN:4, SNIDetails:4, SNIDealer:4, TestDriveForm:4, TestDriveCo= mplete:4, Inventives:4, PreCal:4, PaymentCalculator:4, PreGAQ:4, GetAQuote:= 4, LandingPage:4, Models:4, PhotosGallery:4, Interior:4, Exterior:4, Perfor= mance:4, Safety:4, Specifications:4, ModelHighlights:4, Dimensions:4, Warranty:4, 2013-05-21 00:48:40,990 DEBUG org.apache.sqoop.o= rm.ClassWriter: sourceFilename is CHRYSLER_Anametrix_Aggregated.java 2013-0= 5-21 00:48:40,991 DEBUG org.apache.sqoop.orm.CompilationManager: Found exis= ting /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/ 2013-05-21= 00:48:40,992 INFO org.apache.sqoop.orm.CompilationManager: $HADOOP_MAPRED_= HOME is not set 2013-05-21 00:48:41,098 DEBUG org.apache.sqoop.orm.Compilat= ionManager: Adding source file: /tmp/sqoop-mapred/compile/f9c22cb042b8b020c= 4190df2f8e30bca/CHRYSLER_Anametrix_Aggregated.java 2013-05-21 00:48:41,098 = DEBUG org.apache.sqoop.orm.CompilationManager: Invoking javac with args: 20= 13-05-21 00:48:41,098 DEBUG org.apache.sqoop.orm.CompilationManager: -sou= rcepath 2013-05-21 00:48:41,098 DEBUG org.apache.sqoop.orm.CompilationManag= er: /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/ 2013-05-2= 1 00:48:41,098 DEBUG org.apache.sqoop.orm.CompilationManager: -d 2013-05-21 00:48:41,099 DEBUG org.apache.sqoop.orm.CompilationManager: /= tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/ 2013-05-21 00:48= :41,099 DEBUG org.apache.sqoop.orm.CompilationManager: -classpath 2013-05= -21 00:48:41,099 DEBUG org.apache.sqoop.orm.CompilationManager: =20 /run/cloudera-scm-agent/process/76-mapreduce-TASKTRACKER:/usr/lib/jvm/j2sd= k1.6-oracle/lib/tools.jar:/usr/lib/hadoop-0.20-mapreduce:/usr/lib/hadoop-0.= 20-mapreduce/hadoop-core-2.0.0-mr1-cdh4.2.0.jar:/usr/lib/hadoop-0.20-mapred= uce/lib/activation-1.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/ant-contrib-1= .0b3.jar:/usr/lib/hadoop-0.20-mapreduce/lib/asm-3.2.jar:/usr/lib/hadoop-0.2= 0-mapreduce/lib/aspectjrt-1.6.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/aspe= ctjtools-1.6.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/avro-1.7.3.jar:/usr/l= ib/hadoop-0.20-mapreduce/lib/avro-compiler-1.7.3.jar:/usr/lib/hadoop-0.20-m= apreduce/lib/commons-beanutils-1.7.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib= /commons-beanutils-core-1.8.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/common= s-cli-1.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-codec-1.4.jar:/usr= /lib/hadoop-0.20-mapreduce/lib/commons-collections-3.2.1.jar:/usr/lib/hadoo= p-0.20-mapreduce/lib/commons-configuration-1.6.jar:/usr/lib/hadoop-=0A0.20-= mapreduce/lib/commons-digester-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/c= ommons-el-1.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-httpclient-3.1= .jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-io-2.1.jar:/usr/lib/hadoop-= 0.20-mapreduce/lib/commons-lang-2.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/= commons-logging-1.1.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-math-2= .1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-net-3.1.jar:/usr/lib/hado= op-0.20-mapreduce/lib/guava-11.0.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/h= adoop-fairscheduler-2.0.0-mr1-cdh4.2.0.jar:/usr/lib/hadoop-0.20-mapreduce/l= ib/hsqldb-1.8.0.10.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jackson-core-asl-= 1.8.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jackson-jaxrs-1.8.8.jar:/usr/l= ib/hadoop-0.20-mapreduce/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hadoop-0= .20-mapreduce/lib/jackson-xc-1.8.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/j= asper-compiler-5.5.23.jar:/usr/lib/hadoop-0.20-mapreduce/lib/j=0Aasper-runt= ime-5.5.23.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jaxb-api-2.2.2.jar:/usr/l= ib/hadoop-0.20-mapreduce/lib/jaxb-impl-2.2.3-1.jar:/usr/lib/hadoop-0.20-map= reduce/lib/jersey-core-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jersey-js= on-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jersey-server-1.8.jar:/usr/li= b/hadoop-0.20-mapreduce/lib/jets3t-0.6.1.jar:/usr/lib/hadoop-0.20-mapreduce= /lib/jettison-1.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jetty-6.1.26.cloud= era.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jetty-util-6.1.26.cloudera.2.j= ar:/usr/lib/hadoop-0.20-mapreduce/lib/jline-0.9.94.jar:/usr/lib/hadoop-0.20= -mapreduce/lib/jsch-0.1.42.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jsp-api-2= .1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jsr305-1.3.9.jar:/usr/lib/hadoop-= 0.20-mapreduce/lib/junit-4.8.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/kfs-0= .2.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/kfs-0.3.jar:/usr/lib/hadoop-0.2= 0-mapreduce/lib/log4j-1.2.17.jar:/usr/lib/hadoop-0.20-map=0Areduce/lib/mock= ito-all-1.8.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/paranamer-2.3.jar:/usr= /lib/hadoop-0.20-mapreduce/lib/protobuf-java-2.4.0a.jar:/usr/lib/hadoop-0.2= 0-mapreduce/lib/servlet-api-2.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/slf4= j-api-1.6.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/snappy-java-1.0.4.1.jar:= /usr/lib/hadoop-0.20-mapreduce/lib/stax-api-1.0.1.jar:/usr/lib/hadoop-0.20-= mapreduce/lib/xmlenc-0.52.jar:/usr/lib/hadoop-0.20-mapreduce/lib/zookeeper-= 3.4.5-cdh4.2.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jsp-2.1/jsp-2.1.jar:/= usr/lib/hadoop-0.20-mapreduce/lib/jsp-2.1/jsp-api-2.1.jar:/usr/share/cmf/li= b/plugins/navigator-plugin-4.5.1-shaded.jar:/usr/share/cmf/lib/plugins/even= t-publish-4.5.1-shaded.jar:/usr/share/cmf/lib/plugins/tt-instrumentation-4.= 5.1.jar:/usr/lib/hadoop-hdfs/lib/jsp-api-2.1.jar:/usr/lib/hadoop-hdfs/lib/l= og4j-1.2.17.jar:/usr/lib/hadoop-hdfs/lib/jetty-util-6.1.26.cloudera.2.jar:/= usr/lib/hadoop-hdfs/lib/jetty-6.1.26.cloudera.2.jar:=0A/usr/lib/hadoop-hdfs= /lib/jersey-core-1.8.jar:/usr/lib/hadoop-hdfs/lib/jsr305-1.3.9.jar:/usr/lib= /hadoop-hdfs/lib/protobuf-java-2.4.0a.jar:/usr/lib/hadoop-hdfs/lib/servlet-= api-2.5.jar:/usr/lib/hadoop-hdfs/lib/xmlenc-0.52.jar:/usr/lib/hadoop-hdfs/l= ib/commons-io-2.1.jar:/usr/lib/hadoop-hdfs/lib/jline-0.9.94.jar:/usr/lib/ha= doop-hdfs/lib/commons-cli-1.2.jar:/usr/lib/hadoop-hdfs/lib/jasper-runtime-5= .5.23.jar:/usr/lib/hadoop-hdfs/lib/commons-codec-1.4.jar:/usr/lib/hadoop-hd= fs/lib/zookeeper-3.4.5-cdh4.2.0.jar:/usr/lib/hadoop-hdfs/lib/commons-daemon= -1.0.3.jar:/usr/lib/hadoop-hdfs/lib/asm-3.2.jar:/usr/lib/hadoop-hdfs/lib/co= mmons-lang-2.5.jar:/usr/lib/hadoop-hdfs/lib/jackson-mapper-asl-1.8.8.jar:/u= sr/lib/hadoop-hdfs/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hadoop-hdfs/lib/= commons-logging-1.1.1.jar:/usr/lib/hadoop-hdfs/lib/jersey-server-1.8.jar:/u= sr/lib/hadoop-hdfs/lib/guava-11.0.2.jar:/usr/lib/hadoop-hdfs/lib/commons-el= -1.0.jar:/usr/lib/hadoop-hdfs/hadoop-hdfs.jar:/=0Ausr/lib/hadoop-hdfs/hadoo= p-hdfs-2.0.0-cdh4.2.0.jar:/usr/lib/hadoop-hdfs/hadoop-hdfs-2.0.0-cdh4.2.0-t= ests.jar:/usr/lib/hadoop/lib/jsp-api-2.1.jar:/usr/lib/hadoop/lib/avro-1.7.3= .jar:/usr/lib/hadoop/lib/log4j-1.2.17.jar:/usr/lib/hadoop/lib/jackson-jaxrs= -1.8.8.jar:/usr/lib/hadoop/lib/jetty-util-6.1.26.cloudera.2.jar:/usr/lib/ha= doop/lib/jetty-6.1.26.cloudera.2.jar:/usr/lib/hadoop/lib/jersey-core-1.8.ja= r:/usr/lib/hadoop/lib/paranamer-2.3.jar:/usr/lib/hadoop/lib/commons-digeste= r-1.8.jar:/usr/lib/hadoop/lib/activation-1.1.jar:/usr/lib/hadoop/lib/common= s-collections-3.2.1.jar:/usr/lib/hadoop/lib/jsr305-1.3.9.jar:/usr/lib/hadoo= p/lib/protobuf-java-2.4.0a.jar:/usr/lib/hadoop/lib/servlet-api-2.5.jar:/usr= /lib/hadoop/lib/commons-beanutils-1.7.0.jar:/usr/lib/hadoop/lib/xmlenc-0.52= .jar:/usr/lib/hadoop/lib/commons-io-2.1.jar:/usr/lib/hadoop/lib/jline-0.9.9= 4.jar:/usr/lib/hadoop/lib/mockito-all-1.8.5.jar:/usr/lib/hadoop/lib/commons= -cli-1.2.jar:/usr/lib/hadoop/lib/commons-c=0Aonfiguration-1.6.jar:/usr/lib/= hadoop/lib/jasper-runtime-5.5.23.jar:/usr/lib/hadoop/lib/jasper-compiler-5.= 5.23.jar:/usr/lib/hadoop/lib/jackson-xc-1.8.8.jar:/usr/lib/hadoop/lib/commo= ns-codec-1.4.jar:/usr/lib/hadoop/lib/jaxb-api-2.2.2.jar:/usr/lib/hadoop/lib= /zookeeper-3.4.5-cdh4.2.0.jar:/usr/lib/hadoop/lib/commons-httpclient-3.1.ja= r:/usr/lib/hadoop/lib/slf4j-api-1.6.1.jar:/usr/lib/hadoop/lib/commons-math-= 2.1.jar:/usr/lib/hadoop/lib/jettison-1.1.jar:/usr/lib/hadoop/lib/jaxb-impl-= 2.2.3-1.jar:/usr/lib/hadoop/lib/stax-api-1.0.1.jar:/usr/lib/hadoop/lib/comm= ons-beanutils-core-1.8.0.jar:/usr/lib/hadoop/lib/asm-3.2.jar:/usr/lib/hadoo= p/lib/commons-lang-2.5.jar:/usr/lib/hadoop/lib/commons-net-3.1.jar:/usr/lib= /hadoop/lib/junit-4.8.2.jar:/usr/lib/hadoop/lib/jackson-mapper-asl-1.8.8.ja= r:/usr/lib/hadoop/lib/slf4j-log4j12-1.6.1.jar:/usr/lib/hadoop/lib/snappy-ja= va-1.0.4.1.jar:/usr/lib/hadoop/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hado= op/lib/jets3t-0.6.1.jar:/usr/lib/hado=0Aop/lib/hue-plugins-2.2.0-cdh4.2.0.j= ar:/usr/lib/hadoop/lib/kfs-0.3.jar:/usr/lib/hadoop/lib/commons-logging-1.1.= 1.jar:/usr/lib/hadoop/lib/jsch-0.1.42.jar:/usr/lib/hadoop/lib/jersey-server= -1.8.jar:/usr/lib/hadoop/lib/jersey-json-1.8.jar:/usr/lib/hadoop/lib/guava-= 11.0.2.jar:/usr/lib/hadoop/lib/commons-el-1.0.jar:/usr/lib/hadoop/hadoop-au= th.jar:/usr/lib/hadoop/hadoop-auth-2.0.0-cdh4.2.0.jar:/usr/lib/hadoop/hadoo= p-annotations.jar:/usr/lib/hadoop/hadoop-common-2.0.0-cdh4.2.0-tests.jar:/u= sr/lib/hadoop/hadoop-annotations-2.0.0-cdh4.2.0.jar:/usr/lib/hadoop/hadoop-= common-2.0.0-cdh4.2.0.jar:/usr/lib/hadoop/hadoop-common.jar:/mnt/mapred/loc= al/taskTracker/distcache/-3359360379488511723_1277082233_1150217957/ip-10-1= 47-191-48.ec2.internal/user/ubuntu/oozie-oozi/0000042-130520131050057-oozie= -oozi-W/sqoop-node--sqoop/sqoop-launcher.jar:/mnt/mapred/local/taskTracker/= distcache/-3926870669093555941_811939984_1868217431/ip-10-147-191-48.ec2.in= ternal/user/oozie/share/lib/sqoo=0Ap/avro-ipc-1.7.3-tests.jar:/mnt/mapred/l= ocal/taskTracker/distcache/4298483340499219542_2138859044_1868217453/ip-10-= 147-191-48.ec2.internal/user/oozie/share/lib/sqoop/avro-ipc-1.7.3.jar:/mnt/= mapred/local/taskTracker/distcache/-1975491928978283532_-1185784129_1868217= 475/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/avro-mapred-1.= 7.3.jar:/mnt/mapred/local/taskTracker/distcache/8448357694523829347_-149131= 7642_1868217500/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/co= mmons-beanutils-1.7.0.jar:/mnt/mapred/local/taskTracker/distcache/-33407931= 7866666788_-232552041_1868217523/ip-10-147-191-48.ec2.internal/user/oozie/s= hare/lib/sqoop/commons-beanutils-core-1.8.0.jar:/mnt/mapred/local/taskTrack= er/distcache/-644448586073609072_-372575484_1868217547/ip-10-147-191-48.ec2= .internal/user/oozie/share/lib/sqoop/commons-configuration-1.6.jar:/mnt/map= red/local/taskTracker/distcache/246054495199880993_357051411_1868217589/ip-= 10-147-191-48.ec2.internal/=0Auser/oozie/share/lib/sqoop/commons-digester-1= .8.jar:/mnt/mapred/local/taskTracker/distcache/-4144140590487253933_7665033= 00_1868217614/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/comm= ons-io-2.1.jar:/mnt/mapred/local/taskTracker/distcache/5753546228468760323_= -553874526_1868217665/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sq= oop/guava-11.0.2.jar:/mnt/mapred/local/taskTracker/distcache/86628660197530= 74519_-1003108238_1868217924/ip-10-147-191-48.ec2.internal/user/oozie/share= /lib/sqoop/hbase-0.94.2-cdh4.2.0.jar:/mnt/mapred/local/taskTracker/distcach= e/-4840377369495417802_845918870_1868217954/ip-10-147-191-48.ec2.internal/u= ser/oozie/share/lib/sqoop/high-scale-lib-1.1.1.jar:/mnt/mapred/local/taskTr= acker/distcache/-142623586016294918_445946554_1868217996/ip-10-147-191-48.e= c2.internal/user/oozie/share/lib/sqoop/hsqldb-1.8.0.7.jar:/mnt/mapred/local= /taskTracker/distcache/5142583573507929188_-105788043_1868218025/ip-10-147-= 191-48.ec2.internal/us=0Aer/oozie/share/lib/sqoop/httpclient-4.1.3.jar:/mnt= /mapred/local/taskTracker/distcache/-6413369533723682352_-180904991_1868218= 051/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/httpcore-4.1.3= .jar:/mnt/mapred/local/taskTracker/distcache/3446550291828223401_633399508_= 1868218088/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/jsr305-= 1.3.9.jar:/mnt/mapred/local/taskTracker/distcache/-6492962697058022370_-616= 322509_1868218133/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/= libthrift-0.9.0.jar:/mnt/mapred/local/taskTracker/distcache/704915158197381= 3525_2017354882_1868218156/ip-10-147-191-48.ec2.internal/user/oozie/share/l= ib/sqoop/metrics-core-2.1.2.jar:/mnt/mapred/local/taskTracker/distcache/623= 583253106481693_846556431_1142287025/ip-10-147-191-48.ec2.internal/user/ooz= ie/share/lib/sqoop/mysql-connector-java-5.1.24-bin.jar:/mnt/mapred/local/ta= skTracker/distcache/-7982675208196719520_-1207761111_1868218197/ip-10-147-1= 91-48.ec2.interna=0Al/user/oozie/share/lib/sqoop/netty-3.4.0.Final.jar:/mnt= /mapred/local/taskTracker/distcache/-4577237135972373202_-1630140361_186821= 8251/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/sqoop-1.4.2-c= dh4.2.0.jar:/mnt/mapred/local/taskTracker/distcache/-412267918101123238_-51= 7736257_1868215515/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/oozie= /json-simple-1.1.jar:/mnt/mapred/local/taskTracker/ubuntu/jobcache/job_2013= 05131705_0181/attempt_201305131705_0181_m_000000_0/work:/usr/lib/hadoop-0.2= 0-mapreduce/hadoop-core-2.0.0-mr1-cdh4.2.0.jar:/mnt/mapred/local/taskTracke= r/distcache/-4577237135972373202_-1630140361_1868218251/ip-10-147-191-48.ec= 2.internal/user/oozie/share/lib/sqoop/sqoop-1.4.2-cdh4.2.0.jar 2013-05-21 0= 0:48:48,206 INFO org.apache.sqoop.orm.CompilationManager: Writing jar file:= /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/CHRYSLER_Anamet= rix_Aggregated.jar 2013-05-21 00:48:48,210 DEBUG org.apache.sqoop.orm.CompilationManager: Scanning for .class files in dire= ctory: /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca 2013-05-2= 1 00:48:48,221 DEBUG org.apache.sqoop.orm.CompilationManager: Got classfile= : /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/CHRYSLER_Aname= trix_Aggregated.class -> CHRYSLER_Anametrix_Aggregated.class 2013-05-21 00:= 48:48,236 DEBUG org.apache.sqoop.orm.CompilationManager: Finished writing j= ar file /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/CHRYSLER= _Anametrix_Aggregated.jar 2013-05-21 00:48:48,243 WARN org.apache.sqoop.man= ager.MySQLManager: MySQL Connector upsert functionality is using INSERT ON = 2013-05-21 00:48:48,243 WARN org.apache.sqoop.manager.MySQLManager: DUPLICA= TE KEY UPDATE clause that relies on table's unique key. 2013-05-21 00:48:48= ,243 WARN org.apache.sqoop.manager.MySQLManager: Insert/update distinction = is therefore independent on column 2013-05-21 00:48:48,243 WARN org.apache.sqoop.manager.MySQLManager: names specified in --update-key par= ameter. Please see MySQL 2013-05-21 00:48:48,245 WARN org.apache.sqoop.mana= ger.MySQLManager: documentation for additional limitations. 2013-05-21 00:4= 8:48,290 INFO org.apache.sqoop.mapreduce.ExportJobBase: Beginning export of= CHRYSLER_Anametrix_Aggregated 2013-05-21 00:48:48,319 DEBUG org.apache.sqo= op.mapreduce.JobBase: Using InputFormat: class org.apache.sqoop.mapreduce.E= xportInputFormat 2013-05-21 00:48:48,575 DEBUG org.apache.sqoop.mapreduce.J= obBase: Adding to job classpath: file:/mnt/mapred/local/taskTracker/distcac= he/-4577237135972373202_-1630140361_1868218251/ip-10-147-191-48.ec2.interna= l/user/oozie/share/lib/sqoop/sqoop-1.4.2-cdh4.2.0.jar 2013-05-21 00:48:48,5= 81 DEBUG org.apache.sqoop.mapreduce.JobBase: Adding to job classpath: file:/mnt/mapred/local/taskTracker/distcache/623583253106481693_846556431_= 1142287025/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/mysql-c= onnector-java-5.1.24-bin.jar 2013-05-21 00:48:48,585 DEBUG org.apache.sqoop= .mapreduce.JobBase: Adding to job classpath: file:/mnt/mapred/local/taskTra= cker/distcache/-4577237135972373202_-1630140361_1868218251/ip-10-147-191-48= .ec2.internal/user/oozie/share/lib/sqoop/sqoop-1.4.2-cdh4.2.0.jar 2013-05-2= 1 00:48:48,588 DEBUG org.apache.sqoop.mapreduce.JobBase: Adding to job clas= spath: file:/mnt/mapred/local/taskTracker/distcache/-4577237135972373202_-1= 630140361_1868218251/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqo= op/sqoop-1.4.2-cdh4.2.0.jar 2013-05-21 00:48:48,588 WARN org.apache.sqoop.m= apreduce.JobBase: SQOOP_HOME is unset. May not be able to find all job depe= ndencies. 2013-05-21 00:48:48,739 WARN org.apache.hadoop.mapred.JobClient: = Use GenericOptionsParser for parsing the arguments. Applications should implement Tool for the same. 2013-05-21 00:48:49,058 INFO org.apach= e.hadoop.mapreduce.lib.input.FileInputFormat: Total input paths to process = : 1 2013-05-21 00:48:49,059 DEBUG org.apache.sqoop.mapreduce.ExportInputFor= mat: Target numMapTasks=3D1 2013-05-21 00:48:49,059 DEBUG org.apache.sqoop.= mapreduce.ExportInputFormat: Total input bytes=3D8187428 2013-05-21 00:48:4= 9,059 DEBUG org.apache.sqoop.mapreduce.ExportInputFormat: maxSplitSize=3D81= 87428 2013-05-21 00:48:49,063 INFO org.apache.hadoop.mapreduce.lib.input.Fi= leInputFormat: Total input paths to process : 1 2013-05-21 00:48:49,073 DEB= UG org.apache.sqoop.mapreduce.ExportInputFormat: Generated splits: 2013-05-= 21 00:48:49,073 DEBUG org.apache.sqoop.mapreduce.ExportInputFormat: Paths= :/user/hive/warehouse/chrysler_anametrix_aggregated/part-AG-00000-1.txt:0+8= 187428 Locations:ip-10-147-191-48.ec2.internal:; 2013-05-21 00:48:49,403 IN= FO org.apache.hadoop.mapred.JobClient: Running job: job_201305131705_0182 2013-05-21 00:48:50,417 INFO org.apache.hadoop.mapred.JobClient: map 0% r= educe 0% 2013-05-21 00:49:06,478 INFO org.apache.hadoop.mapred.JobClient: T= ask Id : attempt_201305131705_0182_m_000000_0, Status : FAILED 2013-05-21 0= 0:49:16,703 INFO org.apache.hadoop.mapred.JobClient: Task Id : attempt_2013= 05131705_0182_m_000000_1, Status : FAILED 2013-05-21 00:49:25,861 INFO org.= apache.hadoop.mapred.JobClient: Task Id : attempt_201305131705_0182_m_00000= 0_2, Status : FAILED 2013-05-21 00:49:42,012 INFO org.apache.hadoop.mapred.= JobClient: Job complete: job_201305131705_0182 2013-05-21 00:49:42,015 INFO= org.apache.hadoop.mapred.JobClient: Counters: 7 2013-05-21 00:49:42,020 IN= FO org.apache.hadoop.mapred.JobClient: Job Counters 2013-05-21 00:49:42,0= 23 INFO org.apache.hadoop.mapred.JobClient: Failed map tasks=3D1 2013-0= 5-21 00:49:42,023 INFO org.apache.hadoop.mapred.JobClient: Launched map= tasks=3D4 2013-05-21 00:49:42,023 INFO org.apache.hadoop.mapred.JobClient: Data-local map tasks=3D4 2013-05-2= 1 00:49:42,024 INFO org.apache.hadoop.mapred.JobClient: Total time spen= t by all maps in occupied slots (ms)=3D50187 2013-05-21 00:49:42,024 INFO o= rg.apache.hadoop.mapred.JobClient: Total time spent by all reduces in o= ccupied slots (ms)=3D0 2013-05-21 00:49:42,024 INFO org.apache.hadoop.mapre= d.JobClient: Total time spent by all maps waiting after reserving slots= (ms)=3D0 2013-05-21 00:49:42,024 INFO org.apache.hadoop.mapred.JobClient: = Total time spent by all reduces waiting after reserving slots (ms)=3D0 = 2013-05-21 00:49:42,032 WARN mapreduce.Counters: Group FileSystemCounters i= s deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead 201= 3-05-21 00:49:42,033 INFO org.apache.sqoop.mapreduce.ExportJobBase: Transfe= rred 0 bytes in 53.4336 seconds (0 bytes/sec) 2013-05-21 00:49:42,035 WARN = mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecat= ed. Use org.apache.hadoop.mapreduce.TaskCounter instead 2013-05-21 00:49:42,03= 5 INFO org.apache.sqoop.mapreduce.ExportJobBase: Exported 0 records. 2013-0= 5-21 00:49:42,035 ERROR org.apache.sqoop.tool.ExportTool: Error during expo= rt: Export job failed! 2013-05-21 00:49:42,063 INFO org.apache.hadoop.mapre= d.Task: Task:attempt_201305131705_0181_m_000000_0 is done. And is in the pr= ocess of commiting 2013-05-21 00:49:43,124 INFO org.apache.hadoop.mapred.Ta= sk: Task attempt_201305131705_0181_m_000000_0 is allowed to commit now 2013= -05-21 00:49:43,292 INFO org.apache.hadoop.mapred.FileOutputCommitter: Save= d output of task 'attempt_201305131705_0181_m_000000_0' to hdfs://ip-10-147= -191-48.ec2.internal:8020/user/ubuntu/oozie-oozi/0000042-130520131050057-oo= zie-oozi-W/sqoop-node--sqoop/output 2013-05-21 00:49:43,300 INFO org.apache= .hadoop.mapred.Task: Task 'attempt_201305131705_0181_m_000000_0' done. 2013= -05-21 00:49:43,309 INFO org.apache.hadoop.mapred.TaskLogsTruncater: Initializing logs' truncater with mapRetainSize=3D-1 and reduceRetainSize= =3D-1=0A=0ARegards,=0AAndy Tey=0AStudent !! ---1137503753-1610986544-1369140976=:13284 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Greeting experts,

  =0A I have a table = "CHRYSLER_Anametrix_Aggregated" in Hive and in MySQL. =0ASimilarly I can fi= nd this table in hdfs -- =0A/user/hive/warehouse/chrysler_anametrix_aggrega= ted.

   I can successfully execute the following SQOOP = command from namenode CLI -

  =0A sqoop export --verbose= --connect =0Ajdbc:mysql://ec2-23-22-223-47.compute-1.amazonaws.com:3306/te= st --table =0ACHRYSLER_Anametrix_Aggregated --update-key =0AVisitorID,Visit= orDay,VisitorMonth,VisitorYear,VisitorSession =0A--update-mode allowinsert = --export-dir =0A/user/hive/warehouse/chrysler_anametrix_aggregated --userna= me root -m 1 =0A--input-fields-terminated-by '|' --input-null-string '\\N' = =0A--input-null-non-string '\\N'

=
   However, when I want= to run the above as part of Oozie workflow action ...

 &nb= sp;  <action name=3D"sqoop-node">
    &nb= sp;   <sqoop xmlns=3D"uri:oozie:sqoop-action:0.2">
 = ;           <job-track= er>${jobTracker}</job-tracker>
     &n= bsp;      <name-node>${nameNode}</name-no= de>
           = ;=0A <configuration>
       &nb= sp;        <property>
 &nb= sp;            =       <name>sqoop.connection.factories</n= ame>
          &nbs= p;         <value>com.clouder= a.sqoop.manager.DefaultManagerFactory</value>
   &n= bsp;            <= /property>
         &nbs= p;      <property>
   &nbs= p;            &= nbsp;  =0A <name>mapred.job.queue.name</name>
&nbs= p;            &= nbsp;      <value>${queueName}</value>=
            = ;    </property>
     &nbs= p;          <property>            &= nbsp;       <name>mapred.compress.map.o= utput</name>
         = ;           <value>= true</value>
         = ;       </property>
  &nbs= p;            = =0A <property>
        &nb= sp;           <name>= ;oozie.service.WorkflowAppService.system.libpath</name>
 &nbs= p;            &= nbsp;     <value>${nameNode}/user/oozie/share/lib= /sqoop</value>
        &nb= sp;       </property>
  &n= bsp;         </configuration>=
           =0A &= lt;command>export --verbose --connect =0Ajdbc:mysql://ec2-23-22-223-47.c= ompute-1.amazonaws.com:3306/test --table =0ACHRYSLER_Anametrix_Aggregated -= -update-key =0AVisitorID,VisitorDay,VisitorMonth,VisitorYear,VisitorSession= =0A--update-mode allowinsert --export-dir=0A /user/hive/warehouse/chrysler= _anametrix_aggregated --username root -m 1=0A --input-fields-terminated-by = '|' --input-null-string '\\N' =0A--input-null-non-string '\\N'</command&= gt;
        </sqoop>
 &= nbsp;      <ok to=3D"end"/>
  &= nbsp;     <error to=3D"fail"/>
  &nb= sp; </action>

   I get the following error message. I= have "mysql-connector-java.5.1.24-bin.jar" shared library - /user/oozie/share/lib/sqoop.
=
   Hadoop version - 2.00 - CDH4.2.0
   Sqoop versio= n - 1.4.2. - CDH4.2.0

 &= nbsp; Can you experts please guide me  ... a rookie to Hadoop and its = projects.

            =
                  2013-05-21 00:48:35,135 WARN mapreduce.Counters: Group or=
g.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.ma=
preduce.TaskCounter instead=0A                              2013-05-21 00:4=
8:37,394 WARN org.apache.hadoop.conf.Configuration: session.id is deprecate=
d. Instead, use dfs.metrics.session-id=0A                              2013=
-05-21 00:48:37,408 INFO org.apache.hadoop.metrics.jvm.JvmMetrics: Initiali=
zing JVM Metrics with processName=3DMAP, sessionId=3D=0A                   =
           2013-05-21 00:48:38,042 INFO org.apache.hadoop.util.ProcessTree:=
 setsid exited with exit code 0=0A                              2013-05-21 =
00:48:38,058 INFO org.apache.hadoop.mapred.Task:  Using ResourceCalculatorP=
lugin : org.apache.hadoop.util.LinuxResourceCalculatorPlugin@5dce1bea=0A   =
                           2013-05-21 00:48:38,423 INFO org.apache.hadoop.m=
apred.MapTask: Processing split: hdfs://ip-10-147-191-48.ec2.internal:8020/=
user/ubuntu/oozie-oozi/0000042-130520131050057-oozie-oozi-W/sqoop-node--sqo=
op/input/dummy.txt:0+5=0A                              2013-05-21 00:48:38,=
453 WARN mapreduce.Counters: Counter name MAP_INPUT_BYTES is deprecated. Us=
e FileInputFormatCounters as group name and  BYTES_READ as counter name ins=
tead=0A                              2013-05-21 00:48:38,459 INFO org.apach=
e.hadoop.mapred.MapTask: numReduceTasks: 0=0A                              =
2013-05-21 00:48:39,743 WARN org.apache.sqoop.tool.SqoopTool: $SQOOP_CONF_D=
IR has not been set in the environment. Cannot check for additional configu=
ration.=0A                              2013-05-21 00:48:40,032 DEBUG org.a=
pache.sqoop.tool.BaseSqoopTool: Enabled debug logging.=0A                  =
            2013-05-21 00:48:40,036 WARN org.apache.sqoop.SqoopOptions: Cha=
racter argument '|' has multiple characters; only the first will be used.=
=0A                              2013-05-21 00:48:40,084 DEBUG org.apache.s=
qoop.ConnFactory: sqoop.connection.factories is set; ignoring managers.d=0A=
                              2013-05-21 00:48:40,139 DEBUG org.apache.sqoo=
p.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultMa=
nagerFactory=0A                              2013-05-21 00:48:40,139 DEBUG =
org.apache.sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.man=
ager.DefaultManagerFactory=0A                              2013-05-21 00:48=
:40,140 DEBUG org.apache.sqoop.manager.DefaultManagerFactory: Trying with s=
cheme: jdbc:mysql:=0A                              2013-05-21 00:48:40,183 =
INFO org.apache.sqoop.manager.MySQLManager: Preparing to use a MySQL stream=
ing resultset.=0A                              2013-05-21 00:48:40,183 DEBU=
G org.apache.sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.m=
anager.MySQLManager@795e0c2b=0A                              2013-05-21 00:=
48:40,184 INFO org.apache.sqoop.tool.CodeGenTool: Beginning code generation=
=0A                              2013-05-21 00:48:40,233 DEBUG org.apache.s=
qoop.manager.SqlManager: No connection paramenters specified. Using regular=
 API for making connection.=0A                              2013-05-21 00:4=
8:40,911 DEBUG org.apache.sqoop.manager.SqlManager: Using fetchSize for nex=
t query: -2147483648=0A                              2013-05-21 00:48:40,91=
1 INFO org.apache.sqoop.manager.SqlManager: Executing SQL statement: SELECT=
 t.* FROM `CHRYSLER_Anametrix_Aggregated` AS t LIMIT 1=0A                  =
            2013-05-21 00:48:40,930 DEBUG org.apache.sqoop.orm.ClassWriter:=
 selected columns:=0A                              2013-05-21 00:48:40,931 =
DEBUG org.apache.sqoop.orm.ClassWriter:   VisitorID=0A                     =
         2013-05-21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter:   =
VisitorDay=0A                              2013-05-21 00:48:40,931 DEBUG or=
g.apache.sqoop.orm.ClassWriter:   VisitorMonth=0A                          =
    2013-05-21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter:   Visit=
orYear=0A                              2013-05-21 00:48:40,931 DEBUG org.ap=
ache.sqoop.orm.ClassWriter:   VisitorSession=0A                            =
  2013-05-21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter:   Brand=
=0A                              2013-05-21 00:48:40,931 DEBUG org.apache.s=
qoop.orm.ClassWriter:   DeviceType=0A                              2013-05-=
21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter:   DeviceBrowser=0A =
                             2013-05-21 00:48:40,931 DEBUG org.apache.sqoop=
.orm.ClassWriter:   TrafficSource=0A                              2013-05-2=
1 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWriter:   SiteID=0A         =
                     2013-05-21 00:48:40,931 DEBUG org.apache.sqoop.orm.Cla=
ssWriter:   BuyID=0A                              2013-05-21 00:48:40,931 D=
EBUG org.apache.sqoop.orm.ClassWriter:   AdvertisementID=0A                =
              2013-05-21 00:48:40,931 DEBUG org.apache.sqoop.orm.ClassWrite=
r:   PlacementID=0A                              2013-05-21 00:48:40,934 DE=
BUG org.apache.sqoop.orm.ClassWriter:   CreativeID=0A                      =
        2013-05-21 00:48:40,934 DEBUG org.apache.sqoop.orm.ClassWriter:   P=
aidKeyword=0A                              2013-05-21 00:48:40,934 DEBUG or=
g.apache.sqoop.orm.ClassWriter:   Model200=0A                              =
2013-05-21 00:48:40,934 DEBUG org.apache.sqoop.orm.ClassWriter:   Model200C=
onv=0A                              2013-05-21 00:48:40,934 DEBUG org.apach=
e.sqoop.orm.ClassWriter:   Model300=0A                              2013-05=
-21 00:48:40,934 DEBUG org.apache.sqoop.orm.ClassWriter:   Model300TownCoun=
try=0A                              2013-05-21 00:48:40,934 DEBUG org.apach=
e.sqoop.orm.ClassWriter:   BMOLineup=0A                              2013-0=
5-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWriter:   BMOModels=0A   =
                           2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.o=
rm.ClassWriter:   BMOColors=0A                              2013-05-21 00:4=
8:40,935 DEBUG org.apache.sqoop.orm.ClassWriter:   BMOOptions=0A           =
                   2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.Class=
Writer:   BMOSummary=0A                              2013-05-21 00:48:40,93=
5 DEBUG org.apache.sqoop.orm.ClassWriter:   BrochureLineup=0A              =
                2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWri=
ter:   BrochureForm=0A                              2013-05-21 00:48:40,935=
 DEBUG org.apache.sqoop.orm.ClassWriter:   BrochureMailLink=0A             =
                 2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWr=
iter:   BrochureDownloadLink=0A                              2013-05-21 00:=
48:40,935 DEBUG org.apache.sqoop.orm.ClassWriter:   PreDL=0A               =
               2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWrit=
er:   DealerLocate=0A                              2013-05-21 00:48:40,935 =
DEBUG org.apache.sqoop.orm.ClassWriter:   DLHours=0A                       =
       2013-05-21 00:48:40,935 DEBUG org.apache.sqoop.orm.ClassWriter:   DL=
Services=0A                              2013-05-21 00:48:40,936 DEBUG org.=
apache.sqoop.orm.ClassWriter:   DLDealerSite=0A                            =
  2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.orm.ClassWriter:   PreSNI=
=0A                              2013-05-21 00:48:40,936 DEBUG org.apache.s=
qoop.orm.ClassWriter:   SearchNewInventory=0A                              =
2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.orm.ClassWriter:   SNIVIN=0A=
                              2013-05-21 00:48:40,936 DEBUG org.apache.sqoo=
p.orm.ClassWriter:   SNIDetails=0A                              2013-05-21 =
00:48:40,936 DEBUG org.apache.sqoop.orm.ClassWriter:   SNIDealer=0A        =
                      2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.orm.Cl=
assWriter:   TestDriveForm=0A                              2013-05-21 00:48=
:40,936 DEBUG org.apache.sqoop.orm.ClassWriter:   TestDriveComplete=0A     =
                         2013-05-21 00:48:40,936 DEBUG org.apache.sqoop.orm=
.ClassWriter:   Inventives=0A                              2013-05-21 00:48=
:40,937 DEBUG org.apache.sqoop.orm.ClassWriter:   PreCal=0A                =
              2013-05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWrite=
r:   PaymentCalculator=0A                              2013-05-21 00:48:40,=
937 DEBUG org.apache.sqoop.orm.ClassWriter:   PreGAQ=0A                    =
          2013-05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter:  =
 GetAQuote=0A                              2013-05-21 00:48:40,937 DEBUG or=
g.apache.sqoop.orm.ClassWriter:   LandingPage=0A                           =
   2013-05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter:   Models=
=0A                              2013-05-21 00:48:40,937 DEBUG org.apache.s=
qoop.orm.ClassWriter:   PhotosGallery=0A                              2013-=
05-21 00:48:40,937 DEBUG org.apache.sqoop.orm.ClassWriter:   Interior=0A   =
                           2013-05-21 00:48:40,937 DEBUG org.apache.sqoop.o=
rm.ClassWriter:   Exterior=0A                              2013-05-21 00:48=
:40,937 DEBUG org.apache.sqoop.orm.ClassWriter:   Performance=0A           =
                   2013-05-21 00:48:40,938 DEBUG org.apache.sqoop.orm.Class=
Writer:   Safety=0A                              2013-05-21 00:48:40,938 DE=
BUG org.apache.sqoop.orm.ClassWriter:   Specifications=0A                  =
            2013-05-21 00:48:40,938 DEBUG org.apache.sqoop.orm.ClassWriter:=
   ModelHighlights=0A                              2013-05-21 00:48:40,938 =
DEBUG org.apache.sqoop.orm.ClassWriter:   Dimensions=0A                    =
          2013-05-21 00:48:40,938 DEBUG org.apache.sqoop.orm.ClassWriter:  =
 Warranty=0A                              2013-05-21 00:48:40,965 DEBUG org=
.apache.sqoop.manager.SqlManager: Using fetchSize for next query: -21474836=
48=0A                              2013-05-21 00:48:40,965 INFO org.apache.=
sqoop.manager.SqlManager: Executing SQL statement: SELECT t.* FROM `CHRYSLE=
R_Anametrix_Aggregated` AS t LIMIT 1=0A                              2013-0=
5-21 00:48:40,990 DEBUG org.apache.sqoop.orm.ClassWriter: Writing source fi=
le: /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/CHRYSLER_Ana=
metrix_Aggregated.java=0A                              2013-05-21 00:48:40,=
990 DEBUG org.apache.sqoop.orm.ClassWriter: Table name: CHRYSLER_Anametrix_=
Aggregated=0A                              2013-05-21 00:48:40,990 DEBUG or=
g.apache.sqoop.orm.ClassWriter: Columns: VisitorID:12, VisitorDay:12, Visit=
orMonth:12, VisitorYear:12, VisitorSession:4, Brand:12, DeviceType:12, Devi=
ceBrowser:12, TrafficSource:12, SiteID:12, BuyID:12, AdvertisementID:12, Pl=
acementID:12, CreativeID:12, PaidKeyword:12, Model200:4, Model200Conv:4, Mo=
del300:4, Model300TownCountry:4, BMOLineup:4, BMOModels:4, BMOColors:4, BMO=
Options:4, BMOSummary:4, BrochureLineup:4, BrochureForm:4, BrochureMailLink=
:4, BrochureDownloadLink:4, PreDL:4, DealerLocate:4, DLHours:4, DLServices:=
4, DLDealerSite:4, PreSNI:4, SearchNewInventory:4, SNIVIN:4, SNIDetails:4, =
SNIDealer:4, TestDriveForm:4, TestDriveComplete:4, Inventives:4, PreCal:4, =
PaymentCalculator:4, PreGAQ:4, GetAQuote:4, LandingPage:4, Models:4, Photos=
Gallery:4, Interior:4, Exterior:4, Performance:4, Safety:4, Specifications:=
4, ModelHighlights:4, Dimensions:4, Warranty:4,=0A                         =
     2013-05-21 00:48:40,990 DEBUG org.apache.sqoop.orm.ClassWriter: source=
Filename is CHRYSLER_Anametrix_Aggregated.java=0A                          =
    2013-05-21 00:48:40,991 DEBUG org.apache.sqoop.orm.CompilationManager: =
Found existing /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/=
=0A                              2013-05-21 00:48:40,992 INFO org.apache.sq=
oop.orm.CompilationManager: $HADOOP_MAPRED_HOME is not set=0A              =
                2013-05-21 00:48:41,098 DEBUG org.apache.sqoop.orm.Compilat=
ionManager: Adding source file: /tmp/sqoop-mapred/compile/f9c22cb042b8b020c=
4190df2f8e30bca/CHRYSLER_Anametrix_Aggregated.java=0A                      =
        2013-05-21 00:48:41,098 DEBUG org.apache.sqoop.orm.CompilationManag=
er: Invoking javac with args:=0A                              2013-05-21 00=
:48:41,098 DEBUG org.apache.sqoop.orm.CompilationManager:   -sourcepath=0A =
                             2013-05-21 00:48:41,098 DEBUG org.apache.sqoop=
.orm.CompilationManager:   /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190d=
f2f8e30bca/=0A                              2013-05-21 00:48:41,098 DEBUG o=
rg.apache.sqoop.orm.CompilationManager:   -d=0A                            =
  2013-05-21 00:48:41,099 DEBUG org.apache.sqoop.orm.CompilationManager:   =
/tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/=0A             =
                 2013-05-21 00:48:41,099 DEBUG org.apache.sqoop.orm.Compila=
tionManager:   -classpath=0A                              2013-05-21 00:48:=
41,099 DEBUG org.apache.sqoop.orm.CompilationManager:  =0A /run/cloudera-sc=
m-agent/process/76-mapreduce-TASKTRACKER:/usr/lib/jvm/j2sdk1.6-oracle/lib/t=
ools.jar:/usr/lib/hadoop-0.20-mapreduce:/usr/lib/hadoop-0.20-mapreduce/hado=
op-core-2.0.0-mr1-cdh4.2.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/activatio=
n-1.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/ant-contrib-1.0b3.jar:/usr/lib=
/hadoop-0.20-mapreduce/lib/asm-3.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/a=
spectjrt-1.6.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/aspectjtools-1.6.5.ja=
r:/usr/lib/hadoop-0.20-mapreduce/lib/avro-1.7.3.jar:/usr/lib/hadoop-0.20-ma=
preduce/lib/avro-compiler-1.7.3.jar:/usr/lib/hadoop-0.20-mapreduce/lib/comm=
ons-beanutils-1.7.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-beanutil=
s-core-1.8.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-cli-1.2.jar:/us=
r/lib/hadoop-0.20-mapreduce/lib/commons-codec-1.4.jar:/usr/lib/hadoop-0.20-=
mapreduce/lib/commons-collections-3.2.1.jar:/usr/lib/hadoop-0.20-mapreduce/=
lib/commons-configuration-1.6.jar:/usr/lib/hadoop-=0A0.20-mapreduce/lib/com=
mons-digester-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-el-1.0.jar=
:/usr/lib/hadoop-0.20-mapreduce/lib/commons-httpclient-3.1.jar:/usr/lib/had=
oop-0.20-mapreduce/lib/commons-io-2.1.jar:/usr/lib/hadoop-0.20-mapreduce/li=
b/commons-lang-2.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-logging-1=
.1.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-math-2.1.jar:/usr/lib/h=
adoop-0.20-mapreduce/lib/commons-net-3.1.jar:/usr/lib/hadoop-0.20-mapreduce=
/lib/guava-11.0.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/hadoop-fairschedul=
er-2.0.0-mr1-cdh4.2.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/hsqldb-1.8.0.1=
0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jackson-core-asl-1.8.8.jar:/usr/li=
b/hadoop-0.20-mapreduce/lib/jackson-jaxrs-1.8.8.jar:/usr/lib/hadoop-0.20-ma=
preduce/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib=
/jackson-xc-1.8.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jasper-compiler-5.=
5.23.jar:/usr/lib/hadoop-0.20-mapreduce/lib/j=0Aasper-runtime-5.5.23.jar:/u=
sr/lib/hadoop-0.20-mapreduce/lib/jaxb-api-2.2.2.jar:/usr/lib/hadoop-0.20-ma=
preduce/lib/jaxb-impl-2.2.3-1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jersey=
-core-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jersey-json-1.8.jar:/usr/l=
ib/hadoop-0.20-mapreduce/lib/jersey-server-1.8.jar:/usr/lib/hadoop-0.20-map=
reduce/lib/jets3t-0.6.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jettison-1.1=
.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jetty-6.1.26.cloudera.2.jar:/usr/li=
b/hadoop-0.20-mapreduce/lib/jetty-util-6.1.26.cloudera.2.jar:/usr/lib/hadoo=
p-0.20-mapreduce/lib/jline-0.9.94.jar:/usr/lib/hadoop-0.20-mapreduce/lib/js=
ch-0.1.42.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jsp-api-2.1.jar:/usr/lib/h=
adoop-0.20-mapreduce/lib/jsr305-1.3.9.jar:/usr/lib/hadoop-0.20-mapreduce/li=
b/junit-4.8.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/kfs-0.2.2.jar:/usr/lib=
/hadoop-0.20-mapreduce/lib/kfs-0.3.jar:/usr/lib/hadoop-0.20-mapreduce/lib/l=
og4j-1.2.17.jar:/usr/lib/hadoop-0.20-map=0Areduce/lib/mockito-all-1.8.5.jar=
:/usr/lib/hadoop-0.20-mapreduce/lib/paranamer-2.3.jar:/usr/lib/hadoop-0.20-=
mapreduce/lib/protobuf-java-2.4.0a.jar:/usr/lib/hadoop-0.20-mapreduce/lib/s=
ervlet-api-2.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/slf4j-api-1.6.1.jar:/=
usr/lib/hadoop-0.20-mapreduce/lib/snappy-java-1.0.4.1.jar:/usr/lib/hadoop-0=
.20-mapreduce/lib/stax-api-1.0.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/xml=
enc-0.52.jar:/usr/lib/hadoop-0.20-mapreduce/lib/zookeeper-3.4.5-cdh4.2.0.ja=
r:/usr/lib/hadoop-0.20-mapreduce/lib/jsp-2.1/jsp-2.1.jar:/usr/lib/hadoop-0.=
20-mapreduce/lib/jsp-2.1/jsp-api-2.1.jar:/usr/share/cmf/lib/plugins/navigat=
or-plugin-4.5.1-shaded.jar:/usr/share/cmf/lib/plugins/event-publish-4.5.1-s=
haded.jar:/usr/share/cmf/lib/plugins/tt-instrumentation-4.5.1.jar:/usr/lib/=
hadoop-hdfs/lib/jsp-api-2.1.jar:/usr/lib/hadoop-hdfs/lib/log4j-1.2.17.jar:/=
usr/lib/hadoop-hdfs/lib/jetty-util-6.1.26.cloudera.2.jar:/usr/lib/hadoop-hd=
fs/lib/jetty-6.1.26.cloudera.2.jar:=0A/usr/lib/hadoop-hdfs/lib/jersey-core-=
1.8.jar:/usr/lib/hadoop-hdfs/lib/jsr305-1.3.9.jar:/usr/lib/hadoop-hdfs/lib/=
protobuf-java-2.4.0a.jar:/usr/lib/hadoop-hdfs/lib/servlet-api-2.5.jar:/usr/=
lib/hadoop-hdfs/lib/xmlenc-0.52.jar:/usr/lib/hadoop-hdfs/lib/commons-io-2.1=
.jar:/usr/lib/hadoop-hdfs/lib/jline-0.9.94.jar:/usr/lib/hadoop-hdfs/lib/com=
mons-cli-1.2.jar:/usr/lib/hadoop-hdfs/lib/jasper-runtime-5.5.23.jar:/usr/li=
b/hadoop-hdfs/lib/commons-codec-1.4.jar:/usr/lib/hadoop-hdfs/lib/zookeeper-=
3.4.5-cdh4.2.0.jar:/usr/lib/hadoop-hdfs/lib/commons-daemon-1.0.3.jar:/usr/l=
ib/hadoop-hdfs/lib/asm-3.2.jar:/usr/lib/hadoop-hdfs/lib/commons-lang-2.5.ja=
r:/usr/lib/hadoop-hdfs/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hadoop-hdf=
s/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hadoop-hdfs/lib/commons-logging-1=
.1.1.jar:/usr/lib/hadoop-hdfs/lib/jersey-server-1.8.jar:/usr/lib/hadoop-hdf=
s/lib/guava-11.0.2.jar:/usr/lib/hadoop-hdfs/lib/commons-el-1.0.jar:/usr/lib=
/hadoop-hdfs/hadoop-hdfs.jar:/=0Ausr/lib/hadoop-hdfs/hadoop-hdfs-2.0.0-cdh4=
.2.0.jar:/usr/lib/hadoop-hdfs/hadoop-hdfs-2.0.0-cdh4.2.0-tests.jar:/usr/lib=
/hadoop/lib/jsp-api-2.1.jar:/usr/lib/hadoop/lib/avro-1.7.3.jar:/usr/lib/had=
oop/lib/log4j-1.2.17.jar:/usr/lib/hadoop/lib/jackson-jaxrs-1.8.8.jar:/usr/l=
ib/hadoop/lib/jetty-util-6.1.26.cloudera.2.jar:/usr/lib/hadoop/lib/jetty-6.=
1.26.cloudera.2.jar:/usr/lib/hadoop/lib/jersey-core-1.8.jar:/usr/lib/hadoop=
/lib/paranamer-2.3.jar:/usr/lib/hadoop/lib/commons-digester-1.8.jar:/usr/li=
b/hadoop/lib/activation-1.1.jar:/usr/lib/hadoop/lib/commons-collections-3.2=
.1.jar:/usr/lib/hadoop/lib/jsr305-1.3.9.jar:/usr/lib/hadoop/lib/protobuf-ja=
va-2.4.0a.jar:/usr/lib/hadoop/lib/servlet-api-2.5.jar:/usr/lib/hadoop/lib/c=
ommons-beanutils-1.7.0.jar:/usr/lib/hadoop/lib/xmlenc-0.52.jar:/usr/lib/had=
oop/lib/commons-io-2.1.jar:/usr/lib/hadoop/lib/jline-0.9.94.jar:/usr/lib/ha=
doop/lib/mockito-all-1.8.5.jar:/usr/lib/hadoop/lib/commons-cli-1.2.jar:/usr=
/lib/hadoop/lib/commons-c=0Aonfiguration-1.6.jar:/usr/lib/hadoop/lib/jasper=
-runtime-5.5.23.jar:/usr/lib/hadoop/lib/jasper-compiler-5.5.23.jar:/usr/lib=
/hadoop/lib/jackson-xc-1.8.8.jar:/usr/lib/hadoop/lib/commons-codec-1.4.jar:=
/usr/lib/hadoop/lib/jaxb-api-2.2.2.jar:/usr/lib/hadoop/lib/zookeeper-3.4.5-=
cdh4.2.0.jar:/usr/lib/hadoop/lib/commons-httpclient-3.1.jar:/usr/lib/hadoop=
/lib/slf4j-api-1.6.1.jar:/usr/lib/hadoop/lib/commons-math-2.1.jar:/usr/lib/=
hadoop/lib/jettison-1.1.jar:/usr/lib/hadoop/lib/jaxb-impl-2.2.3-1.jar:/usr/=
lib/hadoop/lib/stax-api-1.0.1.jar:/usr/lib/hadoop/lib/commons-beanutils-cor=
e-1.8.0.jar:/usr/lib/hadoop/lib/asm-3.2.jar:/usr/lib/hadoop/lib/commons-lan=
g-2.5.jar:/usr/lib/hadoop/lib/commons-net-3.1.jar:/usr/lib/hadoop/lib/junit=
-4.8.2.jar:/usr/lib/hadoop/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hadoop=
/lib/slf4j-log4j12-1.6.1.jar:/usr/lib/hadoop/lib/snappy-java-1.0.4.1.jar:/u=
sr/lib/hadoop/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hadoop/lib/jets3t-0.6=
.1.jar:/usr/lib/hado=0Aop/lib/hue-plugins-2.2.0-cdh4.2.0.jar:/usr/lib/hadoo=
p/lib/kfs-0.3.jar:/usr/lib/hadoop/lib/commons-logging-1.1.1.jar:/usr/lib/ha=
doop/lib/jsch-0.1.42.jar:/usr/lib/hadoop/lib/jersey-server-1.8.jar:/usr/lib=
/hadoop/lib/jersey-json-1.8.jar:/usr/lib/hadoop/lib/guava-11.0.2.jar:/usr/l=
ib/hadoop/lib/commons-el-1.0.jar:/usr/lib/hadoop/hadoop-auth.jar:/usr/lib/h=
adoop/hadoop-auth-2.0.0-cdh4.2.0.jar:/usr/lib/hadoop/hadoop-annotations.jar=
:/usr/lib/hadoop/hadoop-common-2.0.0-cdh4.2.0-tests.jar:/usr/lib/hadoop/had=
oop-annotations-2.0.0-cdh4.2.0.jar:/usr/lib/hadoop/hadoop-common-2.0.0-cdh4=
.2.0.jar:/usr/lib/hadoop/hadoop-common.jar:/mnt/mapred/local/taskTracker/di=
stcache/-3359360379488511723_1277082233_1150217957/ip-10-147-191-48.ec2.int=
ernal/user/ubuntu/oozie-oozi/0000042-130520131050057-oozie-oozi-W/sqoop-nod=
e--sqoop/sqoop-launcher.jar:/mnt/mapred/local/taskTracker/distcache/-392687=
0669093555941_811939984_1868217431/ip-10-147-191-48.ec2.internal/user/oozie=
/share/lib/sqoo=0Ap/avro-ipc-1.7.3-tests.jar:/mnt/mapred/local/taskTracker/=
distcache/4298483340499219542_2138859044_1868217453/ip-10-147-191-48.ec2.in=
ternal/user/oozie/share/lib/sqoop/avro-ipc-1.7.3.jar:/mnt/mapred/local/task=
Tracker/distcache/-1975491928978283532_-1185784129_1868217475/ip-10-147-191=
-48.ec2.internal/user/oozie/share/lib/sqoop/avro-mapred-1.7.3.jar:/mnt/mapr=
ed/local/taskTracker/distcache/8448357694523829347_-1491317642_1868217500/i=
p-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/commons-beanutils-1=
.7.0.jar:/mnt/mapred/local/taskTracker/distcache/-334079317866666788_-23255=
2041_1868217523/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/co=
mmons-beanutils-core-1.8.0.jar:/mnt/mapred/local/taskTracker/distcache/-644=
448586073609072_-372575484_1868217547/ip-10-147-191-48.ec2.internal/user/oo=
zie/share/lib/sqoop/commons-configuration-1.6.jar:/mnt/mapred/local/taskTra=
cker/distcache/246054495199880993_357051411_1868217589/ip-10-147-191-48.ec2=
.internal/=0Auser/oozie/share/lib/sqoop/commons-digester-1.8.jar:/mnt/mapre=
d/local/taskTracker/distcache/-4144140590487253933_766503300_1868217614/ip-=
10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/commons-io-2.1.jar:/m=
nt/mapred/local/taskTracker/distcache/5753546228468760323_-553874526_186821=
7665/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/guava-11.0.2.=
jar:/mnt/mapred/local/taskTracker/distcache/8662866019753074519_-1003108238=
_1868217924/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/hbase-=
0.94.2-cdh4.2.0.jar:/mnt/mapred/local/taskTracker/distcache/-48403773694954=
17802_845918870_1868217954/ip-10-147-191-48.ec2.internal/user/oozie/share/l=
ib/sqoop/high-scale-lib-1.1.1.jar:/mnt/mapred/local/taskTracker/distcache/-=
142623586016294918_445946554_1868217996/ip-10-147-191-48.ec2.internal/user/=
oozie/share/lib/sqoop/hsqldb-1.8.0.7.jar:/mnt/mapred/local/taskTracker/dist=
cache/5142583573507929188_-105788043_1868218025/ip-10-147-191-48.ec2.intern=
al/us=0Aer/oozie/share/lib/sqoop/httpclient-4.1.3.jar:/mnt/mapred/local/tas=
kTracker/distcache/-6413369533723682352_-180904991_1868218051/ip-10-147-191=
-48.ec2.internal/user/oozie/share/lib/sqoop/httpcore-4.1.3.jar:/mnt/mapred/=
local/taskTracker/distcache/3446550291828223401_633399508_1868218088/ip-10-=
147-191-48.ec2.internal/user/oozie/share/lib/sqoop/jsr305-1.3.9.jar:/mnt/ma=
pred/local/taskTracker/distcache/-6492962697058022370_-616322509_1868218133=
/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/libthrift-0.9.0.j=
ar:/mnt/mapred/local/taskTracker/distcache/7049151581973813525_2017354882_1=
868218156/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/metrics-=
core-2.1.2.jar:/mnt/mapred/local/taskTracker/distcache/623583253106481693_8=
46556431_1142287025/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoo=
p/mysql-connector-java-5.1.24-bin.jar:/mnt/mapred/local/taskTracker/distcac=
he/-7982675208196719520_-1207761111_1868218197/ip-10-147-191-48.ec2.interna=
=0Al/user/oozie/share/lib/sqoop/netty-3.4.0.Final.jar:/mnt/mapred/local/tas=
kTracker/distcache/-4577237135972373202_-1630140361_1868218251/ip-10-147-19=
1-48.ec2.internal/user/oozie/share/lib/sqoop/sqoop-1.4.2-cdh4.2.0.jar:/mnt/=
mapred/local/taskTracker/distcache/-412267918101123238_-517736257_186821551=
5/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/oozie/json-simple-1.1.=
jar:/mnt/mapred/local/taskTracker/ubuntu/jobcache/job_201305131705_0181/att=
empt_201305131705_0181_m_000000_0/work:/usr/lib/hadoop-0.20-mapreduce/hadoo=
p-core-2.0.0-mr1-cdh4.2.0.jar:/mnt/mapred/local/taskTracker/distcache/-4577=
237135972373202_-1630140361_1868218251/ip-10-147-191-48.ec2.internal/user/o=
ozie/share/lib/sqoop/sqoop-1.4.2-cdh4.2.0.jar=0A                           =
   2013-05-21 00:48:48,206 INFO org.apache.sqoop.orm.CompilationManager: Wr=
iting jar file: /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30bca/=
CHRYSLER_Anametrix_Aggregated.jar=0A                              2013-05-2=
1 00:48:48,210 DEBUG org.apache.sqoop.orm.CompilationManager: Scanning for =
.class files in directory: /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190d=
f2f8e30bca=0A                              2013-05-21 00:48:48,221 DEBUG or=
g.apache.sqoop.orm.CompilationManager: Got classfile: /tmp/sqoop-mapred/com=
pile/f9c22cb042b8b020c4190df2f8e30bca/CHRYSLER_Anametrix_Aggregated.class -=
> CHRYSLER_Anametrix_Aggregated.class=0A                              20=
13-05-21 00:48:48,236 DEBUG org.apache.sqoop.orm.CompilationManager: Finish=
ed writing jar file /tmp/sqoop-mapred/compile/f9c22cb042b8b020c4190df2f8e30=
bca/CHRYSLER_Anametrix_Aggregated.jar=0A                              2013-=
05-21 00:48:48,243 WARN org.apache.sqoop.manager.MySQLManager: MySQL Connec=
tor upsert functionality is using INSERT ON=0A                             =
 2013-05-21 00:48:48,243 WARN org.apache.sqoop.manager.MySQLManager: DUPLIC=
ATE KEY UPDATE clause that relies on table's unique key.=0A                =
              2013-05-21 00:48:48,243 WARN org.apache.sqoop.manager.MySQLMa=
nager: Insert/update distinction is therefore independent on column=0A     =
                         2013-05-21 00:48:48,243 WARN org.apache.sqoop.mana=
ger.MySQLManager: names specified in --update-key parameter. Please see MyS=
QL=0A                              2013-05-21 00:48:48,245 WARN org.apache.=
sqoop.manager.MySQLManager: documentation for additional limitations.=0A   =
                           2013-05-21 00:48:48,290 INFO org.apache.sqoop.ma=
preduce.ExportJobBase: Beginning export of CHRYSLER_Anametrix_Aggregated=0A=
                              2013-05-21 00:48:48,319 DEBUG org.apache.sqoo=
p.mapreduce.JobBase: Using InputFormat: class org.apache.sqoop.mapreduce.Ex=
portInputFormat=0A                              2013-05-21 00:48:48,575 DEB=
UG org.apache.sqoop.mapreduce.JobBase: Adding to job classpath: file:/mnt/m=
apred/local/taskTracker/distcache/-4577237135972373202_-1630140361_18682182=
51/ip-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/sqoop-1.4.2-cdh=
4.2.0.jar=0A                              2013-05-21 00:48:48,581 DEBUG org=
.apache.sqoop.mapreduce.JobBase: Adding to job classpath: file:/mnt/mapred/=
local/taskTracker/distcache/623583253106481693_846556431_1142287025/ip-10-1=
47-191-48.ec2.internal/user/oozie/share/lib/sqoop/mysql-connector-java-5.1.=
24-bin.jar=0A                              2013-05-21 00:48:48,585 DEBUG or=
g.apache.sqoop.mapreduce.JobBase: Adding to job classpath: file:/mnt/mapred=
/local/taskTracker/distcache/-4577237135972373202_-1630140361_1868218251/ip=
-10-147-191-48.ec2.internal/user/oozie/share/lib/sqoop/sqoop-1.4.2-cdh4.2.0=
.jar=0A                              2013-05-21 00:48:48,588 DEBUG org.apac=
he.sqoop.mapreduce.JobBase: Adding to job classpath: file:/mnt/mapred/local=
/taskTracker/distcache/-4577237135972373202_-1630140361_1868218251/ip-10-14=
7-191-48.ec2.internal/user/oozie/share/lib/sqoop/sqoop-1.4.2-cdh4.2.0.jar=
=0A                              2013-05-21 00:48:48,588 WARN org.apache.sq=
oop.mapreduce.JobBase: SQOOP_HOME is unset. May not be able to find all job=
 dependencies.=0A                              2013-05-21 00:48:48,739 WARN=
 org.apache.hadoop.mapred.JobClient: Use GenericOptionsParser for parsing t=
he arguments. Applications should implement Tool for the same.=0A          =
                    2013-05-21 00:48:49,058 INFO org.apache.hadoop.mapreduc=
e.lib.input.FileInputFormat: Total input paths to process : 1=0A           =
                   2013-05-21 00:48:49,059 DEBUG org.apache.sqoop.mapreduce=
.ExportInputFormat: Target numMapTasks=3D1=0A                              =
2013-05-21 00:48:49,059 DEBUG org.apache.sqoop.mapreduce.ExportInputFormat:=
 Total input bytes=3D8187428=0A                              2013-05-21 00:=
48:49,059 DEBUG org.apache.sqoop.mapreduce.ExportInputFormat: maxSplitSize=
=3D8187428=0A                              2013-05-21 00:48:49,063 INFO org=
.apache.hadoop.mapreduce.lib.input.FileInputFormat: Total input paths to pr=
ocess : 1=0A                              2013-05-21 00:48:49,073 DEBUG org=
.apache.sqoop.mapreduce.ExportInputFormat: Generated splits:=0A            =
                  2013-05-21 00:48:49,073 DEBUG org.apache.sqoop.mapreduce.=
ExportInputFormat:   Paths:/user/hive/warehouse/chrysler_anametrix_aggregat=
ed/part-AG-00000-1.txt:0+8187428 Locations:ip-10-147-191-48.ec2.internal:;=
=0A                              2013-05-21 00:48:49,403 INFO org.apache.ha=
doop.mapred.JobClient: Running job: job_201305131705_0182=0A               =
               2013-05-21 00:48:50,417 INFO org.apache.hadoop.mapred.JobCli=
ent:  map 0% reduce 0%=0A                              2013-05-21 00:49:06,=
478 INFO org.apache.hadoop.mapred.JobClient: Task Id : attempt_201305131705=
_0182_m_000000_0, Status : FAILED=0A                              2013-05-2=
1 00:49:16,703 INFO org.apache.hadoop.mapred.JobClient: Task Id : attempt_2=
01305131705_0182_m_000000_1, Status : FAILED=0A                            =
  2013-05-21 00:49:25,861 INFO org.apache.hadoop.mapred.JobClient: Task Id =
: attempt_201305131705_0182_m_000000_2, Status : FAILED=0A                 =
             2013-05-21 00:49:42,012 INFO org.apache.hadoop.mapred.JobClien=
t: Job complete: job_201305131705_0182=0A                              2013=
-05-21 00:49:42,015 INFO org.apache.hadoop.mapred.JobClient: Counters: 7=0A=
                              2013-05-21 00:49:42,020 INFO org.apache.hadoo=
p.mapred.JobClient:   Job Counters=0A                              2013-05-=
21 00:49:42,023 INFO org.apache.hadoop.mapred.JobClient:     Failed map tas=
ks=3D1=0A                              2013-05-21 00:49:42,023 INFO org.apa=
che.hadoop.mapred.JobClient:     Launched map tasks=3D4=0A                 =
             2013-05-21 00:49:42,023 INFO org.apache.hadoop.mapred.JobClien=
t:     Data-local map tasks=3D4=0A                              2013-05-21 =
00:49:42,024 INFO org.apache.hadoop.mapred.JobClient:     Total time spent =
by all maps in occupied slots (ms)=3D50187=0A                              =
2013-05-21 00:49:42,024 INFO org.apache.hadoop.mapred.JobClient:     Total =
time spent by all reduces in occupied slots (ms)=3D0=0A                    =
          2013-05-21 00:49:42,024 INFO org.apache.hadoop.mapred.JobClient: =
    Total time spent by all maps waiting after reserving slots (ms)=3D0=0A =
                             2013-05-21 00:49:42,024 INFO org.apache.hadoop=
.mapred.JobClient:     Total time spent by all reduces waiting after reserv=
ing slots (ms)=3D0=0A                              2013-05-21 00:49:42,032 =
WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.ap=
ache.hadoop.mapreduce.FileSystemCounter instead=0A                         =
     2013-05-21 00:49:42,033 INFO org.apache.sqoop.mapreduce.ExportJobBase:=
 Transferred 0 bytes in 53.4336 seconds (0 bytes/sec)=0A                   =
           2013-05-21 00:49:42,035 WARN mapreduce.Counters: Group org.apach=
e.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce=
.TaskCounter instead=0A                              2013-05-21 00:49:42,03=
5 INFO org.apache.sqoop.mapreduce.ExportJobBase: Exported 0 records.=0A    =
                          2013-05-21 00:49:42,035 ERROR org.apache.sqoop.to=
ol.ExportTool: Error during export: Export job failed!=0A                  =
            2013-05-21 00:49:42,063 INFO org.apache.hadoop.mapred.Task: Tas=
k:attempt_201305131705_0181_m_000000_0 is done. And is in the process of co=
mmiting=0A                              2013-05-21 00:49:43,124 INFO org.ap=
ache.hadoop.mapred.Task: Task attempt_201305131705_0181_m_000000_0 is allow=
ed to commit now=0A                              2013-05-21 00:49:43,292 IN=
FO org.apache.hadoop.mapred.FileOutputCommitter: Saved output of task 'atte=
mpt_201305131705_0181_m_000000_0' to hdfs://ip-10-147-191-48.ec2.internal:8=
020/user/ubuntu/oozie-oozi/0000042-130520131050057-oozie-oozi-W/sqoop-node-=
-sqoop/output=0A                              2013-05-21 00:49:43,300 INFO =
org.apache.hadoop.mapred.Task: Task 'attempt_201305131705_0181_m_000000_0' =
done.=0A                              2013-05-21 00:49:43,309 INFO org.apac=
he.hadoop.mapred.TaskLogsTruncater: Initializing logs' truncater with mapRe=
tainSize=3D-1 and reduceRetainSize=3D-1

Regards,
Andy Tey
Stud=
ent !!


---1137503753-1610986544-1369140976=:13284--