You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-user@hadoop.apache.org by "Kartashov, Andy" <An...@mpac.ca> on 2012/11/08 22:21:18 UTC
hsqldb version problem
Guys,
Please help me out here. Have issue with the versions. Have both hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come with and why do I have two? I want to know in case I need to reinstall/upgrade...
The problem is, my Sqoop jobs were initially complaining whenever I tried to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one. All worked fine until I started playing with sqoop metastore. I could start the metastore daemon fine but when I would execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema.
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)
I realise that it is to do with me moving the 1.8.0 jar away. But, when I bring it back, $sqoop import.... jobs don't execute and start complaining again.
p.s. I just installed and are playing with Oozie. I see that it is also using 1.8.0 version of hsqldb.jar file.
So, how to do? How can I start using 1.8.0 jar without issues or else?
My set-up:
Hadoop 2.0.0-cdh4.1.1
Sqoop 1.4.1-cdh4.0.1
Oozie client build version: 3.2.0-cdh4.1.2
Mapreduce-0.20
Rgds,
AK47
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: hsqldb version problem
Posted by "Kartashov, Andy" <An...@mpac.ca>.
Thank you Arvind,
However, you've only partially answered my questions:
Q. ...which project do they come with and why do I have two?
>From your response below I understand that 1.8.0.10 hsqldb.jar file comes with Sqoop while 2.2.9 is instaled with CD4.
Q. I replaced hsqldb-1.8.0.10.jar file with hsqldb (ver 2.2.9) and... after I start the metastore daemon fine and execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema. How do I do it?
Thanks
AK47
From: Arvind Prabhakar [mailto:arvind@cloudera.com]
Sent: Wednesday, November 14, 2012 7:05 PM
To: cdh-user@cloudera.org
Subject: Re: hsqldb version problem
[Moving thread to cdh-user@cloudera.org<ma...@cloudera.org> as it seems to be CDH related + bcc:user@hadoop.a.o]
Hi,
The underlying issue is that Sqoop depends upon HSQLDB 1.x whereas the default jar bundled with CDH 4 is HSQLDB 2.x. Since this is bundled with Hadoop for example purposes only, you should be able to carefully remove it from the classpath and replace it with the previous version in order to get past this problem.
Regards,
Arvind Prabhakar
On Thu, Nov 8, 2012 at 1:21 PM, Kartashov, Andy <An...@mpac.ca>> wrote:
Guys,
Please help me out here. Have issue with the versions. Have both hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come with and why do I have two? I want to know in case I need to reinstall/upgrade...
The problem is, my Sqoop jobs were initially complaining whenever I tried to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one. All worked fine until I started playing with sqoop metastore. I could start the metastore daemon fine but when I would execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema.
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)
I realise that it is to do with me moving the 1.8.0 jar away. But, when I bring it back, $sqoop import.... jobs don't execute and start complaining again.
p.s. I just installed and are playing with Oozie. I see that it is also using 1.8.0 version of hsqldb.jar file.
So, how to do? How can I start using 1.8.0 jar without issues or else?
My set-up:
Hadoop 2.0.0-cdh4.1.1
Sqoop 1.4.1-cdh4.0.1
Oozie client build version: 3.2.0-cdh4.1.2
Mapreduce-0.20
Rgds,
AK47
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
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: hsqldb version problem
Posted by "Kartashov, Andy" <An...@mpac.ca>.
Thank you Arvind,
However, you've only partially answered my questions:
Q. ...which project do they come with and why do I have two?
>From your response below I understand that 1.8.0.10 hsqldb.jar file comes with Sqoop while 2.2.9 is instaled with CD4.
Q. I replaced hsqldb-1.8.0.10.jar file with hsqldb (ver 2.2.9) and... after I start the metastore daemon fine and execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema. How do I do it?
Thanks
AK47
From: Arvind Prabhakar [mailto:arvind@cloudera.com]
Sent: Wednesday, November 14, 2012 7:05 PM
To: cdh-user@cloudera.org
Subject: Re: hsqldb version problem
[Moving thread to cdh-user@cloudera.org<ma...@cloudera.org> as it seems to be CDH related + bcc:user@hadoop.a.o]
Hi,
The underlying issue is that Sqoop depends upon HSQLDB 1.x whereas the default jar bundled with CDH 4 is HSQLDB 2.x. Since this is bundled with Hadoop for example purposes only, you should be able to carefully remove it from the classpath and replace it with the previous version in order to get past this problem.
Regards,
Arvind Prabhakar
On Thu, Nov 8, 2012 at 1:21 PM, Kartashov, Andy <An...@mpac.ca>> wrote:
Guys,
Please help me out here. Have issue with the versions. Have both hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come with and why do I have two? I want to know in case I need to reinstall/upgrade...
The problem is, my Sqoop jobs were initially complaining whenever I tried to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one. All worked fine until I started playing with sqoop metastore. I could start the metastore daemon fine but when I would execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema.
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)
I realise that it is to do with me moving the 1.8.0 jar away. But, when I bring it back, $sqoop import.... jobs don't execute and start complaining again.
p.s. I just installed and are playing with Oozie. I see that it is also using 1.8.0 version of hsqldb.jar file.
So, how to do? How can I start using 1.8.0 jar without issues or else?
My set-up:
Hadoop 2.0.0-cdh4.1.1
Sqoop 1.4.1-cdh4.0.1
Oozie client build version: 3.2.0-cdh4.1.2
Mapreduce-0.20
Rgds,
AK47
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
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: hsqldb version problem
Posted by "Kartashov, Andy" <An...@mpac.ca>.
Thank you Arvind,
However, you've only partially answered my questions:
Q. ...which project do they come with and why do I have two?
>From your response below I understand that 1.8.0.10 hsqldb.jar file comes with Sqoop while 2.2.9 is instaled with CD4.
Q. I replaced hsqldb-1.8.0.10.jar file with hsqldb (ver 2.2.9) and... after I start the metastore daemon fine and execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema. How do I do it?
Thanks
AK47
From: Arvind Prabhakar [mailto:arvind@cloudera.com]
Sent: Wednesday, November 14, 2012 7:05 PM
To: cdh-user@cloudera.org
Subject: Re: hsqldb version problem
[Moving thread to cdh-user@cloudera.org<ma...@cloudera.org> as it seems to be CDH related + bcc:user@hadoop.a.o]
Hi,
The underlying issue is that Sqoop depends upon HSQLDB 1.x whereas the default jar bundled with CDH 4 is HSQLDB 2.x. Since this is bundled with Hadoop for example purposes only, you should be able to carefully remove it from the classpath and replace it with the previous version in order to get past this problem.
Regards,
Arvind Prabhakar
On Thu, Nov 8, 2012 at 1:21 PM, Kartashov, Andy <An...@mpac.ca>> wrote:
Guys,
Please help me out here. Have issue with the versions. Have both hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come with and why do I have two? I want to know in case I need to reinstall/upgrade...
The problem is, my Sqoop jobs were initially complaining whenever I tried to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one. All worked fine until I started playing with sqoop metastore. I could start the metastore daemon fine but when I would execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema.
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)
I realise that it is to do with me moving the 1.8.0 jar away. But, when I bring it back, $sqoop import.... jobs don't execute and start complaining again.
p.s. I just installed and are playing with Oozie. I see that it is also using 1.8.0 version of hsqldb.jar file.
So, how to do? How can I start using 1.8.0 jar without issues or else?
My set-up:
Hadoop 2.0.0-cdh4.1.1
Sqoop 1.4.1-cdh4.0.1
Oozie client build version: 3.2.0-cdh4.1.2
Mapreduce-0.20
Rgds,
AK47
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
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: hsqldb version problem
Posted by "Kartashov, Andy" <An...@mpac.ca>.
Thank you Arvind,
However, you've only partially answered my questions:
Q. ...which project do they come with and why do I have two?
>From your response below I understand that 1.8.0.10 hsqldb.jar file comes with Sqoop while 2.2.9 is instaled with CD4.
Q. I replaced hsqldb-1.8.0.10.jar file with hsqldb (ver 2.2.9) and... after I start the metastore daemon fine and execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema. How do I do it?
Thanks
AK47
From: Arvind Prabhakar [mailto:arvind@cloudera.com]
Sent: Wednesday, November 14, 2012 7:05 PM
To: cdh-user@cloudera.org
Subject: Re: hsqldb version problem
[Moving thread to cdh-user@cloudera.org<ma...@cloudera.org> as it seems to be CDH related + bcc:user@hadoop.a.o]
Hi,
The underlying issue is that Sqoop depends upon HSQLDB 1.x whereas the default jar bundled with CDH 4 is HSQLDB 2.x. Since this is bundled with Hadoop for example purposes only, you should be able to carefully remove it from the classpath and replace it with the previous version in order to get past this problem.
Regards,
Arvind Prabhakar
On Thu, Nov 8, 2012 at 1:21 PM, Kartashov, Andy <An...@mpac.ca>> wrote:
Guys,
Please help me out here. Have issue with the versions. Have both hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come with and why do I have two? I want to know in case I need to reinstall/upgrade...
The problem is, my Sqoop jobs were initially complaining whenever I tried to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one. All worked fine until I started playing with sqoop metastore. I could start the metastore daemon fine but when I would execute "$sqoop job -list", I started receiving this error.
ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must downgrade your metadata schema.
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)
I realise that it is to do with me moving the 1.8.0 jar away. But, when I bring it back, $sqoop import.... jobs don't execute and start complaining again.
p.s. I just installed and are playing with Oozie. I see that it is also using 1.8.0 version of hsqldb.jar file.
So, how to do? How can I start using 1.8.0 jar without issues or else?
My set-up:
Hadoop 2.0.0-cdh4.1.1
Sqoop 1.4.1-cdh4.0.1
Oozie client build version: 3.2.0-cdh4.1.2
Mapreduce-0.20
Rgds,
AK47
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
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: hsqldb version problem
Posted by Arvind Prabhakar <ar...@cloudera.com>.
[Moving thread to cdh-user@cloudera.org as it seems to be CDH related +
bcc:user@hadoop.a.o]
Hi,
The underlying issue is that Sqoop depends upon HSQLDB 1.x whereas the
default jar bundled with CDH 4 is HSQLDB 2.x. Since this is bundled with
Hadoop for example purposes only, you should be able to carefully remove it
from the classpath and replace it with the previous version in order to get
past this problem.
Regards,
Arvind Prabhakar
On Thu, Nov 8, 2012 at 1:21 PM, Kartashov, Andy <An...@mpac.ca>wrote:
> Guys,
>
> Please help me out here. Have issue with the versions. Have both
> hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come
> with and why do I have two? I want to know in case I need to
> reinstall/upgrade...
>
> The problem is, my Sqoop jobs were initially complaining whenever I tried
> to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that
> issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one.
> All worked fine until I started playing with sqoop metastore. I could
> start the metastore daemon fine but when I would execute "$sqoop job
> -list", I started receiving this error.
>
> ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must
> downgrade your metadata schema.
> 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)
>
> I realise that it is to do with me moving the 1.8.0 jar away. But, when I
> bring it back, $sqoop import.... jobs don't execute and start complaining
> again.
>
> p.s. I just installed and are playing with Oozie. I see that it is also
> using 1.8.0 version of hsqldb.jar file.
>
> So, how to do? How can I start using 1.8.0 jar without issues or else?
>
> My set-up:
> Hadoop 2.0.0-cdh4.1.1
> Sqoop 1.4.1-cdh4.0.1
> Oozie client build version: 3.2.0-cdh4.1.2
> Mapreduce-0.20
>
> Rgds,
> AK47
> 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: hsqldb version problem
Posted by Arvind Prabhakar <ar...@cloudera.com>.
[Moving thread to cdh-user@cloudera.org as it seems to be CDH related +
bcc:user@hadoop.a.o]
Hi,
The underlying issue is that Sqoop depends upon HSQLDB 1.x whereas the
default jar bundled with CDH 4 is HSQLDB 2.x. Since this is bundled with
Hadoop for example purposes only, you should be able to carefully remove it
from the classpath and replace it with the previous version in order to get
past this problem.
Regards,
Arvind Prabhakar
On Thu, Nov 8, 2012 at 1:21 PM, Kartashov, Andy <An...@mpac.ca>wrote:
> Guys,
>
> Please help me out here. Have issue with the versions. Have both
> hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come
> with and why do I have two? I want to know in case I need to
> reinstall/upgrade...
>
> The problem is, my Sqoop jobs were initially complaining whenever I tried
> to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that
> issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one.
> All worked fine until I started playing with sqoop metastore. I could
> start the metastore daemon fine but when I would execute "$sqoop job
> -list", I started receiving this error.
>
> ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must
> downgrade your metadata schema.
> 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)
>
> I realise that it is to do with me moving the 1.8.0 jar away. But, when I
> bring it back, $sqoop import.... jobs don't execute and start complaining
> again.
>
> p.s. I just installed and are playing with Oozie. I see that it is also
> using 1.8.0 version of hsqldb.jar file.
>
> So, how to do? How can I start using 1.8.0 jar without issues or else?
>
> My set-up:
> Hadoop 2.0.0-cdh4.1.1
> Sqoop 1.4.1-cdh4.0.1
> Oozie client build version: 3.2.0-cdh4.1.2
> Mapreduce-0.20
>
> Rgds,
> AK47
> 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: hsqldb version problem
Posted by Arvind Prabhakar <ar...@cloudera.com>.
[Moving thread to cdh-user@cloudera.org as it seems to be CDH related +
bcc:user@hadoop.a.o]
Hi,
The underlying issue is that Sqoop depends upon HSQLDB 1.x whereas the
default jar bundled with CDH 4 is HSQLDB 2.x. Since this is bundled with
Hadoop for example purposes only, you should be able to carefully remove it
from the classpath and replace it with the previous version in order to get
past this problem.
Regards,
Arvind Prabhakar
On Thu, Nov 8, 2012 at 1:21 PM, Kartashov, Andy <An...@mpac.ca>wrote:
> Guys,
>
> Please help me out here. Have issue with the versions. Have both
> hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come
> with and why do I have two? I want to know in case I need to
> reinstall/upgrade...
>
> The problem is, my Sqoop jobs were initially complaining whenever I tried
> to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that
> issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one.
> All worked fine until I started playing with sqoop metastore. I could
> start the metastore daemon fine but when I would execute "$sqoop job
> -list", I started receiving this error.
>
> ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must
> downgrade your metadata schema.
> 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)
>
> I realise that it is to do with me moving the 1.8.0 jar away. But, when I
> bring it back, $sqoop import.... jobs don't execute and start complaining
> again.
>
> p.s. I just installed and are playing with Oozie. I see that it is also
> using 1.8.0 version of hsqldb.jar file.
>
> So, how to do? How can I start using 1.8.0 jar without issues or else?
>
> My set-up:
> Hadoop 2.0.0-cdh4.1.1
> Sqoop 1.4.1-cdh4.0.1
> Oozie client build version: 3.2.0-cdh4.1.2
> Mapreduce-0.20
>
> Rgds,
> AK47
> 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: hsqldb version problem
Posted by Arvind Prabhakar <ar...@cloudera.com>.
[Moving thread to cdh-user@cloudera.org as it seems to be CDH related +
bcc:user@hadoop.a.o]
Hi,
The underlying issue is that Sqoop depends upon HSQLDB 1.x whereas the
default jar bundled with CDH 4 is HSQLDB 2.x. Since this is bundled with
Hadoop for example purposes only, you should be able to carefully remove it
from the classpath and replace it with the previous version in order to get
past this problem.
Regards,
Arvind Prabhakar
On Thu, Nov 8, 2012 at 1:21 PM, Kartashov, Andy <An...@mpac.ca>wrote:
> Guys,
>
> Please help me out here. Have issue with the versions. Have both
> hsqldb.jar in 2.2.9 and 1.8.0.10 By the way, which project do they come
> with and why do I have two? I want to know in case I need to
> reinstall/upgrade...
>
> The problem is, my Sqoop jobs were initially complaining whenever I tried
> to run them, looking for 2.2.9 version of hsqldb.jar. Well I resolved that
> issue by moving the hsqldb-1.8.0.10.jar away and bringing in 2.2.9 one.
> All worked fine until I started playing with sqoop metastore. I could
> start the metastore daemon fine but when I would execute "$sqoop job
> -list", I started receiving this error.
>
> ERROR hsqldb.HsqldbJobStorage: To use this version of Sqoop, you must
> downgrade your metadata schema.
> 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)
>
> I realise that it is to do with me moving the 1.8.0 jar away. But, when I
> bring it back, $sqoop import.... jobs don't execute and start complaining
> again.
>
> p.s. I just installed and are playing with Oozie. I see that it is also
> using 1.8.0 version of hsqldb.jar file.
>
> So, how to do? How can I start using 1.8.0 jar without issues or else?
>
> My set-up:
> Hadoop 2.0.0-cdh4.1.1
> Sqoop 1.4.1-cdh4.0.1
> Oozie client build version: 3.2.0-cdh4.1.2
> Mapreduce-0.20
>
> Rgds,
> AK47
> 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
>