chenchurong commented on issue #22161:
URL: https://github.com/apache/doris/issues/22161#issuecomment-1647646861
` org.springframework.jdbc.UncategorizedSQLException: StatementCallback;
uncategorized SQLException for SQL [select count(*) from ( select
entity_code, credit_code, company_name_source from dim_kp_company_main
where company_name_source match_all '万科' ) a]; SQL state [HY000]; error code
[1105]; errCode = 2, detailMessage = Syntax error in line 1:
...where company_name_source match_all '万科' ) a
^
Encountered: IDENTIFIER
Expected: ||, COMMA
; nested exception is java.sql.SQLException: errCode = 2, detailMessage =
Syntax error in line 1:
...where company_name_source match_all '万科' ) a
^
Encountered: IDENTIFIER
Expected: ||, COMMA
at
org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:393)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:508)
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:515)
at
com.lighthouse.chaos.util.DorisQueryService.getTotalCount(DorisQueryService.java:128)
at
com.lighthouse.chaos.util.DorisQueryService.selectForPagination(DorisQueryService.java:49)
at
com.lighthouse.chaos.util.DorisQueryService$$FastClassBySpringCGLIB$$ae975b77.invoke(<generated>)
at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at
`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
