编写简单的hql命令_HQL操作日常使用命令总结

建表

create table mydb.userinfo(name string,addressi string)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY '\t'

LINES TERMINATED BY '\n'

STORED AS TEXTFILE;

创建分区表

CREATE TABLE mydb.userinfo --创建表

(col1 string, col2 date, col3 double),

partitioned by (datekey date), --可以多个字段的组合分区

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ','

Stored AS TEXTFILE;

数据导入到表mydb.userinfo中

load data local inpath "/home/dahaizi/data/userinfo.txt"

overwrite into table mydb.userinfo;

向表中插入数据

insert into table(col1,col2,col3) values('a','b','c')

将查询的数据插入到已有的表中

INSERT INTO TABLE table_Name

PARTITION (DateKey),

SELECT col1,col2,col3,DateKey FROM otherTable

WHERE DATEKEY IN ('2017-02-26','2013-06-12','2013-09-24'),</