hadoop-0.20.1+120 hive-0.3.99.1+0 trial HWI (Hive Web interface

Hive delay to support the situation of Hadoop 0.20 solution, a small try.

Less gossip, thanks to the efforts of the Cloudera team, Hive was able to support Hadoop 0.20.1 at number No. 9.21 yesterday, downloading the beta software.

http://archive.cloudera.com/cdh/testing/

Http://archive.cloudera.com/cdh/testing/hadoop-0.20.1+120.tar.gz

Http://archive.cloudera.com/cdh/testing/hive-0.3.99.1+0.tar.gz

Very simple decompression, configuration conf can be used, Hadoop configuration see the previous article.

Hive in the use of export hadoop_home=/home/hadoop/hadoop-0.20.1+120, instead of the readme inside the export HADOOP, blindly follow the readme, will not experience the powerful function of hive, Because hive command after no output, hehe.

Set up a few test tables to use.

Bin/hive
Hive History File=/tmp/hadoop/hive_job_log_hadoop_200909190325_1929716196.txt
Hive> Show tables;
OK
msn
Pokes
Time taken:5.217 seconds
Hive> Select a.* from pokes a limit 3;
OK
Time taken:1.489 seconds
hive> LOAD DATA local inpath './examples/files/kv1.txt ' OVERWRITE into TABLE pokes;
Copying data from File:/home/hadoop/hive-0.3.99.1+0/examples/files/kv1.txt
Loading Data to table pokes
OK
Time taken:0.378 seconds
Hive> Select a.* from pokes a limit 3;
OK
238 val_238 NULL
Val_86 NULL
311 val_311 NULL
Time taken:0.078 seconds

。

These basic articles are introduced before, not much space, the following key experience of Hive

Hivewebinterface, which is how hwi is used, seems to be a trend for web interface,

As long as the client has a browser can easily operate and manage hive.

HWI needs Apache ant support.

Http://labs.xiaonei.com/apache-mirror/ant/binaries/apache-ant-1.7.1-bin.tar.gz

Decompression can be.

export ant_lib=/home/hadoop/apache-ant-1.7.1/libbin/hive--service hwi09/09/19 03:32:03 INFO hwi. Hwiserver:hwi is starting UP09/09/19 03:32:03 INFO mortbay.log:Logging to Org.slf4j.impl.Log4jLoggerAdapter ( Org.mortbay.log via ORG.MORTBAY.LOG.SLF4JLOG09/09/19 03:32:03 info MORTBAY.LOG:JETTY-6.1.1409/09/19 03:32:03 Info Mortbay.log:Extract jar:file:/home/hadoop/hive-0.3.99.1+0/lib/hive_hwi.war!/To/tmp/jetty_0_0_0_0_9999_hive_ HWI.WAR__HWI__BW65N0/WEBAPP09/09/19 03:32:03 INFO mortbay.log:Started socketconnector@0.0.0.0:9999

The HWI service started successfully, and it was seen as a war package.

The configuration file is/home/hadoop/hive-0.3.99.1+0/conf/hive-default.xml, replacing the default hive_home with the absolute path of the real installation, or the error occurs when the HWI service is started. If other students find solutions, please do not hesitate to share experience.

<property>

<name>hive.hwi.war.file</name>

<value>/home/hadoop/hive-0.3.99.1+0/lib/hive_hwi.war</value>

<description>this is the "WAR file with" The JSP content for Hive Web interface</description>

</property>

Hwi use of a sudden close the ordinary user and Hadoop hive distance, the use is very convenient, do not know the use of it.