hive 增加表字段语录_HIVE常用SQL语句及语法

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