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 3C947D069 for ; Fri, 5 Oct 2012 13:46:07 +0000 (UTC) Received: (qmail 65377 invoked by uid 500); 5 Oct 2012 13:46:02 -0000 Delivered-To: apmail-hadoop-user-archive@hadoop.apache.org Received: (qmail 65299 invoked by uid 500); 5 Oct 2012 13:46:02 -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 65291 invoked by uid 99); 5 Oct 2012 13:46:02 -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 13:46:02 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS 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 13:45:53 +0000 Received: from Spam1.prd.mpac.ca (unknown [127.0.0.1]) by IMSVA80 (Postfix) with ESMTP id 43B831D805A for ; Fri, 5 Oct 2012 09:45:30 -0400 (EDT) Received: from SMAIL1.prd.mpac.ca (unknown [172.29.2.53]) by Spam1.prd.mpac.ca (Postfix) with ESMTP id EE8E11D8057 for ; Fri, 5 Oct 2012 09:45:29 -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 09:45:29 -0400 From: "Kartashov, Andy" To: "user@hadoop.apache.org" Subject: sqoop jobs Thread-Topic: sqoop jobs Thread-Index: Ac2i/63T8xgFAa9aQLKrzfCDZI8xlg== Date: Fri, 5 Oct 2012 13:45:29 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.29.60.102] Content-Type: multipart/alternative; boundary="_000_BD42F346AE90F544A731516A805D1B8AD70B46SMAIL1prdmpacca_" 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--17.379-5.0-31-10 X-imss-scan-details: No--17.379-5.0-31-10 X-TM-AS-Result-Xfilter: Match text exemption rules:No X-TMASE-MatchedRID: cEwFPM9dcCTqZWtj3+d4AgPZZctd3P4BNQO+lFC5/FVBDVeC8J7uwX4U OBQdfZJq4ifNBjPqKM+SFz83U4eRVODjmHulaCpRvnSVh24OCE6JSC/4nFhFViGD+Fp3vZHUg4Q OTGRj/e33IMm4O0fO/zk2sxk9/brkH/K5u2IxMhJa6IhVNjeIiAMK5y1T7x5eqlz5g+vz6oPzTu 35URal5lehZ8JDMoGXaPRqhqPig2MiH63KRFU6CTbN0t/c2qF2MrX+p1uNztAUtdRZTmEaIU92x 1c6E6fkF5YdjcsqfMe0XdFsGUlXTTScgMqgJnG/utvHF25zoU9wsQ2gSTviLwhXVCKc/ywVUdfE Kc10rU54nNRC+UXW57edbQ6xZg3Ke4t+BIGa1PQvj6wHfIGxyRwMMtF4a3g9+ZQPGkWiBBeVHVx P1hp9BamAfpMgmLcUH519TjjtXtcPxPga7m2eWkZ4cxrF+rzVFyVj+0X3uTbOYu9caBy0BH7cGd 19dSFd --_000_BD42F346AE90F544A731516A805D1B8AD70B46SMAIL1prdmpacca_ Content-Type: text/plain; charset="us-ascii" 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 number: 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 version is null 12/10/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: The highest version supported is 0 12/10/05 09:44:29 ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema. 12/10/05 09:44:29 ERROR tool.JobTool: I/O error performing job operation: java.io.IOException: Invalid metadata version. at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) at org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.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 to copyright and may be privileged. Any unauthorized use, copying or disclosure 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?sent courriel et toute pi?ce jointe qui l'accompagne sont confidentiels, prot?g?s par le droit d'auteur et peuvent ?tre couverts par le secret professionnel. Toute utilisation, copie ou divulgation non autoris?e est interdite. Si vous n'?tes pas le destinataire pr?vu de ce courriel, supprimez-le et contactez imm?diatement l'exp?diteur. Veuillez penser ? l'environnement avant d'imprimer le pr?sent courriel --_000_BD42F346AE90F544A731516A805D1B8AD70B46SMAIL1prdmpacca_ Content-Type: text/html; charset="us-ascii"

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 number: 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 version is null

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

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

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

        at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202)

        at org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.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 to copyright and may be privileged. Any unauthorized use, copying or disclosure 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ésent courriel et toute pièce jointe qui l'accompagne sont confidentiels, protégés par le droit d'auteur et peuvent être couverts par le secret professionnel. Toute utilisation, copie ou divulgation non autorisée est interdite. Si vous n'êtes pas le destinataire prévu de ce courriel, supprimez-le et contactez immédiatement l'expéditeur. Veuillez penser à l'environnement avant d'imprimer le présent courriel --_000_BD42F346AE90F544A731516A805D1B8AD70B46SMAIL1prdmpacca_--