Note that in CM4.6 will install and manage WebHCat for you. This is much
easier than manual install.
CDH4.2 should have hive 0.10 as the version. Are you sure you're running
these versions? You can check /usr/lib/hive/cloudera to find the precise
version of hive, and similarly for HDFS.
Check out the Hive history file mentioned in your hcat console output, and
also check the Hive Metastore Server logs. Anything interesting?
hcat CLI should work on any host that has hive configs deployed in CDH4.2,
so long as you are using the remote metastore (Hive Metastore Server). Can
you double-check that your /etc/hive/conf has the correct metastore URL
set? If not, you may need to add a gateway role your Hive service for the
host where you are running commands, then run the Hive command Deploy
Client Configuration from the Actions dropdown.
On Fri, Jun 14, 2013 at 1:00 PM, Satish Sathiyavageswaran wrote:
I installed Hadoop, Hive and other services using the cloudera manager.
Then I installed WebHCat using yum.
Running hcat cli, gives the following error.
$ hcat -e "show tables;"
/usr/lib/hcatalog/bin/hcat: line 1: !/usr/bin/env: No such file or
FAILED: SemanticException Operation not supported.
But the hive cli works,
$ hive -e "show tables;"
Logging initialized using configuration in
Time taken: 2.152 seconds
Hive is 0.9
Metastore is installed as remote service ( Hive Server and metastore runs
as separate process ).
Any help is appreciated !