Kylin多波段参数查询错误。
post:{“sql”：“select loan.create\u time as time\u date，loan.apply\u orders as apply\u orders，lend.loan\u orders as loan\u orders，round（cast（applylend.apply\u and\u loan\u orders as double）/loan.apply\u orders，4）as loan\u pass rate from（select create\u time，count（borrow\u id）as apply\u orders from app\u biu order\u apply where create\u time=？按创建时间分组）loan left join（选择loan\u time，从app\u bi\u order\u apply计算（借用id）为loan\u orders，其中loan\u time=？按贷款时间分组）loan on lend.loan\u time=loan.create\u time left join（选择贷款时间，将（借用id）计数为apply\u和app\u bi\u order\u apply中的\u loan\u orders，其中loan\u time=？创建时间=？group by loan\u time）applylend on applylend.loan\u time=loan.create\u time，“project”：“bi”，“acceptpartial”：false，“backdoortoggles”：{“attr\u statement\u max\u rows”：“0”}，“params”：[{“classname”：“java.lang.string”，“value”：“2018-06-01”}，{“classname”：“java.lang.string”，“value”：“2018-06-01”}，{“classname”：“java.lang.string”，“value”：“2018-06-01”}，{“classname”：“java.lang.string”，“value”：“2018-06-01”}]}
错误消息：{“code”：“999”，“data”：null，“msg”：“unknown error.”，“stacktrace”：“org.apache.kylin.rest.exception.internalerrorexception:未知错误。\n\t org.apache.kylin.rest.service.queryservice.doquerywithcache（queryservice）。java:424)\n\t org.apache.kylin.rest.service.queryservice.doquerywithcache（queryservice。java:351)\否\torg.apache.kylin.rest.controller.querycontroller.query（querycontroller。java:86)\n\t sun.reflect.nativemethodaccessorimpl.invoke0（本机方法）\n\t sun.reflect.nativemethodaccessorimpl.invoke（本机方法）。java:62)\n\tSun.reflect.delegatingmethodaccessorimpl.invoke（delegatingmethodaccessorimpl。java:43)\否\tjava.lang.reflect.method.invoke（方法。java:498)\n\t org.springframework.web.method.support.invocablehandlermethod.doinvoke（invocablehandlermethod）。java:205)\n\t org.springframework.web.method.support.invocablehandlermethod.invokeforrequest（invocablehandlermethod）。java:133)\否\torg.springframework.web.servlet.mvc.method.annotation.servletinvacableHandlerMethod.invokeandhandle（servletinvacableHandlerMethod）。java:97)\n\t org.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.invokehandlermethod（requestmappinghandleradapter）。java:827)\否\torg.springframework.web.servlet.mvc.method.annotation.requestmappinghandleradapter.handleinternal（requestmappinghandleradapter。java:738)\n\t org.springframework.web.servlet.mvc.method.abstracthandlermethodadapter.handle（abstracthandlermethodadapter）。java:85)\否\torg.springframework.web.servlet.dispatcherservlet.dodispatch（dispatcherservlet。java:967)\n\t org.springframework.web.servlet.dispatcherservlet.doservice（dispatcherservlet。java:901)\n\t org.springframework.web.servlet.frameworkservlet.processrequest（frameworkservlet。java:970)\否\torg.springframework.web.servlet.frameworkservlet.dopost（frameworkservlet。java:872)\n\tat javax.servlet.http.httpservlet.service（httpservlet。java:661)\n\t org.springframework.web.servlet.frameworkservlet.service（frameworkservlet。java:846)\n\tat javax.servlet.http.httpservlet.service（httpservlet。java:742)\否\torg.apache.catalina.core.applicationfilterchain.internaldofilter（applicationfilterchain）。java:231)\n\t org.apache.catalina.core.applicationfilterchain.dofilter（applicationfilterchain）。java:166)\n\tat org.apache.tomcat.websocket.server.wsfilter.dofilter（wsfilter。java:52)\否\torg.apache.catalina.core.applicationfilterchain.internaldofilter（applicationfilterchain）。java:193)\n\t org.apache.catalina.core.applicationfilterchain.dofilter（applicationfilterchain）。java:166)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:317)\否\torg.springframework.security.web.access.intercept.filtersecurityinterceptor.invoke（filtersecurityinterceptor。java:127)\n\t org.springframework.security.web.access.intercept.filtersecurityinterceptor.dofilter（filtersecurityinterceptor。java:91)\否\torg.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\n\t位于org.springframework.security.web.access.exceptiontranslationfilter.dofilter（exceptiontranslationfilter。java:114)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\否\torg.springframework.security.web.session.sessionmanagementfilter.dofilter（sessionmanagementfilter。java:137)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\否\torg.springframework.security.web.authentication.anonymousauthenticationfilter.dofilter（anonymousauthenticationfilter。java:111)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\否\torg.springframework.security.web.servletapi.securitycontextholderawarerequestfilter.dofilter（securitycontextholderawarerequestfilter）。java:170)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\否\torg.springframework.security.web.savedrequest.requestcacheawarefilter.dofilter（requestcacheawarefilter。java:63)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\否\torg.springframework.security.web.authentication.验证。www.basicauthenticationfilter.dofilterinternal（基本身份验证筛选器。java:215)\n\t org.springframework.web.filter.onceperrequestfilter.dofilter（onceperrequestfilter。java:107)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\否\torg.springframework.security.web.authentication.abstractauthenticationprocessingfilter.dofilter（abstractauthenticationprocessingfilter）。java:200)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\否\torg.springframework.security.web.authentication.logout.logoutfilter.dofilter（logoutfilter。java:116)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\n\t org.springframework.security.web.header.headerwriterfilter.dofilterinternal（headerwriterfilter。java:64)\否\torg.springframework.web.filter.onceperrequestfilter.dofilter（onceperrequestfilter。java:107)\n\t org.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\否\torg.springframework.security.web.context.request.async.webasyncmanagerintegrationfilter.dofilterinternal（webasyncmanagerintegrationfilter）。java:56)\n\t org.springframework.web.filter.onceperrequestfilter.dofilter（onceperrequestfilter。java:107)\否\torg.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\n\t org.springframework.security.web.context.securitycontextpersistencefilter.dofilter（securitycontextpersistencefilter）。java:105)\否\torg.springframework.security.web.filterchainproxy$virtualfilterchain.dofilter（filterchainproxy。java:331)\n\t org.springframework.security.web.filterchainproxy.dofilternternal（filterchainproxy。java:214)\n\t org.springframework.security.web.filterchainproxy.dofilter（filterchainproxy。java:177)\否\torg.springframework.web.filter.delegatingfilterproxy.invokedelegate（delegatingfilterproxy。java:346)\n\t org.springframework.web.filter.delegatingfilterproxy.dofilter（delegatingfilterproxy。java:262)\n\t org.apache.catalina.core.applicationfilterchain.internaldofilter（applicationfilterchain）。java:193)\否\torg.apache.catalina.core.applicationfilterchain.dofilter（applicationfilterchain。java:166)\n\t在com.thetransactioncompany.cors.corsfilter.dofilter（corsfilter。java:209)\n\t在com.thetransactioncompany.cors.corsfilter.dofilter（corsfilter。java:244)\否\torg.apache.catalina.core.applicationfilterchain.internaldofilter（applicationfilterchain）。java:193)\n\t org.apache.catalina.core.applicationfilterchain.dofilter（applicationfilterchain）。java:166)\n\t org.apache.catalina.core.standardwrappervalve.invoke（standardwrappervalve。java:198)\否\torg.apache.catalina.core.standardcontextvalve.invoke（standardcontextvalve。java:96)\n\t org.apache.catalina.authenticator.authenticatorbase.invoke（authenticatorbase。java:493)\n\t org.apache.catalina.core.standardhostvalve.invoke（standardhostvalve。java:140)\n\t org.apache.catalina.valves.errorreportvalve.invoke（errorreportvalve。java:81)\否\torg.apache.catalina.valves.abstractaccesslogvalve.invoke（abstractaccesslogvalve。java:650)\n\t org.apache.catalina.core.standardenginevalve.invoke（standardenginevalve。java:87)\n\t org.apache.catalina.connector.coyoteadapter.service（coyoteadapter。java:342)\n\t org.apache.coyote.http11.http11processor.service（http11processor。java:800)\否\torg.apache.coyote.abstractprocessorlight.process（abstractprocessorlight。java:66)\n\t org.apache.coyote.abstractprotocol$connectionhandler.process（抽象协议）。java:806)\n\t org.apache.tomcat.util.net.nioendpoint$socketprocessor.dorun（nioendpoint）。java:1498)\否\torg.apache.tomcat.util.net.socketprocessorbase.run（socketprocessorbase。java:49)\n\t java.util.concurrent.threadpoolexecutor.runworker（threadpoolexecutor。java:1149)\n\t java.util.concurrent.threadpoolexecutor$worker.run（线程池执行器。java:624)\n\t org.apache.tomcat.util.threads.taskthread$wrappingrunnable.run（taskthread。java:61)\否\tjava.lang.thread.run（线程。java:748)\n”，“exception”：“未知错误。”，“url”：http://ip/kylin/api/query" }