Home | 簡體中文 | 繁體中文 | 雜文 | 打賞(Donations) | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 知乎專欄 | Search | Email

4.3. HQL

4.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
  			
			

4.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