SQL 报错 Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values

原SQL:
INSERT OVERWRITE TABLE dm_homed.dushilong_ultraman PARTITION (date = '${date}') VALUES (1001, 'Tiga', ARRAY('DaiGo'), 'Spark_prism', ARRAY('zepilo', 'delersum', 'teleport'), 8, 'earth')

修改后:
INSERT INTO dm_homed.dushilong_ultraman partition(date = '20210713') SELECT 1001, 'Tiga', ARRAY('DaiGo'), 'Spark_prism', ARRAY('zepilo', 'delersum', 'teleport'), 8, 'earth' from (select 'a') x;

posted @ 2021-07-15 10:48  DeusJin  阅读(920)  评论(0)    收藏  举报