[
https://issues.apache.org/jira/browse/HIVE-7871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hari Sankar Sivarama Subramaniyan updated HIVE-7871:
----------------------------------------------------
Attachment: HIVE-7871.1.patch
Similar changes need to be made for the remaining end points in Server.java
> 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
> Attachments: HIVE-7871.1.patch
>
>
> 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)
