首先建立一个外部表,放在hdfs的根目录下
create external table stu_external(
id int,
name string)
row format delimited fields terminated by '\t'
location '/student';
向表中插入数据:
load data local in
首先建立一个外部表,放在hdfs的根目录下
create external table stu_external(
id int,
name string)
row format delimited fields terminated by '\t'
location '/student';
向表中插入数据:
load data local in