FAQ
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.

Thanks,
Darren


On Fri, Jun 14, 2013 at 1:00 PM, Satish Sathiyavageswaran wrote:

Hi All,

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
directory
Hive history
file=/tmp/release/hive_job_log_release_201306141538_1115960297.txt
FAILED: SemanticException Operation not supported.


But the hive cli works,

$ hive -e "show tables;"
Logging initialized using configuration in
jar:file:/usr/lib/hive/lib/hive-common-0.9.0-cdh4.1.2.jar!/hive-log4j.properties
Hive history
file=/tmp/release/hive_job_log_release_201306141556_28824933.txt
OK
foo
Time taken: 2.152 seconds


Running,

Hadoop 2.0.0-cdh4.2.1
Hive is 0.9

Metastore is installed as remote service ( Hive Server and metastore runs
as separate process ).


Any help is appreciated !

Thanks,

Satish

--
Thanks,
Darren

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
groupscm-users @
categorieshadoop
postedJun 14, '13 at 8:00p
activeJun 17, '13 at 4:22p
posts3
users2
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase