Hive中Database、Table的创建与查询

说明：本文示例中给出的是完整的建库和建表语句，实际中可以不包含全部的关键字。

数据库的创建与查询：

CREATE DATABASE IF NOT EXISTS financials
COMMENT 'Holds all financial tables'
LOCATION '/usr/hive/warehouse/financials.db'
WITH DBPROPERTIES ('creator' = 'Wu Huating', 'date' = '2018-06-05')
//把LOCATION放在末尾会出错

DESCRIBE DATABASE EXTENDED financials;

表的创建与查询：

CREATE TABLE IF NOT EXISTS employee(
name STRING COMMENT 'Employee name',
salary FLOAT COMMENT 'Employee salary',
subordinates ARRAY<STRING> COMMENT 'Names of subordinates',
deductions MAP<STRING, FLOAT> COMMENT 'keys are deductions names, values are percentages',
address  STRUCT<street:STRING, city:STRING, state:STRING, zip:INT> COMMENT 'Home address' )
COMMENT 'Description of the table'
LOCATION '/user/hive/warehouse/employee'
TBLPROPERTIES ('creator'= 'Wu Huating', 'created_at'='2018-06-05')
//把LOCATION放在末尾会出错

DESCRIBE EXTENDED employee;

DESCRIBE FORMATTED employee;