我尝试使用regexp\u extract()将数据插入到表中,代码如下
insert overwrite table flightsdb.flight_delays_hw3
select
regexp_extract(col_value,',^(?:([^,]*)\,?{2}',1)t1,
regexp_extract(col_value,',^(?:([^,]*)\,?{5}',1)t2,
regexp_extract(col_value,',^(?:([^,]*)\,?{19}',1)t3,
regexp_extract(col_value,',^(?:([^,]*)\,?{20}',1)t4,
regexp_extract(col_value,',^(?:([^,]*)\,?{21}',1)t5,
regexp_extract(col_value,',^(?:([^,]*)\,?{22}',1)t6,
regexp_extract(col_value,',^(?:([^,]*)\,?{23}',1)t7
from temp_table1;
但我一直得到以下错误:
Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:3,
Vertex vertex_1586463911838_0026_1_00 [Map 1] killed/failed to:OWN_TASK_FAILURE]DAG
did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0
我该怎么修?
暂无答案!
目前还没有任何答案,快来回答吧!