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;

浙公网安备 33010602011771号