Hypertable-HQL Reference
HQL REFERENCE
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 (ht shell) The hql_exec* and hql_query* Thrift API methods The Hypertable::HqlInterpreter C++ class
TABLE OF CONTENTS ALTER TABLE EBNF ALTER TABLE name alter_mode '('[alter_definition] ')'[alter_mode '(' alter_definition ')' ...] alter_mode: ADD| DROP| RENAME COLUMN FAMILY alter_definition: add_cf_definition| drop_cf_definition| rename_cf_definition add_cf_definition: column_family_name[MAX_VERSIONS '=' int][TTL '=' duration]| ACCESS GROUP name[access_group_option ...]['('[column_family_name, ...] ')'] drop_cf_definition: rename_cf_definition: duration: num MONTHS| num WEEKS| num DAYS| num HOURS| num MINUTES| num[ SECONDS] access_group_option: IN_MEMORY| BLOCKSIZE '=' int| REPLICATION '=' int| COMPRESSOR '=' compressor_spec| BLOOMFILTER '=' bloom_filter_spec compressor_spec: column_family_name (old)column_family_name, (new)column_family_name
