天天看點

hive:TOK_FUNCTION not supported in insert/values問題解決

hive在插入資料時報錯:

hive> insert into temp.test_hive_data_type1 partition(ymd='2018-12-03') values("wanwei",18,100.00,0.225,true,158030219111,array("beijing","shanghai","tianjin","hangzhou"),str_to_map('數學:80','國文:89','英語:95'));
FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values
           

改為:

insert into temp.test_hive_data_type1 partition(ymd='2018-12-03') select "wanwei",18,100.00,0.225,true,158030219111,array("beijing","shanghai","tianjin","hangzhou"),str_to_map('數學:80','國文:89','英語:95');
           

即可成功運作

繼續閱讀