HIVE建内部表语句
create table dll102.sougou
(id string,pwd string,name string,count int,seqno int,address string)
row format delimited fields terminated by '\t' ;
创建字段中含有数组类型,对象类型的表,并查询特殊字段
外部表默认 存在HDFS下的 ‘/user/hadoop/指定路径’
将本地文件加载到HIVE
load data local inpath '/home/hadoop/sgtest' into table sougou;
查看表结构
desc formatted emp;[table_name];
常用SQL语句
// 创建内部表 student
create table student(id int, name string, sex string, age int, department string)
row format delimited fields terminated by ',' //行分隔符用 lines
stored as textfile;
// 从本地导入数据
load data local inpath '/home/hadoop/student.txt' into table student;
// 查询数据
select id, name, sex, age, department from student;
// 创建一个external表
create external table ext_student(id int, name string, sex string, age int, department string)
row format delimited fields terminated by ','
location '/ext_student';
// 导入数据
hadoop fs -put student.txt /ext_student;
load data local inpath '/home/hadoop/mingxing.txt' into table ext_student;
// 查询数据
select id, name ,sex, age , department from ext_student;
// 创建内部表引用外部路径
create table mng_student(i