title: how to get database username and password in hive
body: <p>Am writing jdbc program to connect hive database. I want the username and password to give it in the connection url.</p>
  
  <p>I don't know how to get the username and password using hive QL.
  Can anybody help me out??</p>
  
  <pre><code>Exception in thread "main" java.sql.SQLNonTransientConnectionException: [DataDirect][Hive JDBC Driver]A value was not specified for a required property: PASSWORD
      at com.ddtek.jdbc.hivebase.ddcp.b(Unknown Source)
      at com.ddtek.jdbc.hivebase.ddcp.a(Unknown Source)
      at com.ddtek.jdbc.hivebase.ddco.b(Unknown Source)
      at com.ddtek.jdbc.hivebase.ddco.a(Unknown Source)
      at com.ddtek.jdbc.hive.HiveImplConnection.b(Unknown Source)
      at com.ddtek.jdbc.hivebase.BaseConnection.b(Unknown Source)
      at com.ddtek.jdbc.hivebase.BaseConnection.k(Unknown Source)
      at com.ddtek.jdbc.hivebase.BaseConnection.b(Unknown Source)
      at com.ddtek.jdbc.hivebase.BaseConnection.a(Unknown Source)
      at com.ddtek.jdbc.hivebase.BaseDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:571)
      at java.sql.DriverManager.getConnection(DriverManager.java:215)
      at hivejdbcconnection.HiveJdbcConnection.main(HiveJdbcConnection.java:33)
  Java Result: 1
  </code></pre>