hive中创建表命令

情况1:设置分区：

DROP TABLE IF EXISTS adm_investor_activity;
CREATE TABLE IF NOT EXISTS adm_investor_activity(
    	investor_id		bigint	comment	'投资人id'
    ,	score			double  comment '投资人活跃度评分'
)
comment 'adm投资人活跃度表'
partitioned by (ds string comment '时间分区')
stored as parquet;

情况2:不设置分区：

drop table if exists student_info;


create table if not exists student_info (
    id bigint comment 'ID',
    name string comment '姓名',
    age bigint comment '年龄',
    weight bigint comment '体重(kg)'
) comment '学生基本信息' row format delimited fields terminated by ',' lines terminated by '\n' stored as textfile;

情况三：创建临时表

create temporary view tv_invest_history as
select
*
from
	dwd_rsc_invest_history_dd
where
	ds = ‘条件’; 

hive表中load数据命令

load data local inpath '地址' overwrite into table demo_dim_address_city;