我试图在impala中执行一个查询，但出现以下错误（analysisexception:int和string类型的操作数不可比较：b.comment\u type\u cd='100'）有人能帮我解决这个问题吗：query:

SELECT 
ORDER_ID,
L1.LONG_TEXT
FROM 
DB.ORDER_COMMENT A,
DB.SHORT_TEXT L1
WHERE  ACTION_SEQUENCE = (
    SELECT MAX(ACTION_SEQUENCE) 
    FROM DB.ORDER_COMMENT B
    WHERE B.COMMENT_TYPE_CD='100' 
    AND A.ORDER_ID=B.ORDER_ID) 
AND COMMENT_TYPE_CD='100'
AND A.LONG_TEXT_ID=L1.LONG_TEXT_ID 
AND L1.ACTIVE_IND=1

谢谢