Hive 的启动方式:1、hive 命令行模式,直接输入/hive/bin/hive的执行程序,或者输入 hive - -service cli
2、hive web界面的启动方式,hive - -service hwi
3、hive 远程服务 (端口号10000) 启动方式,nohup hive - -service hiveserver &
创建表cite,并指定列的分隔符为“,”:create table cite(citing INT, cited INT) row format delimited fields terminated by ‘,’;
创建表page_view,并指定分区字段为dt,同时把列的分隔符设置为“,”:
create table page_view (pid INT, url string) partitioned by (dt string) row format delimited fields terminated by ‘,’;
创建表S_USER_ERROR,并指定分区字段为YEAR、MONTH和DAY,同时把列的分隔符设置为“,”,最后指定表的存储路径为/data/stg/s_user_error/:CREATE TABLE S_USER_ERROR
(
bar INT,
foo string
)
PARTITIONED BY (YEAR STRING,MONTH STRING,DAY STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ STORED AS TEXTFILE LOCATION ‘/data/stg/s_user_error/’;
注意:如果不是外表部,drop table的时候