Reply
Highlighted
New Contributor
Posts: 2
Registered: ‎01-21-2016

Multiple SQOOP HSQLDB Metastore

Hi Friend ,

 

I have requirment,where I have to store sqoop jobs for multiple databases in seprate HSQL Metastore. 

 

DB1 -  SQOOP1-Metastore

DB2 - SQOOP2-Metastore

 

If by any case i loose Metasotre-1 my Metasotre-2 will work fine .

 

How can I use HSQLDB for multiple sqoop repositry.

Your help will be highly appriciated .

 

Regards

Niraj 

Posts: 1,903
Kudos: 435
Solutions: 305
Registered: ‎07-31-2013

Re: Multiple SQOOP HSQLDB Metastore

The sqoop-metastore documentation at http://archive.cloudera.com/cdh5/cdh/5/sqoop/SqoopUserGuide.html#_syntax_7 indicates that you can specify the port to run the HSQL DB on:

"""
The location of the metastore’s files on disk is controlled by the sqoop.metastore.server.location property in conf/sqoop-site.xml. This should point to a directory on the local filesystem.

The metastore is available over TCP/IP. The port is controlled by the sqoop.metastore.server.port configuration parameter, and defaults to 16000.
"""

Configure two unique values for these properties in two different instances of the command to achieve your goal.

Specify the right port to use in further commands that need to reference the metastore.
New Contributor
Posts: 2
Registered: ‎01-21-2016

Re: Multiple SQOOP HSQLDB Metastore

Thanks Harsh,

 

Can you please elaborate bit more about you below comment,

 

"Configure two unique values for these properties in two different instances of the command to achieve your goal."

 

Did you mean on two different host ?

Can "sqoop.metastore.server.port " take comma delimited multiple value ?

Can "sqoop.metastore.server.location " take comma delimited multiple value ?

 

 

Your expert comment will be highly appreciated.

 

Regards

Niraj