37.3. HQL
hypertable> create namespace test; Elapsed time: 0.22 s hypertable> use test; Elapsed time: 0.00 s hypertable> drop namespace test; Elapsed time: 1.55 s
创建表
CREATE TABLE logging ( uuid, tag, asctime, facility, priority, message, operator )
hypertable> CREATE TABLE logging (
-> uuid,
-> tag,
-> asctime,
-> facility,
-> priority,
-> message,
-> operator
-> );
Elapsed time: 2.14 s
列出所有表
hypertable> show tables; logging Elapsed time: 0.00 s hypertable>
显示创建该表的HQL
hypertable> show create table logging; CREATE TABLE logging ( uuid, tag, asctime, facility, priority, message, operator, ACCESS GROUP default (uuid, tag, asctime, facility, priority, message, operator) ) Elapsed time: 0.00 s hypertable>
删除表
hypertable> drop table logging; Elapsed time: 1.33 s
原文出处：Netkiller 系列 手札
本文作者：陈景峯
转载请与作者联系，同时请务必标明文章原始出处和作者信息及本声明。