37.3. HQL

37.3.1. namespace 命名空间管理

			
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
  			
			

37.3.2. Table 表

创建表

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 系列 手札
本文作者：陈景峯
转载请与作者联系，同时请务必标明文章原始出处和作者信息及本声明。