天天看点

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');
           

即可成功运行

继续阅读