[Author]: kwu
创建普通hive表
CREATE TABLEcrm_support_customer
(
ID INT ,
Name String ,
Contact1 String,
Contact2 String,
Contact3 String,
Contact4 String,
IDCard String,
Province INT,
City INT,
...
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
创建表储存格式为 rcfile
CREATE TABLE
crm_support_customer_rcfile
(
ID INT ,
Name String ,
Contact1 String,
Contact2 String,
Contact3 String,
Contact4 String,
IDCard String,
Province INT,
City INT,
...
)stored