建表:
USE DBname;
CREATE TABLE Tablename(
field1 INT COMMENT ‘字段描述’,
field2 STRING COMMENT ‘字段描述’,
field3 INT COMMENT ‘字段描述’,
field4 STRING COMMENT ‘字段描述’,
field5 INT COMMENT ‘字段描述’,
field6 STRING COMMENT ‘字段描述’)
COMMENT ‘表描述’
STORED AS ORC;
删表:
use DBname;
DROP TABLE Tablename;