show databases;
show tables;
use zzz；//使用一个database；
create table wyp
(id int, name string,
age int, tel string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘\t‘
STORED AS TEXTFILE;
load data local inpath ‘wyp.txt‘ into table wyp;//数据直接rz即可
load data inpath ‘/user/root/wyp.txt‘ into table wyp;//文件在hdfs中
select * from wyp；
原文：http://www.cnblogs.com/sifaqingyun/p/4687189.html