hive 建数据表

感觉HIVE好强大。可以支持分区。


CREATE TABLE `Incoming_Log` (
`SessionID` STRING,
`VisitTime` INT,
)
PARTITIONED BY (ds STRING) //分区
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;


载入数据：
LOAD DATA LOCAL INPATH '/www/dump/test/2010-06-28/00/web101/incoming.dat' OVERWRITE INTO TABLE Incoming_Log PARTITION (ds='2010-06-28 00');
LOAD DATA LOCAL INPATH '/www/dump/test/2010-06-28/00/web101/incoming.dat' OVERWRITE INTO TABLE Incoming_Log PARTITION (ds='2010-06-28 00');