Getting started in 5min

The easiest and recommended way to install Hypertable for Windows is to use the pre-built installers, either the x86 or the x64 package. Download and run the appropriate installer, which installs the required components and starts a Hypertable instance as a Windows service.

Navigate to the Hypertable installation folder %ProgramFiles%\Hypertable (or %ProgramFiles(x86)%\Hypertable if the x86 version has been installed on a 64-bit Windows) using Windows Explorer or a command shell.

Now, start the Hypertable shell, either by double-clicking Hypertable.exe in Windows Explorer, or from the command shell prompt. The shell connects to the running Hypertable instance and offers a Hypertable Query Language (HQL) prompt.

First, create a new namespace called “Test”:

CREATE NAMESPACE Test;

and make it the current namespace:

USE Test;

 

Now, let’s create a new table within the current namespace:

CREATE TABLE fruits (color, energy, protein, vitamins);

and insert some data:

INSERT INTO fruits VALUES ("apple", "color", "red"),
("apple", "energy", "207KJ"),
("apple", "protein", "0.4g"),
("apple", "vitamins:C", "15mg"),
("apple", "vitamins:B1", "0.02mg");

INSERT INTO fruits VALUES ("banana", "color", "yellow"),
("banana", "energy", "375KJ"),
("banana", "protein", "1.2g"),
("banana", "vitamins:C", "10mg"),
("banana", "vitamins:B1", "0.04mg");

 

Finally, issue some queries, for example:

SELECT CELLS * FROM fruits;
SELECT CELLS * FROM fruits WHERE ROW=”banana”;
SELECT CELLS vitamins FROM fruits WHERE ROW=”apple”;
SELECT CELLS vitamins:B1 FROM fruits;