说明:本文示例中给出的是完整的建库和建表语句,实际中可以不包含全部的关键字。
数据库的创建与查询:
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;