| CREATE TABLE employees ( | |
| name STRING, | |
| salary FLOAT, | |
| subordinates ARRAY<STRING>, | |
| deductions MAP<STRING, FLOAT>, | |
| address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT>); | |
| LOAD DATA LOCAL INPATH '../../data/files/posexplode_data.txt' INTO TABLE employees; | |
| SELECT | |
| name, pos, sub | |
| FROM | |
| employees | |
| LATERAL VIEW | |
| posexplode(subordinates) subView AS pos, sub; |