只读外部表创建语法

CREATE  load read  EXTERNAL table t001 (
name1 varchar(100),
name2 varchar(100),
name3 varchar(100),
name4 varchar(100),
name5 varchar(100),
name6 varchar(100),
name7 varchar(100),
name8 varchar(100),
name9 varchar(100),
name10 varchar(100),
name11 varchar(100),
name12 varchar(100),
name13 varchar(100),
name14 varchar(100),
name15 varchar(100),
name16 varchar(100),
name17 varchar(100),
name18 varchar(100),
name19 varchar(100),
name20 varchar(100),
riqi varchar(30),
fileid int) -- distributed by ('name1')
LOCATION  'hdp://hdfs@gbase234:8020//user/hive/warehouse/test.db/orc_partitioned_table/*/*' informat data_format 8 
fields terminated by ',' table_fields 'name1,name2,name3,name4,name5,name6,name7,name8,name9,name10,name11,name12,name13,name14,name15,name16,name17,name18,name19,name20' outformat fields terminated by ',' ;