FAQ
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

Search Discussions

  • Darren Lo at Jun 15, 2013 at 5:35 am
    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
  • Satish Sathiyavageswaran at Jun 17, 2013 at 4:22 pm
    Sounds like a solution . Will try out CM4.6 and see if that helps.

    FYI : my CDH4.2 has hive 0.9 lib jars for some reason.
    On Saturday, 15 June 2013 01:34:58 UTC-4, Darren Lo wrote:

    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 <
    satish....@gmail.com <javascript:>> 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

Related Discussions

Discussion Navigation
viewthread | post
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