Em.. what posted is the cached exception. Need the initial exception for troubleshooting..
Could you restart Kylin, query again and post the full log as attachment? On Fri, Sep 18, 2015 at 4:45 PM, George Lu <[email protected]> wrote: > After I excute " > select part_dt, sum(price) as total_selled, count(distinct seller_id) as > sellers from kylin_sales group by part_dt order by part_dt;" > > java.io.IOException: No such file or directory > > [pool-16-thread-1]:[2015-09-18 > > 01:42:02,809][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)] > - Job Fetcher: 0 running, 0 actual running, 0 ready, 9 others > [http-bio-7070-exec-11]:[2015-09-18 > > 01:42:40,933][INFO][org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:176)] > - Using project: learn_kylin > [http-bio-7070-exec-11]:[2015-09-18 > > 01:42:40,937][INFO][org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:177)] > - The original query: select part_dt, sum(price) as total_selled, > count(distinct seller_id) as sellers from kylin_sales group by part_dt > order by part_dt; > [http-bio-7070-exec-11]:[2015-09-18 > > 01:42:40,941][ERROR][org.apache.kylin.rest.controller.BasicController.handleError(BasicController.java:46)] > - > org.apache.kylin.rest.exception.InternalErrorException: > java.io.IOException: No such file or directory > at > > org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:219) > at > > org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:165) > at > > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:497) > at > > org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213) > at > > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) > at > > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) > at > > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) > at > > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) > at > > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) > at > > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) > at > > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) > at > > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) > at > > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) > 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:201) > 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:346) > at > > org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > > org.apache.kylin.rest.filter.KylinApiFilter.doFilterInternal(KylinApiFilter.java:66) > at > > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) > 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:195) > at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) > 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:504) > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) > at > > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) > at > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > at > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > [http-bio-7070-exec-11]:[2015-09-18 > > 01:42:40,947][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)] > - REQUEST: REQUESTER=ADMIN;REQ_TIME=PDT 2015-09-18 > > 01:42:40;URI=/kylin/api/query;METHOD=POST;QUERY_STRING=null;PAYLOAD={"sql":"select > part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers > from kylin_sales group by part_dt order by > > part_dt;","offset":0,"limit":50000,"acceptPartial":true,"project":"learn_kylin"};RESP_STATUS=500; > [pool-16-thread-1]:[2015-09-18 > > 01:43:02,772][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)] > - Job Fetcher: 0 running, 0 actual running, 0 ready, 9 others > > On Fri, Sep 18, 2015 at 4:03 PM, Li Yang <[email protected]> wrote: > > > Was the cube build successful? If it is and the cube status is green > (ready > > state), please post logs and then we can help. > > > > Logs are found at KYLIN_HOME/tomcat/logs/kylin.log > > > > On Fri, Sep 18, 2015 at 11:51 AM, George Lu <[email protected]> > wrote: > > > > > I refreshed two tables and kylin says refresh success, but after I > click > > > the default schema, only one table show up. > > > Is that a bug? > > > I use kylin 1.0. > > > > > > On Fri, Sep 18, 2015 at 11:23 AM, George Lu <[email protected]> > > wrote: > > > > > > > Hi all, > > > > > > > > I follow the instruction and query below "select part_dt, sum(price) > as > > > > total_selled, count(distinct seller_id) as sellers from kylin_sales > > group > > > > by part_dt order by part_dt". > > > > > > > > I build the cube previously and can query, however, after I query > this > > > the > > > > next day, kylin says: > > > > From line 1, column 87 to line 1, column 97: Table 'KYLIN_SALES' not > > > found > > > > while executing SQL: "select part_dt, sum(price) as total_selled, > > > > count(distinct seller_id) as sellers from kylin_sales group by > part_dt > > > > order by part_dt LIMIT 50000" > > > > > > > > why is that? > > > > > > > > And in the table tab, after I sync for the sample tables (use > sampe.sql > > > in > > > > bin folder), there is no tables show up. > > > > > > > > What is the problem? > > > > > > > > Thanks, > > > > George > > > > > > > > > >
