If using Hue and the Bypass Hive Metastore Server option is not selected (metastore bypass is disabled by default), then Hue will not be able to communicate with Hive with CDH 4.0 or CDH 4.1. This is not a problem with CDH 4.2 or higher.

If you are using CDH 4.0 or 4.1, you can workaround this issue following the instructions in the Known Issues section of the Cloudera Manager 4 Release Notes.