You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "konglei (JIRA)" <ji...@apache.org> on 2016/12/27 04:05:58 UTC
[jira] [Commented] (KYLIN-2321) Message: Error while executing SQL
"select * from root.id_card LIMIT 50000": AppendTrieDictionary can't
retrive value from id
[ https://issues.apache.org/jira/browse/KYLIN-2321?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15779549#comment-15779549 ]
konglei commented on KYLIN-2321:
--------------------------------
CUBEDesc
{
"uuid": "f6ea7356-28a6-4cb1-84d4-7202ff8bbf3d",
"last_modified": 1482809775804,
"version": "1.6.0",
"name": "ROOT3",
"owner": "ADMIN",
"descriptor": "ROOT3",
"cost": 50,
"status": "READY",
"segments": [
{
"uuid": "e97abdf7-5bc4-4051-9732-9aac34372dd6",
"name": "20100101000000_20100102000000",
"storage_location_identifier": "KYLIN_CQQG0OXQL1",
"date_range_start": 1262304000000,
"date_range_end": 1262390400000,
"source_offset_start": 0,
"source_offset_end": 0,
"status": "READY",
"size_kb": 98425,
"input_records": 10000000,
"input_records_size": 12616116253,
"last_build_time": 1482808112805,
"last_build_job_id": "3d5a2ad4-4533-4f4f-9c04-d781d6bcc36f",
"create_time_utc": 1482807331487,
"cuboid_shard_nums": {},
"total_shards": 1,
"blackout_cuboids": [],
"binary_signature": null,
"dictionaries": {
"ROOT.ID_CARD/MD5": "/dict/ROOT.ID_CARD/MD5/ebad9ebe-fa16-412c-9682-fc1118633031.dict",
"ROOT.ID_CARD/ID": "/dict/ROOT.ID_CARD/ID/bed4f51d-4176-4e77-b975-2ca57352c9d7.dict"
},
"snapshots": null,
"index_path": "/kylin1/kylin_konglei/kylin-3d5a2ad4-4533-4f4f-9c04-d781d6bcc36f/ROOT3/secondary_index/",
"rowkey_stats": [
[
"ID",
30000001,
4
],
[
"MD5",
30000005,
4
]
]
},
{
"uuid": "401ce96f-a1f9-4eca-8472-bb8cd4e5b28b",
"name": "20100102000000_20100103000000",
"storage_location_identifier": "KYLIN_PP7Y1DJS7V",
"date_range_start": 1262390400000,
"date_range_end": 1262476800000,
"source_offset_start": 0,
"source_offset_end": 0,
"status": "READY",
"size_kb": 98425,
"input_records": 10000000,
"input_records_size": 13169415592,
"last_build_time": 1482808729923,
"last_build_job_id": "eec0d296-b7da-40eb-9d71-2b20c066c6cb",
"create_time_utc": 1482808020095,
"cuboid_shard_nums": {},
"total_shards": 1,
"blackout_cuboids": [],
"binary_signature": null,
"dictionaries": {
"ROOT.ID_CARD/MD5": "/dict/ROOT.ID_CARD/MD5/ebad9ebe-fa16-412c-9682-fc1118633031.dict",
"ROOT.ID_CARD/ID": "/dict/ROOT.ID_CARD/ID/bed4f51d-4176-4e77-b975-2ca57352c9d7.dict"
},
"snapshots": null,
"index_path": "/kylin1/kylin_konglei/kylin-eec0d296-b7da-40eb-9d71-2b20c066c6cb/ROOT3/secondary_index/",
"rowkey_stats": [
[
"ID",
30000001,
4
],
[
"MD5",
30000005,
4
]
]
},
{
"uuid": "53803b6b-1971-4487-95d5-52a8582e8d02",
"name": "20100103000000_20100104000000",
"storage_location_identifier": "KYLIN_WFML9QCPV7",
"date_range_start": 1262476800000,
"date_range_end": 1262563200000,
"source_offset_start": 0,
"source_offset_end": 0,
"status": "READY",
"size_kb": 98425,
"input_records": 10000000,
"input_records_size": 12877383357,
"last_build_time": 1482809775803,
"last_build_job_id": "27b236e4-5850-4661-8caa-75ccf94b681b",
"create_time_utc": 1482809031516,
"cuboid_shard_nums": {},
"total_shards": 1,
"blackout_cuboids": [],
"binary_signature": null,
"dictionaries": {
"ROOT.ID_CARD/MD5": "/dict/ROOT.ID_CARD/MD5/ebad9ebe-fa16-412c-9682-fc1118633031.dict",
"ROOT.ID_CARD/ID": "/dict/ROOT.ID_CARD/ID/bed4f51d-4176-4e77-b975-2ca57352c9d7.dict"
},
"snapshots": null,
"index_path": "/kylin1/kylin_konglei/kylin-27b236e4-5850-4661-8caa-75ccf94b681b/ROOT3/secondary_index/",
"rowkey_stats": [
[
"ID",
30000001,
4
],
[
"MD5",
30000005,
4
]
]
}
],
"create_time_utc": 1482807305422,
"size_kb": 295275,
"input_records_count": 30000000,
"input_records_size": 38662915202
}
> Message: Error while executing SQL "select * from root.id_card LIMIT 50000": AppendTrieDictionary can't retrive value from id
> -----------------------------------------------------------------------------------------------------------------------------
>
> Key: KYLIN-2321
> URL: https://issues.apache.org/jira/browse/KYLIN-2321
> Project: Kylin
> Issue Type: Bug
> Components: 3rd Party, Job Engine
> Affects Versions: v1.6.0
> Environment: Message: Error while executing SQL "select * from root.id_card LIMIT 50000": AppendTrieDictionary can't retrive value from id
> Reporter: konglei
> Assignee: Dong Li
> Fix For: v1.6.0
>
>
> Message: Error while executing SQL "select * from root.id_card LIMIT 50000": AppendTrieDictionary can't retrive value from id
> ==========================[QUERY]===============================
> 2016-12-26 16:59:16,553 ERROR [http-bio-7070-exec-10] controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Error while executing SQL "select * from root.id_card LIMIT 50000": AppendTrieDictionary can't retrive value from id
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:389)
> at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
> at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
> at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
> at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)
> at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)
> at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
> at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
> at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
> 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:330)
> at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
> at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
> at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
> at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
> at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
> 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:220)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
> 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:956)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
> at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:744)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)