Return-Path: X-Original-To: apmail-hadoop-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-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 51856D25D for ; Fri, 5 Oct 2012 14:59:48 +0000 (UTC) Received: (qmail 80783 invoked by uid 500); 5 Oct 2012 14:59:43 -0000 Delivered-To: apmail-hadoop-user-archive@hadoop.apache.org Received: (qmail 80509 invoked by uid 500); 5 Oct 2012 14:59:43 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 80502 invoked by uid 99); 5 Oct 2012 14:59:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Oct 2012 14:59:43 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS,URIBL_DBL_REDIR X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [206.47.135.205] (HELO Spam1.prd.mpac.ca) (206.47.135.205) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Oct 2012 14:59:37 +0000 Received: from Spam1.prd.mpac.ca (unknown [127.0.0.1]) by IMSVA80 (Postfix) with ESMTP id 97DF51D805E; Fri, 5 Oct 2012 10:59:13 -0400 (EDT) Received: from SMAIL1.prd.mpac.ca (unknown [172.29.2.53]) by Spam1.prd.mpac.ca (Postfix) with ESMTP id 3AF2C1D805D; Fri, 5 Oct 2012 10:59:13 -0400 (EDT) Received: from SMAIL1.prd.mpac.ca ([fe80::d548:4221:967c:4cfb]) by SMAIL1.prd.mpac.ca ([fe80::d548:4221:967c:4cfb%16]) with mapi id 14.02.0318.001; Fri, 5 Oct 2012 10:59:12 -0400 From: "Kartashov, Andy" To: Marcos Ortiz , "user@hadoop.apache.org" Subject: RE: sqoop jobs Thread-Topic: sqoop jobs Thread-Index: AQHNowj7IDAunWFrikazzUMENGEz1ZeqzS1w Date: Fri, 5 Oct 2012 14:59:12 +0000 Message-ID: References: <506EF3FD.6090508@uci.cu> In-Reply-To: <506EF3FD.6090508@uci.cu> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [172.29.60.102] Content-Type: multipart/related; boundary="_004_BD42F346AE90F544A731516A805D1B8AD70B9FSMAIL1prdmpacca_"; type="multipart/alternative" MIME-Version: 1.0 X-TM-AS-Product-Ver: IMSVA-8.0.0.1304-6.5.0.1024-19242.004 X-TM-AS-Result: No--37.364-5.0-31-10 X-imss-scan-details: No--37.364-5.0-31-10 X-TM-AS-Result-Xfilter: Match text exemption rules:No X-TMASE-MatchedRID: cAYEo/vLYvs7iuZ/mdYYtseQfu6iwSfsVPr37bO8IJIpBuTwKkPZjl+3 marPRGnm+oxozQ09RyyjrlYm3WTU7xmyTBaqiJvcayjbe4qUImNvJDFfbbJIOyqq0O5S3DJ8YNk 4z38PN+PI7XtnaA9QK7MjW/sniEQK1kqyrcMalqUqNag3uuW+4qNVCJwHWvr8RzlIlB+xJaOZd7 hoQZUlsxO/UAf/ulVpOJTWdcuXC/46En2bnefhoOS7dFdnswnsc/SnBB5o44mN5ha5hzu59+E33 eOVlb1whrD3pNcSx1bvVbHa5Rs8t4N12XKYbuJLawV8+oOjgHWgCZWtPRYFyWZmSpwDI6W4153t 7MDjmg2xgwOANN5IAGg4D2QV/2zL6r3HCixfuKdpr7yB77LWO4QK7nshlepip25VhBmPgZIBZOs OGHKpoUjlo2JU8qCxmHJeAYKlcpNxtWYlDuRQpY9osn8JrdJPxgSPmjDpa1yATHNX4n1dGOYosV hwqm/9L0W1btd8e552Gmf10eZIVrQ+jDZyO2oEDC/Vm90If4WY8y8WI7jQsMnb05LJ5Oaf4jWcD NmlX+CjYAfaVCSb02Y0Io4Kxb86Jd2n2XoSRFn7n73d09vr9xqGc7het5hmVCrCrhFNYP3aY2zi QGT+UtYiSrf292q6BxsweNg3EaGFkCkkB0UMNnPFlj+U0b02K1+4djfJACyt1kt6UTrAW077e4Y 1xq/3DHVK8/9FAcYwa1qouYvEtuZW5O7W9VmEqFtVWyvIhj73P8uvciOrSGv23d8jHpSM6TDSyl 4KVWZqSvsG+mBXYw== --_004_BD42F346AE90F544A731516A805D1B8AD70B9FSMAIL1prdmpacca_ Content-Type: multipart/alternative; boundary="_000_BD42F346AE90F544A731516A805D1B8AD70B9FSMAIL1prdmpacca_" --_000_BD42F346AE90F544A731516A805D1B8AD70B9FSMAIL1prdmpacca_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable sqoop version Sqoop 1.4.1-cdh4.0.1 hadoop version Hadoop 2.0.0-cdh4.0.1 Subversion file:///data/1/jenkins/workspace/generic-package-rhel64-6-0/topd= ir/BUILD/hadoop-2.0.0-cdh4.0.1/src/hadoop-common-project/hadoop-common hsqldb ver 2.2.9. Andy Kartashov MPAC Architecture R&D, Co-op 1340 Pickering Parkway, Pickering, L1V 0C4 * Phone : (905) 837 6269 * Mobile: (416) 722 1787 andy.kartashov@mpac.ca From: Marcos Ortiz [mailto:mlortiz@uci.cu] Sent: Friday, October 05, 2012 10:52 AM To: user@hadoop.apache.org Cc: Kartashov, Andy Subject: Re: sqoop jobs Which version of Sqoop are you using? Which version of Hadoop? On 10/05/2012 09:45 AM, Kartashov, Andy wrote: Guys, Have any one successfully executed commands like Sqoop job -list Sqoop job -create .. etc. Do I need to set-up my sqoop-core.xml before hand? Example.. sqoop job --list 12/10/05 09:44:29 WARN hsqldb.HsqldbJobStorage: Could not interpret as a nu= mber: null 12/10/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: Can not interpret metadata= schema 12/10/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: The metadata schema versio= n is null 12/10/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: The highest version suppor= ted is 0 12/10/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: To use this version of Sqo= op, you must downgrade your metadata schema. 12/10/05 09:44:29 ERROR tool.JobTool: I/O error performing job operation: j= ava.io.IOException: Invalid metadata version. at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJo= bStorage.java:202) at org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsq= ldbStorage.java:112) at org.apache.sqoop.tool.JobTool.run(JobTool.java:279) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238) at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57) NOTICE: This e-mail message and any attachments are confidential, subject t= o copyright and may be privileged. Any unauthorized use, copying or disclos= ure is prohibited. If you are not the intended recipient, please delete and= contact the sender immediately. Please consider the environment before pri= nting this e-mail. AVIS : le pr=E9sent courriel et toute pi=E8ce jointe qui= l'accompagne sont confidentiels, prot=E9g=E9s par le droit d'auteur et peu= vent =EAtre couverts par le secret professionnel. Toute utilisation, copie = ou divulgation non autoris=E9e est interdite. Si vous n'=EAtes pas le desti= nataire pr=E9vu de ce courriel, supprimez-le et contactez imm=E9diatement l= 'exp=E9diteur. Veuillez penser =E0 l'environnement avant d'imprimer le pr= =E9sent courriel [Description: Image removed by sender.] -- Marcos Luis Ort=EDz Valmaseda Data Engineer && Sr. System Administrator at UCI about.me/marcosortiz My Blog Tumblr's blog @marcosluis2186 [Description: Image removed by sender.] NOTICE: This e-mail message and any attachments are confidential, subject t= o copyright and may be privileged. Any unauthorized use, copying or disclos= ure is prohibited. If you are not the intended recipient, please delete and= contact the sender immediately. Please consider the environment before pri= nting this e-mail. AVIS : le pr=E9sent courriel et toute pi=E8ce jointe qui= l'accompagne sont confidentiels, prot=E9g=E9s par le droit d'auteur et peu= vent =EAtre couverts par le secret professionnel. Toute utilisation, copie = ou divulgation non autoris=E9e est interdite. Si vous n'=EAtes pas le desti= nataire pr=E9vu de ce courriel, supprimez-le et contactez imm=E9diatement l= 'exp=E9diteur. Veuillez penser =E0 l'environnement avant d'imprimer le pr= =E9sent courriel --_000_BD42F346AE90F544A731516A805D1B8AD70B9FSMAIL1prdmpacca_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

