You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hadoop.apache.org by Marcos Ortiz <ml...@uci.cu> on 2012/10/05 16:51:41 UTC
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 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
>
> <http://www.uci.cu/>
--
Marcos Luis Ortíz Valmaseda
*Data Engineer && Sr. System Administrator at UCI*
about.me/marcosortiz <http://about.me/marcosortiz>
My Blog <http://marcosluis2186.posterous.com>
Tumblr's blog <http://marcosortiz.tumblr.com/>
@marcosluis2186 <http://twitter.com/marcosluis2186>
10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
http://www.uci.cu
http://www.facebook.com/universidad.uci
http://www.flickr.com/photos/universidad_uci
RE: sqoop jobs
Posted by "Kartashov, Andy" <An...@mpac.ca>.
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/topdir/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<ma...@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 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
[Description: Image removed by sender.]
<http://www.uci.cu/>
--
Marcos Luis Ortíz Valmaseda
Data Engineer && Sr. System Administrator at UCI
about.me/marcosortiz<http://about.me/marcosortiz>
My Blog<http://marcosluis2186.posterous.com>
Tumblr's blog<http://marcosortiz.tumblr.com/>
@marcosluis2186<http://twitter.com/marcosluis2186>
[Description: Image removed by sender.]<http://www.uci.cu/>
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
RE: sqoop jobs
Posted by "Kartashov, Andy" <An...@mpac.ca>.
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/topdir/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<ma...@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 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
[Description: Image removed by sender.]
<http://www.uci.cu/>
--
Marcos Luis Ortíz Valmaseda
Data Engineer && Sr. System Administrator at UCI
about.me/marcosortiz<http://about.me/marcosortiz>
My Blog<http://marcosluis2186.posterous.com>
Tumblr's blog<http://marcosortiz.tumblr.com/>
@marcosluis2186<http://twitter.com/marcosluis2186>
[Description: Image removed by sender.]<http://www.uci.cu/>
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
RE: sqoop jobs
Posted by "Kartashov, Andy" <An...@mpac.ca>.
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/topdir/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<ma...@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 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
[Description: Image removed by sender.]
<http://www.uci.cu/>
--
Marcos Luis Ortíz Valmaseda
Data Engineer && Sr. System Administrator at UCI
about.me/marcosortiz<http://about.me/marcosortiz>
My Blog<http://marcosluis2186.posterous.com>
Tumblr's blog<http://marcosortiz.tumblr.com/>
@marcosluis2186<http://twitter.com/marcosluis2186>
[Description: Image removed by sender.]<http://www.uci.cu/>
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
RE: sqoop jobs
Posted by "Kartashov, Andy" <An...@mpac.ca>.
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/topdir/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<ma...@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 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
[Description: Image removed by sender.]
<http://www.uci.cu/>
--
Marcos Luis Ortíz Valmaseda
Data Engineer && Sr. System Administrator at UCI
about.me/marcosortiz<http://about.me/marcosortiz>
My Blog<http://marcosluis2186.posterous.com>
Tumblr's blog<http://marcosortiz.tumblr.com/>
@marcosluis2186<http://twitter.com/marcosluis2186>
[Description: Image removed by sender.]<http://www.uci.cu/>
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