hadoop hql

Xshell

hive£» 
use u_lx_data;
show databases;
show tables;
CREATE DATABASE fianancials;
CREATE DATABASE IF NOT EXISTS financials;
-/user/hive/warehouse/financials.db
SHOW DATABASES;
SHOW DATABASES LIKE 'h.*';

CREATE DATABASE financials
LOCATION '/my/preferred/directory';

CREATE DATABASE financials
COMMENT 'Holds all financial tables';

DESCRIBE DATABASE financials;
USE financials;
DROP DATABASE IF EXISTS financial CASCADE;
CREATE TABLE IF NOT EXISTS mydb.employees
(
name STRING COMMENT 'Employmee name',
salary FLOAT COMMENT 'Employee salary',
subordinates ARRAY<STRING> COMMENT 'Names of subordinates',
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'