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