CREATE TABLE IF NOT EXISTS u1.t1
( MONTH_ID STRING, -- 月份
NAME STRING, -- 姓名
SALARY DOUBLE, -- 薪资
) PARTITIONED BY(PART_ID DOUBLE, DAY_ID STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'field.delim'='\t',
'escape.delim'='\\',
'serialization.null.format'='') STORED AS TEXTFILE;
( MONTH_ID STRING, -- 月份
NAME STRING, -- 姓名
SALARY DOUBLE, -- 薪资
) PARTITIONED BY(PART_ID DOUBLE, DAY_ID STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'field.delim'='\t',
'escape.delim'='\\',
'serialization.null.format'='') STORED AS TEXTFILE;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28520410/viewspace-1331037/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28520410/viewspace-1331037/