数据库(database)操作
create database if not exists myhivebook;
use myhivebook;
show databases;
describe database default;
alter database myhivebook set owner user dayongd;
drop database if exists myhivebook cascade;
表(table)操作
-- 创建一个内部表
create table if not exists student(
id int, name string
)
row format delimited fields terminated by '\t'
stored as textfile
location '/hdfs上的数据文件路径';
-- 查询表的类型
desc formatted student;
Hive建表语句解析
CREATE EXTERNAL TABLE IF NOT EXISTS employee_external ( --IF NOT EXISTS可选,如果表存在,则忽略
--列出所有列和数据类型
name string,
work_place ARRAY<string>,
sex_age STRUCT<sex:string,age:int>,
skills_score MAP<string,int>,
depart_title MAP<STRING,ARRAY<STRING>>
)
COMMENT 'This is an external table' --COMMENT可选
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|' --如何分隔列(字段)
COLLECTION ITEMS TERMINATED BY ',' --如何分隔集合和映射
MAP KEYS TERMINATED BY ':'
STORED AS TEXTFILE --文件存储格式
LOCATION '/home/hadoop/hive/warehouse/employee'