向hive测试库插入数据时,报错
FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values
情景再现:
hive> insert into tmp.test_lateral_view_movie_230828 values ('《疑犯追踪》',array('悬疑,动作,科幻,剧情'));
FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values
hive> insert into edw_tmp.test_lateral_view_movie_230828 values ('《战狼》',array('战争,动作,剧情'));
FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values
hive>
解决:
1.将insert 修改为 select
2.去掉values后面的括号
insert into tmp.test_lateral_view_movie_230828 select '《疑犯追踪2》',array('悬疑,动作,科幻,剧情');
insert into tmp.test_lateral_view_movie_230828 select '《战狼》',array('战争,动作,剧情');
--end--