kylin2.3.0错误信息：service.QueryService:536 : Exception while executing query

最新推荐文章于 2022-07-27 11:19:30 发布
最新推荐文章于 2022-07-27 11:19:30 发布
阅读量455 收藏
点赞数
分类专栏： kylin 文章标签： kylin
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39087839/article/details/100036769
版权

问题：检索kylin的时候，页面没有返回错误信息。

解决：检索对应cube没有数据，添加cube数据，下面错误消失。

 

 

 

错误log：

2019-08-23 13:33:40,661 INFO  [Query ce241435-d133-4852-b6db-c21055dad77c-50] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment 20190701000000_20190801000000
2019-08-23 13:33:40,662 DEBUG [Query ce241435-d133-4852-b6db-c21055dad77c-50] dict.TrieDictionary:155 : Not a valid value: 201901
2019-08-23 13:33:40,663 DEBUG [Query ce241435-d133-4852-b6db-c21055dad77c-50] filter.FilterOptimizeTransformer:98 : Optimized {AND [UNKNOWN_MODEL:NULL.GT_MOCKUP_TABLE.1 GTE [\x00], []]} to ConstantTupleFilter.FALSE
2019-08-23 13:33:40,663 DEBUG [Query ce241435-d133-4852-b6db-c21055dad77c-50] filter.FilterOptimizeTransformer:98 : Optimized {AND [AND [UNKNOWN_MODEL:NULL.GT_MOCKUP_TABLE.1 GTE [\x00], UNKNOWN_MODEL:NULL.GT_MOCKUP_TABLE.1 LTE [\x00]], [], UNKNOWN_MODEL:NULL.GT_MOCKUP_TABLE.2 EQ [\x01], AND [UNKNOWN_MODEL:NULL.GT_MOCKUP_TABLE.0 GTE [\x00\x11], UNKNOWN_MODEL:NULL.GT_MOCKUP_TABLE.0 LTE [\x08\xD2]]]} to ConstantTupleFilter.FALSE
2019-08-23 13:33:40,663 INFO  [Query ce241435-d133-4852-b6db-c21055dad77c-50] gtrecord.ScannerWorker:54 : Segment xxxx_xxx_xxx_cube[20190701000000_20190801000000] will be skipped
2019-08-23 13:33:40,664 DEBUG [Query ce241435-d133-4852-b6db-c21055dad77c-50] enumerator.OLAPEnumerator:120 : return TupleIterator...
2019-08-23 13:33:40,671 ERROR [Query ce241435-d133-4852-b6db-c21055dad77c-50] service.QueryService:536 : Exception while executing query
java.lang.NullPointerException
	at Baz$5$1.current(Unknown Source)
	at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.next(Linq4j.java:672)
	at org.apache.calcite.avatica.util.IteratorCursor.next(IteratorCursor.java:46)
	at org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:239)
	at org.apache.kylin.rest.service.QueryService.execute(QueryService.java:949)
	at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:661)
	at org.apache.kylin.rest.service.QueryService.query(QueryService.java:188)
	at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:496)
	at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:455)
	at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:390)
	at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:86)
	at sun.reflect.GeneratedMethodAccessor175.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
	at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Hotbloodedboy
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
kylin query原理剖析
IT白吃男
01-18 2823
前言最近我们组负责数据建模的同学抱怨kylin的relization选择策略：同一个project下一条查询语句本来期望命中某一个cube的，结果系统却选择了其他cube。之前也有大概翻阅过kylin这块的实现源码，知道如果同一个project下如果有多个满足条件的的实现，会按照成本排序并选择成本最低的那个实现。对于成本这块的度量标准，没有做过多研究，于是带着问题，对这块源码进行了一次梳理。源码剖
kylin2.3.0已编译apache-kylin-2.3.0-bin.tar.gz(上)
02-25
kylin2.3.0已编译apache-kylin-2.3.0-bin.tar.gz(上)由于CSDN上传文件大小限制，所以分成了两部分
Capistrano部署报错SSHKit::Runner::ExecuteError: Exception while executing
weixin_30493321的博客
10-13 455
解决方法： 在服务器端安装git，cap部署后会自动在目录下创建几个文件夹： 报错内容： $ cap product deploy(Backtrace restricted to imported tasks)cap aborted!SSHKit::Runner::ExecuteError: Exception while executing as remote_host: git...
spark-sql操作hive报错及解决
weixin_43799404的博客
04-20 1539
spark-sql操作hive报错及解决 1.Exception thrown when executing query : SELECT DISTINCT ‘org.apache.hadoop.hive.metastore.model.MTable’ AS NUCLEUS_TYPE,A0.CREATE_TIME,A0.LAST_ACCESS_TIME,A0.OWNER,A0.RETENTION,A0.IS_REWRITE_ENABLED,A0.TBL_NAME,A0.TBL_TYPE,A0.TBL_ID
sparkSQL写入hive报错:Exception thrown when executing query
weixin_45011411的博客
07-27 1347
*错误信息**org.apache.spark.sql.AnalysisExceptionorg.apache.hadoop.hive.ql.metadata.HiveExceptionMetaException(messageExceptionthrownwhenexecutingquery)**原因**hive的分区字段值异常导致，分区字段不支持中文。分区字段修改文utf8的编码以后，貌似可以创建中文分区。......
解决报错：The error occurred while executing a query
weixin_45889880的博客
11-19 4万+
又被阿里的druid坑了一手，没错已经不知道是第几次被阿里的druid坑了。 次次都是数据库连接问题，我看到这个问题已经开始优先考虑是不是druid的问题了。 The error occurred while executing a query 这个报错看似很难没遇到过，而我看到他就去 properties里面把 spring.datasource.druid.filters=wall,slf4j 这一段里面的wall去掉 spring.datasource.druid.filters=slf4j 去掉就好
kylin2.3.0已编译apache-kylin-2.3.0-bin.tar.gz(下)
02-25
kylin2.3.0已编译apache-kylin-2.3.0-bin.tar.gz(下)由于CSDN上传文件大小限制，所以分成了两部分
kylinolap.github.io:kylinop.github.io 和 kylin.io 的网页
07-09
kylinop.github.io kylinop.github.io
编译完成：vsftpd3.0.3.tar.gz
最新发布
07-15
编译完成：vsftpd3.0.3.tar.gz 编译完成：vsftpd3.0.3.tar.gz 编译完成：vsftpd3.0.3.tar.gz 编译完成：vsftpd3.0.3.tar.gz 编译完成：vsftpd3.0.3.tar.gz 编译完成：vsftpd3.0.3.tar.gz 编译完成：vsftpd3.0.3.tar....
国产化360安全浏览器，版本：13.2.1031.22-1
05-10
国产化360安全浏览器，可以在银河麒麟V10桌面系统使用。x86架构。
The error occurred while executing a query，oracle jdbc连接报错
热门推荐
姚毛毛的博客
07-12 4万+
本文章博客园首发。 最近碰到了个很有意思的问题，springboot加载多数据源，遇到了在启动时数据库连接报错的问题。 报错信息： The error occurred while executing a query 然后找到了一篇文章，linux熵池耗尽 http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hang...
SSH框架执行Sql语句报错---could not execute query---及解决方法
_阿洋
02-15 3万+
报错信息如下： org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.exception.JDBCExceptionH...
Error while executing SQL query on database '表名': near "truncate": syntax error
haoranhaoshi的博客
07-12 7503
SQLite不支持truncate，如果你想清空db文件里某个表的记录，可以使用delete from 表名 Connection connection = DriverManager.getConnection("jdbc:sqlite:" + DB_PATH); Statement statement = connection.createStatement(); statement.ex...
大神看看这个咋回事，ssm框架
s174896的博客
07-16 396
ssm框架做了一个登录（功能正常），近期学socket，就想着用在新建一个项目用socket调用前一个项目的service，我在socket中直接用applicationcontext.getbean()来获取service，但是出现了下面的错误： JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@9641394] will ...
idea maven setting at sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) 报错
u012956987的博客
07-16 8066
写项目的时候下载jar包 时更改了 setting 文件，mirrors 镜像文件改出了问题？ 如果在报这个错之前，你修改了setting 文件，那就去找你的setting文件是否正确，标签呀、地址呀这些 希望能帮助同样烦恼的同学~ ...
6月 01 14:26:58 kylin systemd[1]: docker.service: Main process exited, code=exited, status=1/FAILURE 6月 01 14:26:58 kylin systemd[1]: docker.service: Failed with result 'exit-code'. 6月 01 14:26:58 kylin systemd[1]: Failed to start Docker Application Container Engine. 6月 01 14:27:00 kylin systemd[1]: docker.service: Scheduled restart job, restart counter is at 3. 6月 01 14:27:00 kylin systemd[1]: Stopped Docker Application Container Engine. 6月 01 14:27:00 kylin systemd[1]: docker.service: Start request repeated too quickly. 6月 01 14:27:00 kylin systemd[1]: docker.service: Failed with result 'exit-code'. 6月 01 14:27:00 kylin systemd[1]: Failed to start Docker Application Container Engine. 6月 01 14:27:40 kylin systemd[1]: docker.service: Start request repeated too quickly. 6月 01 14:27:40 kylin systemd[1]: docker.service: Failed with result 'exit-code'. 6月 01 14:27:40 kylin systemd[1]: Failed to start Docker Application Container Engine.
06-02
这些日志表明 Docker 服务启动失败，并且系统尝试多次启动 Docker 服务，但是都失败了。具体的失败原因需要查看更详细的日志信息。 你可以尝试运行以下命令，查看 Docker 服务的详细启动日志： ``` sudo journalctl -u docker.service ``` 这个命令会显示 Docker 服务的启动日志，你可以查看日志中的错误信息，找到 Docker 启动失败的原因。常见的启动失败原因包括： - 系统资源不足，比如内存或者磁盘空间不足； - Docker 镜像或者容器启动失败，比如容器启动时脚本出错或者镜像下载失败； - Docker 配置错误，比如配置文件中的参数设置错误。 根据具体的错误信息，你可以采取相应的措施来解决问题。比如，如果是系统资源不足导致的问题，可以尝试释放一些资源；如果是 Docker 镜像或者容器启动失败，可以尝试重新启动容器或者重新下载镜像。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值