hive完整建表语句

这个正确

CREATE EXTERNAL TABLE IF NOT EXISTS `test`.`test_create`(
    id int COMMENT 'id',
    name string COMMENT '姓名'
)COMMENT '测试创建'
PARTITIONED BY (`rq` date COMMENT '分区字段')
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';

下面这个不正确

CREATE EXTERNAL TABLE IF NOT EXISTS `test`.`test_create1`(
    id int COMMENT 'id',
    name string COMMENT '姓名'
)
PARTITIONED BY (`rq` date COMMENT '分区字段')
COMMENT '测试创建1'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';