Page History

...

DISCLAIMER: 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.

...

Error logs are very useful to debug problems. Please send them with any bugs (of which there are many!) to hive-dev@hadoop.apache.org.

DDL Operations

The Hive DDL operations are documented in Hive Data Definition Language.

Creating Hive Tables

  hive> CREATE TABLE pokes (foo INT, bar STRING);

...

If you want to run the metastore as a network server so it can be accessed from multiple nodes, see Hive Using Derby in Server Mode.

DML Operations

The Hive DML operations are documented in Hive Data Manipulation Language.

Loading data from flat files into Hive:

...

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

The Hive query operations are documented in Select.

Example Queries

Some example queries are shown below. They are available in build/dist/examples/queries.
More are available in the hive sources at ql/src/test/queries/positive.

...