@dennisli,
No, that password stuff is all server side. There are no passwords to supply from the hive client side.
Can you explain what you have done so far with CDH and what you are trying to do?
Are you following some instructions? Are you new to Cloudera Manager and CDH?
There are some fundamental concepts about how configuration is done with a managed cluster, so feel free to ask questions.
If you installed Cloudera Manager and then used it install CDH with parcels, then if you run "hive" command from any host that has a Hive role on it.
For instance, if you have HiveServer2 or the Metastore or a Gateway role installed on hosta.example.com, you can ssh to hosta.example.com and simply run:
hive
This will connect according to the client configuration that is in /etc. Cloudera Manager manages the passwords in your hive-site.xml, so you should not have to do anything with them. The "*******" is redacted so you can't see the password.
Try going to a host with a Hive role on it and run:
hive
once you get a prompt, you can run:
hive> show databases;
