My sql is：
<http://apache-kylin.74782.x6.nabble.com/file/t1144/sql.png>
when i try it ,it will failed. The error text is "xception while executing
query: java.io.IOException: POST failed, error code 500 and response:
{"code":"999","data":null,"msg":"Unrecognized column type:
SQL_CHAR","stacktrace":"org.apache.kylin.rest.exception.InternalErrorException:
Unrecognized column type: SQL_CHAR\n\tat
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:441)\n\tat
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367)\n\tat
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87)\n\tat
sun.reflect.GeneratedMethodAccessor135.invoke(Unknown Source)\n\tat
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat
java.lang.reflect.Method.invoke(Method.java:498)\n\tat
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\n\tat
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\n\tat
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\n\tat
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)\n\tat
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)\n\tat
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\n\tat
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)\n\tat
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)\n\tat
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\n\tat
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\n\tat
javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\n\tat
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\n\tat
javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\n\tat
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\n\tat
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat
"
But if I add "limit 1000" to the sql. such as
<http://apache-kylin.74782.x6.nabble.com/file/t1144/sql2.jpg>
it will success. why the first sql catnot success.The version of Kylin is
2.6.5
--
Sent from: http://apache-kylin.74782.x6.nabble.com/
