...

1. Login to Ambari.
2. In the left nav bar, select Hive. 
3. Copy the HiveServer2 Interactive JDBC URL to the clipboard.

4. Paste it into a text editor. It should look something like the following:
   
   

   Code Block
   jdbc:hive2://hdp26-w-1.c.example:2181,hdp26-w-3.c.example:2181,hdp26-w-2.c.example:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2

5. When you create the connection in 

   D s product

   :

   1. Host: Specify the first host value in the URL. In the above, it is this value:

      Code Block
      hdp26-w-1.c.example:2181,hdp26-w-3.c.example:2181,hdp26-w-2.c.example

   2. Port Number: In the above, it is this value:
      
      

      Code Block
      2181

   3. Connect String Options: In the above, it is this value:
      
      

      Code Block
      ;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2

6. Specify the other properties accordingly. 

...