[ https://issues.apache.org/jira/browse/EAGLE-319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15335168#comment-15335168 ]
ASF GitHub Bot commented on EAGLE-319: -------------------------------------- Github user anyway1021 closed the pull request at: https://github.com/apache/incubator-eagle/pull/222 > java.sql.SQLSyntaxErrorException caught when querying from table > topologyExecutionEntity > ---------------------------------------------------------------------------------------- > > Key: EAGLE-319 > URL: https://issues.apache.org/jira/browse/EAGLE-319 > Project: Eagle > Issue Type: Bug > Reporter: Michael Wu > Assignee: Michael Wu > Fix For: v0.4.0 > > > When querying from table topology_execution, met below error in eagle service > log: > Error log with stacktrace: > *************** > [ERROR] [05/27/2016 06:26:34.971] > [application-manager-scheduler-akka.actor.default-dispatcher-19] > [akka://application-manager-scheduler/user/$a/command-worker] Fail to load > any topologyExecutionEntity due to Exception: java.io.IOException: > org.apache.torque.TorqueException: java.sql.SQLSyntaxErrorException: > Comparisons between 'LONG VARCHAR (UCS_BASIC)' and 'LONG VARCHAR (UCS_BASIC)' > are not supported. Types must be comparable. String types must also have > matching collation. If collation does not match, a possible solution is to > cast operands to force them to the default collation (e.g. SELECT tablename > FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1') > org.apache.eagle.storage.jdbc.JdbcStorage.query(JdbcStorage.java:179) > org.apache.eagle.storage.operation.QueryStatement.execute(QueryStatement.java:47) > org.apache.eagle.service.generic.GenericEntityServiceResource.search(GenericEntityServiceResource.java:443) > sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > java.lang.reflect.Method.invoke(Method.java:606) > com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) > com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) > com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) > com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288) > *************** -- This message was sent by Atlassian JIRA (v6.3.4#6332)