ksql排序中使用函数报错

sandgia

select VIEW_BID_ENROLL.*
    from VIEW_BID_ENROLL VIEW_BID_ENROLL
    order by substring(VIEW_BID_ENROLL.BIDNO,2,10) desc

提示：

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select VIEW_BID_ENROLL.*     from VIEW_BID_ENROLL VIEW_BID_ENROLL     order by substring(VIEW_BID_ENROLL.BIDNO,2,10) desc LIMIT 0, 50
--> sql:
--> binds: []
    at com.justep.exception.BusinessException.create(Unknown Source)
    at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    at com.justep.system.data.KSQL.select(Unknown Source)
    at KSQLProcedure.query(KSQLProcedure.java:17)
    ... 30 more
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, er by substring^^(VIEW_BID_ENROL中未找到需要的元素, 位置88期望是<EOF>
    at com.justep.exception.KSQLException.create(Unknown Source)
    at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
    at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
    at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
    at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
    at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
    ... 35 more

jishuang

SQL.调用数据库的函数实现看看

sandgia

jishuang 发表于 2020-8-12 16:59
SQL.调用数据库的函数实现看看

SQL可以，ksql是不是没法实现？

jishuang

我说的是order by后面的函数用SQL.开头去调用看看，就是用调用sql的本地函数执行

sandgia

jishuang 发表于 2020-8-12 19:11
我说的是order by后面的函数用SQL.开头去调用看看，就是用调用sql的本地函数执行 ...

select VIEW_BID_ENROLL.*
    from VIEW_BID_ENROLL VIEW_BID_ENROLL
    order by SQL.substr(VIEW_BID_ENROLL.BIDNO,2,10) desc

报错：
Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, r by SQL.substr^^(VIEW_BID_ENROL中未找到需要的元素, 位置91期望是<EOF>
        at com.justep.exception.KSQLException.create(Unknown Source)
        at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
        at com.justep.system.ksql.token.TokenManager.match(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
        ... 35 more

jishuang

那就是ksql中不能这样写，需要用sql实现