hive complex type

数据：
1,100|3,20|2,70|5,100

建表：
CREATE TABLE complex (
  col1 MAP<INT, INT>
)
ROW FORMAT DELIMITED
COLLECTION ITEMS TERMINATED BY '|'
MAP KEYS TERMINATED BY ','
STORED AS TEXTFILE;
;

LOAD DATA LOCAL INPATH '/home/tianzhao/book/complex.txt'
OVERWRITE INTO TABLE complex;

SELECT col1[1] FROM complex; 是 100
SELECT col1[3] FROM complex; 是20
SELECT col1[2] FROM complex; 是70
SELECT col1[5] FROM complex; 是100


SELECT col1 FROM complex; 出来的是
{1:100,3:20,2:70,5:100}




Hive自带的示例是：
ql/src/test/queries/clientpositive$ cat create_nested_type.q
DROP TABLE table1;

CREATE TABLE table1 (
       a STRING,
       b ARRAY<STRING>,
       c ARRAY<MAP<STRING,STRING>>,
       d MAP<STRING,ARRAY<STRING>>
       ) STORED AS TEXTFILE;
DESCRIBE table1;
DESCRIBE EXTENDED table1;

LOAD DATA LOCAL INPATH '../data/files/create_nested_type.txt' OVERWRITE INTO TABLE table1;

SELECT * from table1;

DROP TABLE table1;