The query plan shows no Move operator, which should be responsible for loading data to table location. hive> explain > create table t3 as > select > key, value > from ( > SELECT MAP('A', '1', 'B', '2') as event > UNION ALL > SELECT MAP('A', '3', 'B', '4') as event > ) s > LATERAL VIEW EXPLODE( s.event ) t AS key, value; OK Plan not optimized by CBO. Vertex dependency in root stage Map 1 <- Union 2 (CONTAINS) Map 3 <- Union 2 (CONTAINS) Stage-3 Create Table Operator: name:default.t3 Stage-1 Union 2 <-Map 1 [CONTAINS] File Output Operator [FS_12] table:{"name:":"default.t3"} Select Operator [SEL_11] (rows=4 width=8) Output:["_col0","_col1"] Lateral View Join Operator [LVJ_10] (rows=4 width=810) Output:["_col1","_col2"] Select Operator [SEL_7] (rows=2 width=1080) Lateral View Forward [LVF_6] (rows=2 width=540) Select Operator [SEL_1] (rows=1 width=540) Output:["_col0"] TableScan [TS_0] (rows=1 width=1) File Output Operator [FS_12] table:{"name:":"default.t3"} Select Operator [SEL_11] (rows=4 width=8) Output:["_col0","_col1"] Lateral View Join Operator [LVJ_10] (rows=4 width=810) Output:["_col1","_col2"] UDTF Operator [UDTF_9] (rows=2 width=540) function name:explode Select Operator [SEL_8] (rows=2 width=540) Output:["_col0"] Please refer to the previous Lateral View Forward [LVF_6] <-Map 3 [CONTAINS] File Output Operator [FS_12] table:{"name:":"default.t3"} Select Operator [SEL_11] (rows=4 width=8) Output:["_col0","_col1"] Lateral View Join Operator [LVJ_10] (rows=4 width=810) Output:["_col1","_col2"] Select Operator [SEL_7] (rows=2 width=1080) Lateral View Forward [LVF_6] (rows=2 width=540) Select Operator [SEL_3] (rows=1 width=540) Output:["_col0"] TableScan [TS_2] (rows=1 width=1) File Output Operator [FS_12] table:{"name:":"default.t3"} Select Operator [SEL_11] (rows=4 width=8) Output:["_col0","_col1"] Lateral View Join Operator [LVJ_10] (rows=4 width=810) Output:["_col1","_col2"] UDTF Operator [UDTF_9] (rows=2 width=540) function name:explode Select Operator [SEL_8] (rows=2 width=540) Output:["_col0"] Please refer to the previous Lateral View Forward [LVF_6] ... View more