KSQL执行出错

liu7030

自己写的一个动作的KSQL总是报错，是我的写法错了么？

1. int pointCount = 0;
   
2. try{
   
3. String ksql = "select count(t.*) as pointCount from CA_Point t where t.fLineBelong = '"+ lineName +"'";
   
4. Table table = KSQL.select(ksql, null, "/CablePatrol/BaseData/data", null);
   
5. Iterator<Row> it = table.iterator();
   
6. while(it.hasNext()) {
   
7. 
   
8. Row row = it.next();
   
9. pointCount = row.getInt("pointCount");
   
10. System.out.println(pointCount);
    
11. 
    
12. }
    
13. }
    
14. catch (Exception e) {
    
15. throw new RuntimeException (e.getMessage());
    
16. }
    
17. 
    

复制代码

jishuang

具体的错误信息发一下

liu7030

jishuang 发表于 2013-12-4 17:17
具体的错误信息发一下

错误信息就一句，select count(t.*) as pointCount from CA_Point t where t.fLineBelong = 'XXX'  KSQL语句执行出错，我把count(t.*)换成countAll()就不报错了，KSQL不是支持count()么

yinlun

liu7030 发表于 2013-12-4 18:11
错误信息就一句，select count(t.*) as pointCount from CA_Point t where t.fLineBelong = 'XXX'  KSQL ...

不要用count(t.*) ，直接用count(*)试试

liu7030

yinlun 发表于 2013-12-4 18:41
不要用count(t.*) ，直接用count(*)试试

还是报错额

1. aused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, select count(^^*) as pointCoun中未找到需要的元素, 位置13期望是)

复制代码

fpj

liu7030 发表于 2013-12-4 18:11
错误信息就一句，select count(t.*) as pointCount from CA_Point t where t.fLineBelong = 'XXX'  KSQL ...

你这个写试试
select count(t) as pointCount from CA_Point t where t.fLineBelong = 'XXX'  

liu7030

fpj 发表于 2013-12-4 19:05
你这个写试试
select count(t) as pointCount from CA_Point t where t.fLineBelong = 'XXX'

谢谢，用count(t)就没报错了

ecoolper

select count(1) as pointCount from CA_Point t where t.fLineBelong = 'XXX'

liu7030

ecoolper 发表于 2013-12-4 20:09
select count(1) as pointCount from CA_Point t where t.fLineBelong = 'XXX'

谢谢