(一)创建表
create table if not exists mydb.employees(
name string comment “employee name”,
salary folat comment “employee salary”,
subordiantes array<string> comment”names of subordiantes”,
deductions map<string,float> comment “keys are deductions name,values are percentages”,
address struct<street:string,city:string,state:string,zip:int> comment “home address”)
comment “description of the table”
tblproperties(“creator”=”me”,”created_at”=”2012-01-02″)
location “/user/hive/warehouse/mydb.db/employees”;
（二）拷贝表
create table if not exists mydb.employee2 like mydb.employees;
(三)
show tables in mydb;
show tables “empl.*”
describe extended mydb.employees
)
