hive根据已有表创建新表_Hive中新建表

最基本的建表语句：

create table student(

id string comment '学号',

name string comment '姓名',

sex string comment '性别',

age string comment '年龄'

) comment '学生表';

show create table student;

CREATE TABLE `student`(

`id` string COMMENT '学号',

`name` string COMMENT '姓名',

`sex` string COMMENT '性别',

`age` string COMMENT '年龄')

COMMENT '学生表'

ROW FORMAT SERDE

'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'

STORED AS INPUTFORMAT

'org.apache.hadoop.mapred.TextInputFormat'

OUTPUTFORMAT

'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'

LOCATION

'hdfs://mycluster/user/hive/warehouse/gld.db/student'

TBLPROPERTIES (