The following table describes the connection properties used to configure user ID/Password authentication. The first section describes the properties required for user ID/Password authentication, while the second lists the additional properties required to enable the cookie-based authentication feature.

Table 1. User ID/Password Authentication Properties
Property Characteristic
User ID/Password Authentication
AuthenticationMethod

Determines which authentication method the driver uses when establishing a connection.

If set to kerberos, the driver uses Kerberos authentication.

If set to userIdPassword, the driver uses user ID/password authentication.

If set to none, the driver does not attempt to verify the user ID and password. When a packet is passed to the server, a value of Anonymous is specified for the user ID and password. This setting is used when the server is not configured to authenticate user logon information.

The default is userIdPassword.

Password

Specifies a password that is used to connect to your database.

User

Specifies the user name that is used to connect to the database.

ImpersonateUser

 Specifies the user ID used for Impersonation. When Impersonation is enabled on the server (hive.server2.enable.doAs=true), this value determines your identity and access rights to Hadoop resources when executing queries. If Impersonation is disabled, you will execute queries as the user who initiated the HiveServer2 process.
Additional Properties for Cookie Based Authentication (HTTP Mode only)
CookieName Specifies the name of the cookie used for authenticating HTTP requests when HTTP mode TransportMode=http and cookie based authentication are enabled (EnableCookieAuthentication=true).

The default is hive.server2.auth.
EnableCookieAuthentication Determines whether the driver attempts to use cookie based authentication for requests to an HTTP endpoint after the initial authentication to the server. Cookie based authentication improves response time by eliminating the need to re-authenticate with the server for each request.

The default is true.