Command Line Upgrade
Also available as:
loading table of contents...

Configure and Start Apache WebHCat (Templeton)


The su commands in this section use keywords to represent the Service user. For example, "webhcat" is used to represent the Apache WebHCat Service user. If you are using another name for your Service users, you need to substitute your Service user name in each of the su commands.

  1. You must replace your configuration after upgrading. Copy /etc/webhcat/conf from the template to the conf directory in webhcat hosts.

  2. Modify the WebHCat configuration files.

    • Upload Pig, Hive and Sqoop tarballs to HDFS as the $HDFS_User. In this example, hdfs:

      hdfs dfs -mkdir -p /hdp/apps/<$version>/pig/
      hdfs dfs -mkdir -p /hdp/apps/<$version>/hive/
      hdfs dfs -mkdir -p /hdp/apps/<$version>/sqoop/
      hdfs dfs -put /usr/hdp/<$version>/pig/pig.tar.gz /hdp/apps/<$version>/pig/
      hdfs dfs -put /usr/hdp/<$version>/hive/hive.tar.gz /hdp/apps/<$version>/hive/
      hdfs dfs -put /usr/hdp/<$version>/sqoop/sqoop.tar.gz /hdp/apps/<$version>/sqoop/
      hdfs dfs -chmod -R 555 /hdp/apps/<$version>/pig
      hdfs dfs -chmod -R 444 /hdp/apps/<$version>/pig/pig.tar.gz
      hdfs dfs -chmod -R 555 /hdp/apps/<$version>/hive
      hdfs dfs -chmod -R 444 /hdp/apps/<$version>/hive/hive.tar.gz
      hdfs dfs -chmod -R 555 /hdp/apps/<$version>/sqoop
      hdfs dfs -chmod -R 444 /hdp/apps/<$version>/sqoop/sqoop.tar.gz
      hdfs dfs -chown -R hdfs:hadoop /hdp
    • Update the following properties in the webhcat-site.xml configuration file, as their values have changed:

       <description>The hdfs path to the Hadoop streaming jar file.</description>
       <description>The path to the Sqoop archive.</description>
       <description>The path to the Sqoop executable.</description>
       <description>The path to the Sqoop home in the exploded archive.</description>

      You do not need to modify ${hdp.version}.

    • Remove the following obsolete properties from webhcat-site.xml:

       <description>Total virtual memory available to map tasks.</description>
    • Add new proxy users, if needed. In core-site.xml, make sure the following properties are also set to allow WebHcat to impersonate your additional HDP 2.5 groups and hosts:



      is a comma-separated list of the Unix groups whose users may be impersonated by 'hcat'.


      A comma-separated list of the hosts that are allowed to submit requests by 'hcat'.

  3. Start WebHCat:

    su - webhcat -c "/usr/hdp/current/hive-hcatalog/sbin/ start"

  4. Smoke test WebHCat.

    • At the WebHCat host machine, run the following command:


    • If you are using a secure cluster, run the following command:

      curl --negotiate -u: http://cluster.$PRINCIPAL.$REALM:50111/templeton/v1/status {"status":"ok","version":"v1"}[machine@acme]$