Hive

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；