2018-09-19 LATERAL VIEW explode Hive もとのテーブルで配列とかJSONをexplodeしてレコードに分解するやつ SELECT myCol1, col2 FROM baseTable LATERAL VIEW explode(col1) myTable1 AS myCol1; https://cwiki.apache.org/confluence/display/Hive/LanguageManual+LateralViewhttps://cwiki.apache.org/confluence/display/Hive/LanguageManual+LateralView