I tried to reproduce this with the binary package on Kylin home page, but no luck; It shows the tables in query tab after cube be built;
On 5/12/15, 1:31 PM, "Shi, Shaofeng" <[email protected]> wrote: >This class is a part of the web application, its location is >$KYLIN_HOME/lib/tomcat/webapps/kylin/WEB-INF/lib/kylin-query-0.7.1-incubat >i >ng-SNAPSHOT.jar > >As the jar is in web app’s lib folder, it should be automatically loaded >when tomcat starts up; > >I downloaded the binary package and unpack it, the jar is there; You may >need check the file integrity or try a new build; > >On 5/12/15, 11:53 AM, "Gaurav Nigam" <[email protected]> wrote: > >>Seems like it is not able to find >>“org.apache.kylin.query.schema.OLAPSchemaFactory” class. I scanned >>through >>all the jars in KYLIN_HOME/lib, but none have it. >> >>Below is the stack trace - >> >> >>[impadmin@server2 kylin-0.7.1-incubating-SNAPSHOT]$ tail -200f >>tomcat/logs/kylin.log >>at >>org.springframework.security.web.authentication.ui.DefaultLoginPageGenera >>t >>i >>ngFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.authentication.AbstractAuthenticationPro >>c >>e >>ssingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.authentication.logout.LogoutFilter.doFil >>t >>e >>r(LogoutFilter.java:105) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.context.SecurityContextPersistenceFilter >>. >>d >>oFilter(SecurityContextPersistenceFilter.java:87) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.FilterChainProxy.doFilterInternal(Filter >>C >>h >>ainProxy.java:192) >>at >>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainPro >>x >>y >>.java:160) >>at >>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Deleg >>a >>t >>ingFilterProxy.java:346) >>at >>org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingF >>i >>l >>terProxy.java:259) >>at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat >>i >>o >>nFilterChain.java:241) >>at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte >>r >>C >>hain.java:208) >>at >>com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:205) >>at >>com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) >>at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat >>i >>o >>nFilterChain.java:241) >>at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte >>r >>C >>hain.java:208) >>at >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve >>. >>j >>ava:220) >>at >>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve >>. >>j >>ava:122) >>at >>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorB >>a >>s >>e.java:504) >>at >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: >>1 >>7 >>0) >>at >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: >>1 >>0 >>3) >>at >>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >>at >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j >>a >>v >>a:116) >>at >>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:42 >>1 >>) >>at >>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Pr >>o >>c >>essor.java:1074) >>at >>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(Abst >>r >>a >>ctProtocol.java:611) >>at >>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.ja >>v >>a >>:314) >>at >>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java >>: >>1 >>145) >>at >>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.jav >>a >>: >>615) >>at >>org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread >>. >>j >>ava:61) >>at java.lang.Thread.run(Thread.java:745) >>Caused by: java.lang.ClassNotFoundException: >>org.apache.kylin.query.schema.OLAPSchemaFactory >>at java.net.URLClassLoader$1.run(URLClassLoader.java:366) >>at java.net.URLClassLoader$1.run(URLClassLoader.java:355) >>at java.security.AccessController.doPrivileged(Native Method) >>at java.net.URLClassLoader.findClass(URLClassLoader.java:354) >>at java.lang.ClassLoader.loadClass(ClassLoader.java:425) >>at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) >>at java.lang.ClassLoader.loadClass(ClassLoader.java:358) >>at java.lang.Class.forName0(Native Method) >>at java.lang.Class.forName(Class.java:191) >>at org.apache.calcite.model.ModelHandler.visit(ModelHandler.java:209) >>... 103 more >>[http-bio-7070-exec-10]:[2015-05-12 >>07:59:44,926][ERROR][org.apache.kylin.rest.controller.BasicController.han >>d >>l >>eError(BasicController.java:52)] - >>org.apache.kylin.rest.exception.InternalErrorException: Error >>instantiating JsonCustomSchema(name=DEFAULT) >>at >>org.apache.kylin.rest.controller.QueryController.doQuery(QueryController. >>j >>a >>va:227) >>at >>org.apache.kylin.rest.controller.QueryController.query(QueryController.ja >>v >>a >>:91) >>at >>org.apache.kylin.rest.controller.QueryController$$FastClassByCGLIB$$fc039 >>d >>0 >>b.invoke(<generated>) >>at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) >>at >>org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.in >>v >>o >>keJoinpoint(Cglib2AopProxy.java:689) >>at >>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl >>e >>c >>tiveMethodInvocation.java:150) >>at >>com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodIn >>t >>e >>rceptor.java:48) >>at >>com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodIn >>t >>e >>rceptor.java:34) >>at >>com.ryantenney.metrics.spring.AbstractMetricMethodInterceptor.invoke(Abst >>r >>a >>ctMetricMethodInterceptor.java:59) >>at >>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl >>e >>c >>tiveMethodInvocation.java:172) >>at >>org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedIntercepto >>r >>. >>intercept(Cglib2AopProxy.java:622) >>at >>org.apache.kylin.rest.controller.QueryController$$EnhancerByCGLIB$$f3810f >>9 >>1 >>.query(<generated>) >>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>at >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java >>: >>5 >>7) >>at >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI >>m >>p >>l.java:43) >>at java.lang.reflect.Method.invoke(Method.java:606) >>at >>org.springframework.web.method.support.InvocableHandlerMethod.invoke(Invo >>c >>a >>bleHandlerMethod.java:213) >>at >>org.springframework.web.method.support.InvocableHandlerMethod.invokeForRe >>q >>u >>est(InvocableHandlerMethod.java:126) >>at >>org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHan >>d >>l >>erMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) >>at >>org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandl >>e >>r >>Adapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) >>at >>org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandl >>e >>r >>Adapter.handleInternal(RequestMappingHandlerAdapter.java:578) >>at >>org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.h >>a >>n >>dle(AbstractHandlerMethodAdapter.java:80) >>at >>org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherSe >>r >>v >>let.java:923) >>at >>org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSer >>v >>l >>et.java:852) >>at >>org.springframework.web.servlet.FrameworkServlet.processRequest(Framework >>S >>e >>rvlet.java:882) >>at >>org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet. >>j >>a >>va: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(Applicat >>i >>o >>nFilterChain.java:303) >>at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte >>r >>C >>hain.java:208) >>at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >>at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat >>i >>o >>nFilterChain.java:241) >>at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte >>r >>C >>hain.java:208) >>at >>com.codahale.metrics.servlet.AbstractInstrumentedFilter.doFilter(Abstract >>I >>n >>strumentedFilter.java:97) >>at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat >>i >>o >>nFilterChain.java:241) >>at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte >>r >>C >>hain.java:208) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:330) >>at >>org.springframework.security.web.access.intercept.FilterSecurityIntercept >>o >>r >>.invoke(FilterSecurityInterceptor.java:118) >>at >>org.springframework.security.web.access.intercept.FilterSecurityIntercept >>o >>r >>.doFilter(FilterSecurityInterceptor.java:84) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.access.ExceptionTranslationFilter.doFilt >>e >>r >>(ExceptionTranslationFilter.java:113) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.session.SessionManagementFilter.doFilter >>( >>S >>essionManagementFilter.java:103) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.authentication.AnonymousAuthenticationFi >>l >>t >>er.doFilter(AnonymousAuthenticationFilter.java:113) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.servletapi.SecurityContextHolderAwareReq >>u >>e >>stFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doF >>i >>l >>ter(RequestCacheAwareFilter.java:45) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.authentication.www.BasicAuthenticationFi >>l >>t >>er.doFilter(BasicAuthenticationFilter.java:201) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.authentication.ui.DefaultLoginPageGenera >>t >>i >>ngFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.authentication.AbstractAuthenticationPro >>c >>e >>ssingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.authentication.logout.LogoutFilter.doFil >>t >>e >>r(LogoutFilter.java:105) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.context.SecurityContextPersistenceFilter >>. >>d >>oFilter(SecurityContextPersistenceFilter.java:87) >>at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFi >>l >>t >>er(FilterChainProxy.java:342) >>at >>org.springframework.security.web.FilterChainProxy.doFilterInternal(Filter >>C >>h >>ainProxy.java:192) >>at >>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainPro >>x >>y >>.java:160) >>at >>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Deleg >>a >>t >>ingFilterProxy.java:346) >>at >>org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingF >>i >>l >>terProxy.java:259) >>at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat >>i >>o >>nFilterChain.java:241) >>at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte >>r >>C >>hain.java:208) >>at >>com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:205) >>at >>com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) >>at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat >>i >>o >>nFilterChain.java:241) >>at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte >>r >>C >>hain.java:208) >>at >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve >>. >>j >>ava:220) >>at >>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve >>. >>j >>ava:122) >>at >>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorB >>a >>s >>e.java:504) >>at >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: >>1 >>7 >>0) >>at >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: >>1 >>0 >>3) >>at >>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >>at >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j >>a >>v >>a:116) >>at >>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:42 >>1 >>) >>at >>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Pr >>o >>c >>essor.java:1074) >>at >>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(Abst >>r >>a >>ctProtocol.java:611) >>at >>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.ja >>v >>a >>:314) >>at >>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java >>: >>1 >>145) >>at >>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.jav >>a >>: >>615) >>at >>org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread >>. >>j >>ava:61) >>at java.lang.Thread.run(Thread.java:745) >> >> >> >> >>Best Regards >>Gaurav Nigam >>+1 (973) 307-5307 >> >> >> >> >>On 5/11/15, 10:48 PM, "Shi, Shaofeng" <[email protected]> wrote: >> >>>I guess there is detail error message in the $KYLIN_HOME/logs/kylin.log >>>; >>>Could you please copy and paste the error track for us? Thanks! >>> >>>On 5/12/15, 10:37 AM, "Gaurav Nigam" <[email protected]> wrote: >>> >>>>I’m following below tutorial link and executed the query mentioned >>>>there >>>>- >>>>https://github.com/apache/incubator-kylin/blob/master/docs/Tutorial/Qui >>>>c >>>>k >>>>% >>>>2 >>>>0play%20with%20a%20sample%20cube.md >>>> >>>> >>>>But, it throws following error: “Error instantiating >>>>JsonCustomSchema(name=DEFAULT)” >>>> >>>>I ran it on following browsers- >>>>Chrome Version 42.0.2311.135 (64-bit) >>>>Firefox 37.0.2 >>>> >>>>PS - Attached is error screenshot >>>> >>>>Best Regards >>>>Gaurav Nigam >>>>+1 (973) 307-5307 >>>> >>>> >>>> >>>> >>>>On 5/11/15, 10:23 PM, "Shi, Shaofeng" <[email protected]> wrote: >>>> >>>>>Are you able to execute a SQL query and get result set there? BTW, >>>>>what’s >>>>>your browser and version, did you try another like Chrome? Is there >>>>>any >>>>>JS >>>>>error in the browser console? I’m wondering it is a front-end or >>>>>back-end >>>>>issue. >>>>> >>>>>On 5/12/15, 9:30 AM, "Gaurav Nigam" <[email protected]> wrote: >>>>> >>>>>>Thanks for your response. >>>>>> >>>>>>Yes, I just did that, but it didn¹t worked either. >>>>>> >>>>>>PS - I¹m attaching screenshots for reference. >>>>>> >>>>>>Best Regards >>>>>>Gaurav Nigam >>>>>>+1 (973) 307-5307 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>On 5/11/15, 9:16 PM, "Shi, Shaofeng" <[email protected]> wrote: >>>>>> >>>>>>>Hi Saswata, >>>>>>> >>>>>>>Did you try to restart the Kylin instance? If the tables are >>>>>>>appeared >>>>>>>after a restart, that would indicate a cache problem; >>>>>>> >>>>>>>On 5/12/15, 1:02 AM, "Saswata Sengupta" <[email protected]> >>>>>>>wrote: >>>>>>> >>>>>>>>?Hi, >>>>>>>> >>>>>>>> >>>>>>>>We have installed Kylin in a 3 node Hadoop Cluster(cloudera >>>>>>>>distribution) >>>>>>>>and wanted to test the product. While we are able to successfully >>>>>>>>build >>>>>>>>the cubes, but while trying to Query the Query section shows no >>>>>>>>table >>>>>>>>definition. >>>>>>>> >>>>>>>> >>>>>>>>We tried many different ways including the sample script, but the >>>>>>>>table >>>>>>>>defination which should appear on the left panel of the Query tab >>>>>>>>after >>>>>>>>the cube is built is not available. We confirmed that in HBase the >>>>>>>>cube >>>>>>>>table is there and measured its size. >>>>>>>> >>>>>>>> >>>>>>>>Can anyone please help ? >>>>>>>> >>>>>>>> >>>>>>>>P.S. - We previously tried on a single node VM and it worked >>>>>>>>without >>>>>>>>any >>>>>>>>glitch. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>Best Regards >>>>>>>> >>>>>>>>Saswata Sengupta >>>>>>>> >>>>>>>>Mobile :732-210-7277 >>>>>>>> 646-262-5093 >>>>>>>> >>>>>>>>________________________________ >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>NOTE: This message may contain information that is confidential, >>>>>>>>proprietary, privileged or otherwise protected by law. The message >>>>>>>>is >>>>>>>>intended solely for the named addressee. If received in error, >>>>>>>>please >>>>>>>>destroy and notify the sender. Any use of this email is prohibited >>>>>>>>when >>>>>>>>received in error. Impetus does not represent, warrant and/or >>>>>>>>guarantee, >>>>>>>>that the integrity of this communication has been maintained nor >>>>>>>>that >>>>>>>>the >>>>>>>>communication is free of errors, virus, interception or >>>>>>>>interference. >>>>>>> >>>>>> >>>>>> >>>>>>________________________________ >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>NOTE: This message may contain information that is confidential, >>>>>>proprietary, privileged or otherwise protected by law. The message is >>>>>>intended solely for the named addressee. If received in error, please >>>>>>destroy and notify the sender. Any use of this email is prohibited >>>>>>when >>>>>>received in error. Impetus does not represent, warrant and/or >>>>>>guarantee, >>>>>>that the integrity of this communication has been maintained nor that >>>>>>the >>>>>>communication is free of errors, virus, interception or interference. >>>>> >>>> >>>> >>>>________________________________ >>>> >>>> >>>> >>>> >>>> >>>> >>>>NOTE: This message may contain information that is confidential, >>>>proprietary, privileged or otherwise protected by law. The message is >>>>intended solely for the named addressee. If received in error, please >>>>destroy and notify the sender. Any use of this email is prohibited when >>>>received in error. Impetus does not represent, warrant and/or >>>>guarantee, >>>>that the integrity of this communication has been maintained nor that >>>>the >>>>communication is free of errors, virus, interception or interference. >>> >> >> >>________________________________ >> >> >> >> >> >> >>NOTE: This message may contain information that is confidential, >>proprietary, privileged or otherwise protected by law. The message is >>intended solely for the named addressee. If received in error, please >>destroy and notify the sender. Any use of this email is prohibited when >>received in error. Impetus does not represent, warrant and/or guarantee, >>that the integrity of this communication has been maintained nor that the >>communication is free of errors, virus, interception or interference. >
