You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "alexBai (JIRA)" <ji...@apache.org> on 2016/02/26 05:04:18 UTC
[jira] [Commented] (SQOOP-2851) Could not change the sqoop
metastore username in the sqoop-site.xml ?
[ https://issues.apache.org/jira/browse/SQOOP-2851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15168404#comment-15168404 ]
alexBai commented on SQOOP-2851:
--------------------------------
Sqoop-site.xml:
<configuration>
<property>
<name>sqoop.metastore.client.enable.autoconnect</name>
<value>true</value>
</property>
<property>
<name>sqoop.metastore.client.autoconnect.url</name>
<value>jdbc:hsqldb:hsql://xxx:16000/sqoop</value>
</property>
<property>
<name>sqoop.metastore.client.autoconnect.username</name>
<value>sqoop</value>
</property>
<property>
<name>sqoop.metastore.client.autoconnect.password</name>
<value>sqoop</value>
</property>
<property>
<name>sqoop.metastore.client.record.password</name>
<value>true</value>
</property>
<property>
<name>sqoop.metastore.server.location</name>
<value>/usr/lib/sqoop/metastore/</value>
</property>
<property>
<name>sqoop.metastore.server.port</name>
<value>16000</value>
</property>
</configuration>
> Could not change the sqoop metastore username in the sqoop-site.xml ?
> ----------------------------------------------------------------------
>
> Key: SQOOP-2851
> URL: https://issues.apache.org/jira/browse/SQOOP-2851
> Project: Sqoop
> Issue Type: Bug
> Components: metastore
> Affects Versions: 1.4.6
> Environment: sqoop-1.4.6
> hadoop-2.6.0
> Reporter: alexBai
>
> sqoop job --list
> Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
> Please set $ACCUMULO_HOME to the root of your Accumulo installation.
> 16/02/26 12:00:47 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
> 16/02/26 12:00:47 ERROR tool.JobTool: I/O error performing job operation: java.io.IOException: Exception creating SQL connection
> at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:216)
> at org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112)
> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
> Caused by: java.sql.SQLException: User not found: SQOOP
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
> at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
> at org.hsqldb.jdbcDriver.connect(Unknown Source)
> at java.sql.DriverManager.getConnection(DriverManager.java:571)
> at java.sql.DriverManager.getConnection(DriverManager.java:215)
> at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176)
> ... 8 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)