我运行下面的代码并得到意外错误 “ TypeError:未找到与指定签名匹配的循环,并且未找到用于ufunc add的强制转换” 哪个X和Y都是数据框
SELECT P.PERSONID,P.LOCATION,P.STATUS,P.FIRSTNAME,P.LASTNAME,MAX(CASE
WHEN (UPPER(L.CRAFT) = 'CONNECT') THEN
'Yes'
ELSE
NULL
END ) AS Connection,MAX(CASE
WHEN (UPPER(L.CRAFT) = 'REPLACE') THEN
'Yes'
ELSE
NULL
END ) AS Replacement
FROM maximo.PERSON P
JOIN maximo.LABORCRAFTRATE L ON P.PERSONID = L.LABORCODE
WHERE ((P.PERSONID LIKE '%SP51894%'))
AND P.STATUS IN ('actIVE','INactIVE')
AND UPPER(L.CRAFT) IN ('CONNECT','REPLACE')
GROUP BY P.PERSONID,P.LASTNAME;
我该怎么办? 预先谢谢你