Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by ZhengShao: http://wiki.apache.org/hadoop/Hive/GettingStarted ------------------------------------------------------------------------------ we are working hard to make Hive a production quality system. Hive has only been tested on unix(linux) and mac systems using Java 1.6 for now - although it may very well work on other similar platforms. It does not work on Cygwin right now. Most of our testing has - been on Hadoop 0.17 - so we would advise running it against this version of hadoop - even + been on Hadoop 0.17.2 - so we would advise running it against this version of hadoop - even though it may compile/work against other versions == Hive introduction videos From Cloudera == @@ -16, +16 @@ [http://www.cloudera.com/hadoop-training-hive-tutorial Hive Tutorial Video] + == Preparations == + - == Requirements == + === Requirements === - * Java 1.6 + * Hadoop 0.17.x to 0.19.x. Support of Hadoop 0.20.x is in progress: [[https://issues.apache.org/jira/browse/HIVE-487 HIVE-487]] - == Downloading and building == + === Downloading and building === Hive is available via SVN at: http://svn.apache.org/repos/asf/hadoop/hive/trunk @@ -29, +31 @@ $ cd hive $ ant -Dhadoop.version="<your-hadoop-version>" package # For example - $ ant -Dhadoop.version="0.17.2.1" package + $ ant -Dhadoop.version="0.17.2" package $ cd build/dist $ ls README.txt @@ -39, +41 @@ examples/ (sample input and query files) }}} - In the rest of the page, we use build/dist and <install-dir> interchangeably. - [wiki:/EclipseSetup Instructions] to setup eclipse for hive development. - - == Running Hive == + === Running Hive === Hive uses hadoop that means: * you must have hadoop in your path OR @@ -72, +71 @@ $ $HIVE_HOME/bin/hive }}} - == Using Hive == === Configuration management overview === - hive default configuration is stored in <install-dir>/conf/hive-default.xml @@ -209, +207 @@ The two LOAD statements above load data into two different partitions of the table invites. Table invites must be created as partitioned by the key ds for this to succeed. + + {{{ + hive> LOAD DATA INPATH '/user/myname/kv2.txt' OVERWRITE INTO TABLE invites PARTITION (ds='2008-08-15'); + }}} + + The above command will load data from an HDFS file/directory to the table. + Note that loading data from HDFS will result in moving the file/directory. As a result, the operation is almost instantaneous. == SQL Operations == === Runtime configuration ===
