ksql查询like出错

milaotou

sql = String.format("SELECT JHDD_PE_AlertManagement,JHDD_PE_AlertManagement.fProjectName,JHDD_PE_AlertManagement.fCreatePsnName,JHDD_PE_AlertManagement.fCreateTime FROM JHDD_PE_AlertManagement JHDD_PE_AlertManagement  where JHDD_PE_AlertManagement.fCreateDeptFID like '"+deptID+"%' order by JHDD_PE_AlertManagement.fCreateTime desc limit 0,6");

        Table result = KSQL.select(sql, null, "/JHDD/PlanExecute/data", null);
        return result;


上面代码中如果 like '"+deptID+"' 不加%，就不报错，加了就报错
请问是什么问题？

jishuang

参考like concat(SA_Log.sCreatorPersonID, '%')

milaotou

jishuang 发表于 2017-7-21 15:06
参考like concat(SA_Log.sCreatorPersonID, '%')

还是那个错

jishuang

把ksql发一下

milaotou

jishuang 发表于 2017-7-21 17:26
把ksql发一下

sql = String.format("SELECT JHDD_PE_AlertManagement,JHDD_PE_AlertManagement.fProjectName,JHDD_PE_AlertManagement.fCreatePsnName,JHDD_PE_AlertManagement.fCreateTime FROM JHDD_PE_AlertManagement JHDD_PE_AlertManagement  where JHDD_PE_AlertManagement.fCreateDeptFID like '"+deptID+"%' order by JHDD_PE_AlertManagement.fCreateTime desc limit 0,6");

jishuang

like用like concat(SA_Log.sCreatorPersonID, '%')的方式拼接啊
你发的还是你一开始的写法