It is just for a demo; Most time of the 10 minutes were spent on creating Hive flat table and waiting on MR scheduling; When you build a real cube on huge data set, the waiting time will be a small ratio;
On 7/27/15, 9:56 PM, "Siddharth Ubale" <[email protected]> wrote: >Hi, > >I am creating my first cube after running sample.sh ... thanks a lot for >all ur inputs... but does it really take around 10 mins to build the >sample cube?? >How are we assessing the latency factor in such a scenario? > >-----Original Message----- >From: Shi, Shaofeng [mailto:[email protected]] >Sent: Monday, July 27, 2015 7:20 PM >To: [email protected] >Subject: Re: Kylin+HIve > >Did you run $KYLIN_HOME/bin/sample.sh to create the sample tables and >what’s the result? Do you see the same error when using hive client as >below? > >hive -e "describe kylin_sales;" > >On 7/27/15, 7:19 PM, "Siddharth Ubale" <[email protected]> >wrote: > >>The log relevant to my issue is here : >> >>1. I can see it is connected to meatstor. >>2. But unable to pull data. >>3. Do I need to make any specific setup in kylin.properties file? >> >> >>2015-07-27 16:21:38,760 INFO [http-bio-7070-exec-8] hive.metastore: >>Connected to metastore. >>NoSuchObjectException(message:"DEFAULT.KYLIN_SALES" table not found) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_resu >>lt$ >>get_table_resultStandardScheme.read(ThriftHiveMetastore.java:35066) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_resu >>lt$ >>get_table_resultStandardScheme.read(ThriftHiveMetastore.java:35034) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_result >>. >>read(ThriftHiveMetastore.java:34965) >> at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_ge >>t_t >>able(ThriftHiveMetastore.java:1218) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_tab >>le( >>ThriftHiveMetastore.java:1204) >> at >>org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaS >>tor >>eClient.java:1208) >> at >>org.apache.kylin.common.util.HiveClient.getHiveTable(HiveClient.java:117) >> at >>org.apache.kylin.metadata.tool.HiveSourceTableLoader.extractHiveTables( >>Hiv >>eSourceTableLoader.java:87) >> at >>org.apache.kylin.metadata.tool.HiveSourceTableLoader.reloadHiveTables(H >>ive >>SourceTableLoader.java:70) >> at >>org.apache.kylin.rest.service.CubeService.reloadHiveTable(CubeService.j >>ava >>:540) >> at >>org.apache.kylin.rest.service.CubeService$$FastClassByCGLIB$$17a07c0e.i >>nvo >>ke(<generated>) >> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) >> at >>org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation. >>inv >>okeJoinpoint(Cglib2AopProxy.java:689) >> at >>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Re >>fle >>ctiveMethodInvocation.java:150) >> at >>org.springframework.security.access.intercept.aopalliance.MethodSecurit >>yIn >>terceptor.invoke(MethodSecurityInterceptor.java:64) >> at >>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Re >>fle >>ctiveMethodInvocation.java:172) >> at >>org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedIntercep >>tor >>.intercept(Cglib2AopProxy.java:622) >> at >>org.apache.kylin.rest.service.CubeService$$EnhancerByCGLIB$$1d01d327.re >>loa >>dHiveTable(<generated>) >> at >>org.apache.kylin.rest.controller.TableController.loadHiveTable(TableCon >>tro >>ller.java:113) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java >>: >>62) >> at >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso >>rIm >>pl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:497) >> at >>org.springframework.web.method.support.InvocableHandlerMethod.invoke(In >>voc >>ableHandlerMethod.java:213) >> at >>org.springframework.web.method.support.InvocableHandlerMethod.invokeFor >>Req >>uest(InvocableHandlerMethod.java:126) >> at >>org.springframework.web.servlet.mvc.method.annotation.ServletInvocableH >>and >>lerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) >> at >>org.springframework.web.servlet.mvc.method.annotation.RequestMappingHan >>dle >>rAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) >> at >>org.springframework.web.servlet.mvc.method.annotation.RequestMappingHan >>dle >>rAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) >> at >>org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter >>.ha >>ndle(AbstractHandlerMethodAdapter.java:80) >> at >>org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatcher >>Ser >>vlet.java:923) >> at >>org.springframework.web.servlet.DispatcherServlet.doService(DispatcherS >>erv >>let.java:852) >> at >>org.springframework.web.servlet.FrameworkServlet.processRequest(Framewo >>rkS >>ervlet.java:882) >> at >>org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServle >>t.j >>ava: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(Applic >>ati >>onFilterChain.java:303) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.java:208) >> at >>org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >>ati >>onFilterChain.java:241) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.java:208) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:330) >> at >>org.springframework.security.web.access.intercept.FilterSecurityInterce >>pto >>r.invoke(FilterSecurityInterceptor.java:118) >> at >>org.springframework.security.web.access.intercept.FilterSecurityInterce >>pto >>r.doFilter(FilterSecurityInterceptor.java:84) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.access.ExceptionTranslationFilter.doFi >>lte >>r(ExceptionTranslationFilter.java:113) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.session.SessionManagementFilter.doFilt >>er( >>SessionManagementFilter.java:103) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.AnonymousAuthentication >>Fil >>ter.doFilter(AnonymousAuthenticationFilter.java:113) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.servletapi.SecurityContextHolderAwareR >>equ >>estFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.d >>oFi >>lter(RequestCacheAwareFilter.java:45) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.www.BasicAuthentication >>Fil >>ter.doFilter(BasicAuthenticationFilter.java:150) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.ui.DefaultLoginPageGene >>rat >>ingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.AbstractAuthenticationP >>roc >>essingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.logout.LogoutFilter.doF >>ilt >>er(LogoutFilter.java:105) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.context.SecurityContextPersistenceFilter >>. >>doFilter(SecurityContextPersistenceFilter.java:87) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.FilterChainProxy.doFilterInternal(Filt >>erC >>hainProxy.java:192) >> at >>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainP >>rox >>y.java:160) >> at >>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Del >>ega >>tingFilterProxy.java:346) >> at >>org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegatin >>gFi >>lterProxy.java:259) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >>ati >>onFilterChain.java:241) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.java:208) >> at >>org.apache.kylin.rest.filter.KylinApiFilter.doFilterInternal(KylinApiFi >>lte >>r.java:64) >> at >>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerReq >>ues >>tFilter.java:76) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >>ati >>onFilterChain.java:241) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.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(Applic >>ati >>onFilterChain.java:241) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.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(Authenticato >>rBa >>se.java:504) >> at >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav >>a:1 >>70) >> at >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav >>a:1 >>03) >> at >>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> at >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve >>.ja >>va:116) >> at >>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: >>421 >>) >> at >>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11 >>Pro >>cessor.java:1074) >> at >>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(Ab >>str >>actProtocol.java:611) >> at >>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint. >>jav >>a:314) >> at >>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java >>: >>1142) >> at >>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.j >>ava >>: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-8]:[2015-07-27 >>16:21:38,789][ERROR][org.apache.kylin.rest.controller.BasicController.h >>and >>leError(BasicController.java:48)] - >>java.io.IOException: NoSuchObjectException(message:"DEFAULT.KYLIN_SALES" >>table not found) >> at >>org.apache.kylin.metadata.tool.HiveSourceTableLoader.extractHiveTables( >>Hiv >>eSourceTableLoader.java:92) >> at >>org.apache.kylin.metadata.tool.HiveSourceTableLoader.reloadHiveTables(H >>ive >>SourceTableLoader.java:70) >> at >>org.apache.kylin.rest.service.CubeService.reloadHiveTable(CubeService.j >>ava >>:540) >> at >>org.apache.kylin.rest.service.CubeService$$FastClassByCGLIB$$17a07c0e.i >>nvo >>ke(<generated>) >> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) >> at >>org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation. >>inv >>okeJoinpoint(Cglib2AopProxy.java:689) >> at >>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Re >>fle >>ctiveMethodInvocation.java:150) >> at >>org.springframework.security.access.intercept.aopalliance.MethodSecurit >>yIn >>terceptor.invoke(MethodSecurityInterceptor.java:64) >> at >>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Re >>fle >>ctiveMethodInvocation.java:172) >> at >>org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedIntercep >>tor >>.intercept(Cglib2AopProxy.java:622) >> at >>org.apache.kylin.rest.service.CubeService$$EnhancerByCGLIB$$1d01d327.re >>loa >>dHiveTable(<generated>) >> at >>org.apache.kylin.rest.controller.TableController.loadHiveTable(TableCon >>tro >>ller.java:113) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java >>: >>62) >> at >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso >>rIm >>pl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:497) >> at >>org.springframework.web.method.support.InvocableHandlerMethod.invoke(In >>voc >>ableHandlerMethod.java:213) >> at >>org.springframework.web.method.support.InvocableHandlerMethod.invokeFor >>Req >>uest(InvocableHandlerMethod.java:126) >> at >>org.springframework.web.servlet.mvc.method.annotation.ServletInvocableH >>and >>lerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) >> at >>org.springframework.web.servlet.mvc.method.annotation.RequestMappingHan >>dle >>rAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) >> at >>org.springframework.web.servlet.mvc.method.annotation.RequestMappingHan >>dle >>rAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) >> at >>org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter >>.ha >>ndle(AbstractHandlerMethodAdapter.java:80) >> at >>org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatcher >>Ser >>vlet.java:923) >> at >>org.springframework.web.servlet.DispatcherServlet.doService(DispatcherS >>erv >>let.java:852) >> at >>org.springframework.web.servlet.FrameworkServlet.processRequest(Framewo >>rkS >>ervlet.java:882) >> at >>org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServle >>t.j >>ava: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(Applic >>ati >>onFilterChain.java:303) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.java:208) >> at >>org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >>ati >>onFilterChain.java:241) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.java:208) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:330) >> at >>org.springframework.security.web.access.intercept.FilterSecurityInterce >>pto >>r.invoke(FilterSecurityInterceptor.java:118) >> at >>org.springframework.security.web.access.intercept.FilterSecurityInterce >>pto >>r.doFilter(FilterSecurityInterceptor.java:84) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.access.ExceptionTranslationFilter.doFi >>lte >>r(ExceptionTranslationFilter.java:113) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.session.SessionManagementFilter.doFilt >>er( >>SessionManagementFilter.java:103) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.AnonymousAuthentication >>Fil >>ter.doFilter(AnonymousAuthenticationFilter.java:113) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.servletapi.SecurityContextHolderAwareR >>equ >>estFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.d >>oFi >>lter(RequestCacheAwareFilter.java:45) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.www.BasicAuthentication >>Fil >>ter.doFilter(BasicAuthenticationFilter.java:150) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.ui.DefaultLoginPageGene >>rat >>ingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.AbstractAuthenticationP >>roc >>essingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.authentication.logout.LogoutFilter.doF >>ilt >>er(LogoutFilter.java:105) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.context.SecurityContextPersistenceFilter >>. >>doFilter(SecurityContextPersistenceFilter.java:87) >> at >>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.do >>Fil >>ter(FilterChainProxy.java:342) >> at >>org.springframework.security.web.FilterChainProxy.doFilterInternal(Filt >>erC >>hainProxy.java:192) >> at >>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainP >>rox >>y.java:160) >> at >>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Del >>ega >>tingFilterProxy.java:346) >> at >>org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegatin >>gFi >>lterProxy.java:259) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >>ati >>onFilterChain.java:241) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.java:208) >> at >>org.apache.kylin.rest.filter.KylinApiFilter.doFilterInternal(KylinApiFi >>lte >>r.java:64) >> at >>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerReq >>ues >>tFilter.java:76) >> at >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic >>ati >>onFilterChain.java:241) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.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(Applic >>ati >>onFilterChain.java:241) >> at >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil >>ter >>Chain.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(Authenticato >>rBa >>se.java:504) >> at >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav >>a:1 >>70) >> at >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav >>a:1 >>03) >> at >>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> at >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve >>.ja >>va:116) >> at >>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: >>421 >>) >> at >>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11 >>Pro >>cessor.java:1074) >> at >>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(Ab >>str >>actProtocol.java:611) >> at >>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint. >>jav >>a:314) >> at >>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java >>: >>1142) >> at >>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.j >>ava >>:617) >> at >>org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread >>. >>java:61) >> at java.lang.Thread.run(Thread.java:745) >>Caused by: NoSuchObjectException(message:"DEFAULT.KYLIN_SALES" table >>not >>found) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_resu >>lt$ >>get_table_resultStandardScheme.read(ThriftHiveMetastore.java:35066) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_resu >>lt$ >>get_table_resultStandardScheme.read(ThriftHiveMetastore.java:35034) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_result >>. >>read(ThriftHiveMetastore.java:34965) >> at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_ge >>t_t >>able(ThriftHiveMetastore.java:1218) >> at >>org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_tab >>le( >>ThriftHiveMetastore.java:1204) >> at >>org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaS >>tor >>eClient.java:1208) >> at >>org.apache.kylin.common.util.HiveClient.getHiveTable(HiveClient.java:117) >> at >>org.apache.kylin.metadata.tool.HiveSourceTableLoader.extractHiveTables( >>Hiv >>eSourceTableLoader.java:87) >> ... 85 more >>[http-bio-7070-exec-8]:[2015-07-27 >>16:21:38,792][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logReq >>ues t(KylinApiFilter.java:118)] - REQUEST: REQUESTER=ADMIN;REQ_TIME=PDT >>2015-07-27 >>03:51:38;URI=/kylin/api/tables/%22DEFAULT.KYLIN_SALES%22/one;METHOD=POS >>T;Q UERY_STRING=null;PAYLOAD=;RESP_STATUS=500; >> >> >> >>Thanks, >>Siddharth >>-----Original Message----- >>From: [email protected] [mailto:[email protected]] >>Sent: Monday, July 27, 2015 4:33 PM >>To: dev <[email protected]> >>Subject: Re: RE: Kylin+HIve >> >>Hi Siddharth >> >>What you see from kylin.log ? >> >> >> >> >>[email protected] >> >>From: Siddharth Ubale >>Date: 2015-07-27 18:29 >>To: [email protected] >>Subject: RE: Kylin+HIve >>I am unable to load the tables from hive. I can see the tables , but >>when I sync and try to load the tables kylin says njo object found. >>IN the beginning when I ran bin/sample.sh ,kylin created the tablesin >>hive.. but now it is not able to load these. >>Any inputs? >> >> >> >>-----Original Message----- >>From: Shi, Shaofeng [mailto:[email protected]] >>Sent: Monday, July 27, 2015 12:15 PM >>To: [email protected] >>Subject: Re: Kylin+HIve >> >>Hi Ubale, that is transparent to Kylin, it is not mandatory to >>configure remote mode in hive; >> >>On 7/27/15, 2:33 PM, "Siddharth Ubale" <[email protected]> >>wrote: >> >>>Hi , >>> >>>Does kylin work with hive when its configured for embedded metastore >>>or do I need to configure metastore in remote for using kylin with it? >>> >>> >>>Siddharth Ubale, >>>Synchronized Communications >>> >>> >> >
