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