Cloudera Manager Free Edition [4.0.1] Service problem

for example, I want install *Hive, but I don't know how.*


在 2012年8月8日星期三UTC+8下午1时51分17秒，杨荣权写道：

Hive (in the simplest form) is a client side program.

You can try "yum install hive". You'll have to setup the metastore. But
otherwise, there is no "Hive service" for CM to manage, if you just want to
use Hive. Do deploy the client config, so the `hive' program knows about
your Hadoop cluster.

Cheers,
bc

I use Debian 6.

this is my step:
1. hive install package
because the hive component is install from CM, and I can find run *hive *in
shell.
so pass this step

2. create mysql database to store metastore

3. create a hive-site.xml
<property>
   <name>hive.exec.scratchdir</name>
   <value>/home/yangrq/hadoop/tmp/hive-${user.name}</value>
   <description>Scratch space for Hive jobs</description>
</property>

<property>
   <name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://192.168.0.100:3306/test_hivedb?createDatabaseIfNotExist=true</value>
   <description>JDBC connect string for a JDBC metastore</description>
</property>

<property>
   <name>javax.jdo.option.ConnectionDriverName</name>
   <value>com.mysql.jdbc.Driver</value>
   <description>Driver class name for a JDBC metastore</description>
</property>

<property>
   <name>javax.jdo.option.ConnectionUserName</name>
   <value>hiveuser</value>
   <description>username to use against metastore database</description>
</property>

<property>
   <name>javax.jdo.option.ConnectionPassword</name>
   <value>hiveuser</value>
   <description>password to use against metastore database</description>
</property>

4. cp hive-site.xml to /etc/hive/conf/hive-site.xml

5. get JAVA mysql connector: mysql-connector-java-5.1.12.jar from mysql.com

6. cp mysql-connector-java-5.1.12.jar to /usr/lib/hive/lib

I can use hive now.

*My Question:*
from the upper step, it is some complicated.
Is there any simple solution?
*How about this solution (does not need sudo privilege):*
   1. download a hive tarball with the same version from apache.org
   2. untar the package
   3. copy the hive-site.xml and mysql-connector-java-5.1.12.jar into it.


在 2012年8月8日星期三UTC+8下午2时10分15秒，bc Wong写道：

Not really. (At least not yet.)

That'll also give you hive. But looks like the same amount of work. Your
step 3 is the same as the original 3, 4, 5, 6. (That it's written in one
sentence doesn't mean it's faster.)

Cheers,
bc