Databases Reference
In-Depth Information
Discussion
Running the metastore as a service will start the embedded HSQLDB database that will
be exposed to the rest of your cluster. The default port is 16000, and you can configure
it in the
sqoop-site.xml
file with the
sqoop.metastore.server.port
configuration
property.
In order to reuse the shared metastore, you can either use the parameter
--meta-
connect
on every Sqoop execution or save the value into the
sqoop-site.xml
config‐
uration file in the property
sqoop.metastore.client.autoconnect.url
:
<configuration>
...
<property>
<name>
sqoop.metastore.client.autoconnect.url
</name>
<value>
jdbc:hsqldb:hsql://your-metastore:16000/sqoop
</value>
</property>
</configuration>
