Found it myself, but in case someone else has the same question I did:   On a default CDH install, check /var/lib/cloudera-scm-server-db/data/generated-password.txt for the DB password. Then:   psql -h 127.0.0.1 -p 7432 -U cloudera-scm -W scm   HTH! ... View more

Hello!   I'm relatively new to the Hadoop ecosystem. Can you tell me from where I would go about querying against the hosts table you mention? Is it a Zookeeper thing? Hive? Any advice or direction towards documentation is greatly appreciated. Thanks! ... View more