sqoo= p version

Sqoo= p 1.4.1-cdh4.0.1

&nbs= p;

hado= op version

Hado= op 2.0.0-cdh4.0.1

Subv= ersion file:///data/1/jenkins/workspace/generic-package-rhel64-6-0/topdir/B= UILD/hadoop-2.0.0-cdh4.0.1/src/hadoop-common-project/hadoop-common

&nbs= p;

hsql= db ver 2.2.9.

&nbs= p;

Andy = Kartashov

M= PAC

Archi= tecture R&D, Co-op

1340 = Pickering Parkway, Pickering, L1V 0C4

( Phone : (905) 837 626= 9

( Mobile: (416) 722 178= 7

andy.kartashov@mpac.ca

&nbs= p;

Fro= m: Marcos Ortiz [m= ailto:mlortiz@uci.cu]
Sent: Friday, October 05, 2012 10:52 AM
To: user@hadoop.apache.org
Cc: Kartashov, Andy
Subject: Re: sqoop jobs

 

Which version of Sqoo= p are you using?
Which version of Hadoop?

On 10/05/2012 09:45 AM, Kartashov, Andy wrote:

Guys= ,

&nbs= p;

Have= any one successfully executed commands like

Sqoo= p job –list

Sqoo= p job –create .. etc.

Do I= need to set-up my sqoop-core.xml  before hand?

&nbs= p;

Exam= ple..

sqoo= p job --list

12/1= 0/05 09:44:29 WARN hsqldb.HsqldbJobStorage: Could not interpret as a number= : null

12/1= 0/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: Can not interpret metadata sch= ema

12/1= 0/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: The metadata schema version is= null

12/1= 0/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: The highest version supported = is 0

12/1= 0/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, = you must downgrade your metadata schema.

12/1= 0/05 09:44:29 ERROR tool.JobTool: I/O error performing job operation: java.= io.IOException: Invalid metadata version.

&nbs= p;       at org.apache.sqoop.metastore.hsqldb= .HsqldbJobStorage.init(HsqldbJobStorage.java:202)

&nbs= p;       at org.apache.sqoop.metastore.hsqldb= .AutoHsqldbStorage.open(AutoHsqldbStorage.java:112)

&nbs= p;       at org.apache.sqoop.tool.JobTool.run= (JobTool.java:279)

&nbs= p;       at org.apache.sqoop.Sqoop.run(Sqoop.= java:145)

&nbs= p;       at org.apache.hadoop.util.ToolRunner= .run(ToolRunner.java:70)

&nbs= p;       at org.apache.sqoop.Sqoop.runSqoop(S= qoop.java:181)

&nbs= p;       at org.apache.sqoop.Sqoop.runTool(Sq= oop.java:220)

&nbs= p;       at org.apache.sqoop.Sqoop.runTool(Sq= oop.java:229)

&nbs= p;       at org.apache.sqoop.Sqoop.main(Sqoop= .java:238)

&nbs= p;       at com.cloudera.sqoop.Sqoop.main(Sqo= op.java:57)

NOTICE: This e-mail message and any attachments are = confidential, subject to copyright and may be privileged. Any unauthorized = use, copying or disclosure is prohibited. If you are not the intended recip= ient, please delete and contact the sender immediately. Please consider the environment before printing this e= -mail. AVIS : le pr=E9sent courriel et toute pi=E8ce jointe qui l'accompagn= e sont confidentiels, prot=E9g=E9s par le droit d'auteur et peuvent =EAtre = couverts par le secret professionnel. Toute utilisation, copie ou divulgation non autoris=E9e est interdite. Si vous n= '=EAtes pas le destinataire pr=E9vu de ce courriel, supprimez-le et contact= ez imm=E9diatement l'exp=E9diteur. Veuillez penser =E0 l'environnement avan= t d'imprimer le pr=E9sent courriel
3D"Description:=

 

--

Marcos Luis Ort=EDz Valmaseda
Data Engineer && Sr. System Administrator at UCI
about.me/marcosortiz
My Blog
Tumblr's blog
@marcosluis2186

 

3D"Descr=

 

NOTICE: This e-mail message and any attachments are confidential, subject t= o copyright and may be privileged. Any unauthorized use, copying or disclos= ure is prohibited. If you are not the intended recipient, please delete and= contact the sender immediately. Please consider the environment before printing this e-mail. AVIS : le pr= =E9sent courriel et toute pi=E8ce jointe qui l'accompagne sont confidentiel= s, prot=E9g=E9s par le droit d'auteur et peuvent =EAtre couverts par le sec= ret professionnel. Toute utilisation, copie ou divulgation non autoris=E9e est interdite. Si vous n'=EAtes pas le dest= inataire pr=E9vu de ce courriel, supprimez-le et contactez imm=E9diatement = l'exp=E9diteur. Veuillez penser =E0 l'environnement avant d'imprimer le pr= =E9sent courriel --_000_BD42F346AE90F544A731516A805D1B8AD70B9FSMAIL1prdmpacca_-- --_004_BD42F346AE90F544A731516A805D1B8AD70B9FSMAIL1prdmpacca_ Content-Type: image/jpeg; name="~WRD000.jpg" Content-Description: ~WRD000.jpg Content-Disposition: inline; filename="~WRD000.jpg"; size=823; creation-date="Fri, 05 Oct 2012 14:56:44 GMT"; modification-date="Fri, 05 Oct 2012 14:56:44 GMT" Content-ID: <~WRD000.jpg> Content-Transfer-Encoding: base64 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABkAGQDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigD//2Q== --_004_BD42F346AE90F544A731516A805D1B8AD70B9FSMAIL1prdmpacca_--