版本: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;
还是会报相同的错;
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';