하둡(hive)

hive> CREATE TABLE employee (
    >   name string,
    >   work_place ARRAY<string>,
    >   gender_age STRUCT<gender:string,age:int>,
    >   skills_score MAP<string,int>,
    >   depart_title MAP<STRING,ARRAY<STRING>>
    > )
    > ROW FORMAT DELIMITED
    > FIELDS TERMINATED BY '|'
    > COLLECTION ITEMS TERMINATED BY ','
    > MAP KEYS TERMINATED BY ':'
    > STORED AS TEXTFILE;

테이블 만들기 기준이 각각 다르다

LOAD DATA INPATH '/data/employee.txt' OVERWRITE INTO TABLE employee;

데이터 받아오기 해당 위치에 데이터를 받아오기

SELECT name, skills_score['DB'] AS DB, 
skills_score['Perl'] AS Perl, skills_score['Python'] AS Python, 
skills_score['Sales'] as Sales, skills_score['HR'] as HR FROM 
employee;

파이썬처럼 색인으로 받아오면 해당 값을 key로 가진 행의 value를 받고 그렇지 않은 값은 NULL로 받아옴