You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hari Sankar Sivarama Subramaniyan (JIRA)" <ji...@apache.org> on 2014/08/25 19:52:59 UTC
[jira] [Created] (HIVE-7871) WebHCat: Hive job with SQL server as
MetastoreDB fails when Unicode characters are present in curl command
Hari Sankar Sivarama Subramaniyan created HIVE-7871:
-------------------------------------------------------
Summary: WebHCat: Hive job with SQL server as MetastoreDB fails when Unicode characters are present in curl command
Key: HIVE-7871
URL: https://issues.apache.org/jira/browse/HIVE-7871
Project: Hive
Issue Type: Bug
Components: WebHCat
Reporter: Hari Sankar Sivarama Subramaniyan
Assignee: Hari Sankar Sivarama Subramaniyan
Please follow the steps below to repro.
1. Create a SQL Server. Create Username, Password, DB with Unicode characters in their name.
2. Create a cluster and run the below command against its templeton endpoint
curl -i -u <username>:<password> \
-d define=javax.jdo.option.ConnectionUserName=<dbusername>@<SQLserver> \
-d define=hive.metastore.uris= \
-d define=javax.jdo.option.ConnectionURL=jdbc:sqlserver://<SQLserver>.database.windows.net;database=<dbname>; encrypt=true;trustServerCertificate=true;create=false \
-d define=javax.jdo.option.ConnectionPassword=<dbpassword> \
-d statusdir=/hivestatus \
-d user.name=admin \
-d enablelog=false \
-d execute="show tables;" \
-s "https://localhost:30111/templeton/v1/hive"
The following error message is received.
javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:sqlserver://<SQLserver>.database.windows.net;database=<dbname>; encrypt=true;trustServerCertificate=true;create=false, username = <dbusername>@<SQLserver>. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '<dbusername>'.
--
This message was sent by Atlassian JIRA
(v6.2#6252)