HQL Statement Syntax

The Hypertable Query Language (HQL) allows you to create, modify, and query tables and invoke adminstrative commands. HQL is interpreted by the following interfaces:

• The hypertable command line interface (CLI)
• The HqlService.hql_exec() Thrift API method
• The Hypertable::HqlInterpreter C++ class

ALTER TABLE - Add and remove columns from a table

CREATE TABLE - Create a table

DELETE - Delete a row or columns from a specific row of a table

DESCRIBE TABLE - Show the table schema

DROP TABLE - Remove a table

INSERT - Insert data into a table

LOAD DATA INFILE - Bulk insert data into a table

SELECT - Query a table

SHOW CREATE TABLE - Show the CREATE TABLE command used to create a table

SHOW TABLES - Display all existing table names

SHUTDOWN - Gracefully shutdown the Hypertable service