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');
即可成功運作