Setting up HCatalog, WebHCat with Hive

I am installing Hadoop , Hive to integrate with WebHCat , which will be used to trigger hive requests using Map-Reduce Hadoop work.

I have installed Hadoop 2.4.1 and Hive 0.13.0 (latest stable versions).

The requests I send using the web interface:

POST: http://localhost:50111/templeton/v1/hive?user.name='hadoop'&statusdir='out'&execute='show tables'

      

And I got the answer as:

{
    "id": "job_local229830426_0001"
}

      

But in the webhcat-console-error.log I found that the output value of this job is 1, which means that some error has occurred. While tracking this error, I found it Missing argument for option: hiveconf

This is webhcat-site.xml , which contains webhcat configurations (formerly known as Templeton):

<configuration>
  <property>
      <name>templeton.port</name>
      <value>50111</value>
      <description>The HTTP port for the main server.</description>
  </property>
  <property>
    <name>templeton.hive.path</name>
    <value>/usr/local/hive/bin/hive</value>
    <description>The path to the Hive executable.</description>
 </property>
  <property>
    <name>templeton.hive.properties</name>
    <value>hive.metastore.local=false,hive.metastore.uris=thrift://localhost:9933,hive.metastore.sasl.enabled=false</value>
    <description>Properties to set when running hive.</description>
  </property>
</configuration>

      

But the executed cmd request is weird as it contains some additional hiveconf parameters with no values:

tool.TrivialExecService: Starting cmd: [/usr/local/hive/bin/hive, --service, cli, --hiveconf, --hiveconf, --hiveconf, hive.metastore.local=false, --hiveconf, hive.metastore.uris=thrift://localhost:9933, --hiveconf, hive.metastore.sasl.enabled=false, -e, show tables]

      

Any idea?

+3


source to share





All Articles