June 2018
Beginner to intermediate
210 pages
5h 12m
English
The following are major DDLs for the internal and external table creation:
$ vi /home/hadoop/employee.txt Michael|Montreal,Toronto|Male,30|DB:80|Product:Developer^DLead Will|Montreal|Male,35|Perl:85|Product:Lead,Test:Lead Shelley|New York|Female,27|Python:80|Test:Lead,COE:Architect Lucy|Vancouver|Female,57|Sales:89,HR:94|Sales:Lead
> CREATE TABLE IF NOT EXISTS employee_internal ( > name STRING COMMENT 'this is optinal column comments', > work_place ARRAY<STRING>,-- table column names are NOT case sensitive > gender_age STRUCT<gender:STRING,age:INT>, > skills_score MAP<STRING,INT>, -- columns names are lower case > depart_title MAP<STRING,ARRAY<STRING>> ...