-- 1、创建新表
use db1;
create table db1.test_02_20210223(
name string,
age integer)
row format delimited
fields terminated by '\t'
lines terminated by '\n'
stored as textfile
-- 2、load数据
load data local INPATH '/soft/data/data1.txt' INTO TABLE db1.test_02_20210223 ;
-- 3、 查看加载结果
select * from db1.test_02_20210223