hive> create table scores(id int, score int)
> row format delimited
> fields terminated by ','
> stored as textfile; //指定Hive文件存储格式
有两种导入方式,一种从HDFS文件系统中导入
hive> load data inpath '/score.text' overwrite into table scores;
一种从linux本地导入
hive> load data local inpath '/home/bruce/study/perl/score.text' overwrite into table scores;