正常Insert 及部分列更新错误 测试 selectdb-doris-2.1.4 正常

Viewed 79

版本:selectdb-doris-2.1.5
1、内表操作:insert into xxxx select xx,xxx,xxxx from xxx
报错 SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Variant sub-column access is disabled in original planner,set enable_variant_access_in_original_planner = true in session variable。
执行

set enable_variant_access_in_original_planner = true;

1722825290.png
image.png
还是会报相同的错;
2、部分列更新不成功
语句:

set enable_unique_key_partial_update = true;
INSERT INTO DIM.DIM_EMPLOYEE_MASTER_DATA (HRIS_JOBNUMBER,HRIS_EMPLOYEESTATUS)
SELECT
CAST(JOBNUMBER AS varchar(108)) AS HRIS_JOBNUMBER,
CAST(EMPLOYEESTATUS AS VARCHAR(80)) AS HRIS_EMPLOYEESTATUS
from 
DIM.DIM_HRIS_EMPLOYEEINFO
WHERE EMPLOYEESTATUS = '1';
1 Answers