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
No one has answered this question yet
Check out similar questions: