二、hive客户端命令

一、数据库

1.1、查看数据库

show databases;

1.2、创建数据库

create database if not exists myhive;

//使用数据库
use myhive;

1.3、删除数据库

drop database myhive;

二、表

2.1、查看表

show tables;

2.2、创建表

CREATE TABLE IF NOT EXISTS employee ( eid int, name String,
salary String, destination String)
COMMENT 'Employee details'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

2.3、删除表

drop table employee;

2.4、批量导入数据

LOAD DATA LOCAL INPATH '/home/hive/data/employees.txt'  OVERWRITE INTO TABLE employee;