Hive创建表语法

-- 创建内部表
create table user1(
id int comment '用户id',
username varchar(20) comment '账户名称',
password varchar(255) comment '账户密码',
realname varchar(20) comment '真实姓名',
age int comment '年龄',
address varchar(255) comment '住址',
create_time string comment '创建日期'
)
row format delimited 
fields terminated by '\t'
lines terminated by '\n'
-- collection items terminated by '\001'
-- map keys terminated by '\002'
stored as avro
location '/hive/warehouse/testing.db/user1';

-- 创建外部表
-- 删除外部表对应hdfs源数据： hadoop fs -rm -r /hive/warehouse/testing.db/user1
create external  table user1(
id int comment '用户id',
username varchar(20) comment '账户名称',
password varchar(255) comment '账户密码',
realname varchar(20) comment '真实姓名',
age int comment '年龄',
address varchar(255) comment '住址',
create_time string comment '创建日期'
)
row format delimited 
fields terminated by '\t'
lines terminated by '\n'
-- collection items terminated by '\001'
-- map keys terminated by '\002'
stored as avro
location '/hive/warehouse/testing.db/user1';

-- 创建临时表
create temporary table user1(
id int comment '用户id',
username varchar(20) comment '账户名称',
password varchar(255) comment '账户密码',
realname varchar(20) comment '真实姓名',
age int comment '年龄',
address varchar(255) comment '住址',
create_time string comment '创建日期'
)
row format delimited 
fields terminated by '\t'
lines terminated by '\n'
-- collection items terminated by '\001'
-- map keys terminated by '\002'
stored as avro
location '/hive/warehouse/testing.db/user1';

set hive.cli.print.current.db=true;