[ https://issues.apache.org/jira/browse/HIVE-7871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hari Sankar Sivarama Subramaniyan updated HIVE-7871: ---------------------------------------------------- Status: Patch Available (was: Open) > 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)