Re: when I saved queries,having exception "Table 'kylin_metadata_user' was not found"
I guess you're running in the "testing" profile (kylin.properties, " kylin.security.profile=testing") Switch to LDAP authentication will enable the "save query" feature. But throw this error is confusing, Kylin should fix it. Would you mind to open a JIAR? 2016-05-27 17:44 GMT+08:00 boboqiu <1988...@163.com>: > hello, > I made a query in the kylin UI,when saved the query ,the exception is > below: > table "kyliin_metdata_user" was not found. > I looked up tables in hbase,there was kylin_metadata . > if I have to make the table "kyliin_metdata_user",and what's the > description of the table. > > thank you! > > 2016-05-27 17:08:18,176 ERROR [http-bio-7070-exec-8] > controller.BasicController:44 : > org.apache.hadoop.hbase.TableNotFoundException: Table 'kylin_metadata_user' > was not found, got: kylin_metadata. > at > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1274) > at > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1155) > at > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1139) > at > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1096) > at > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:931) > at > > org.apache.hadoop.hbase.client.HRegionLocator.getRegionLocation(HRegionLocator.java:83) > at > > org.apache.hadoop.hbase.client.RegionServerCallable.prepare(RegionServerCallable.java:79) > at > > org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:124) > at org.apache.hadoop.hbase.client.HTable.get(HTable.java:879) > at org.apache.hadoop.hbase.client.HTable.get(HTable.java:845) > at > > org.apache.kylin.rest.service.QueryService.getQueries(QueryService.java:189) > at > > org.apache.kylin.rest.service.QueryService$$FastClassByCGLIB$$4957273f.invoke() > at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) > at > > org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618) > at > > org.apache.kylin.rest.service.QueryService$$EnhancerByCGLIB$$146ca8ac.getQueries() > at > > org.apache.kylin.rest.controller.QueryController.getQueries(QueryController.java:124) > 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:498) > 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.doGet(FrameworkServlet.java:778) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) > 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.spring
Re: when I saved queries,having exception "Table 'kylin_metadata_user' was not found"
Hi, We have jira tracking this. https://issues.apache.org/jira/browse/KYLIN-1499 On Sat, May 28, 2016 at 11:06 AM, ShaoFeng Shi wrote: > I guess you're running in the "testing" profile (kylin.properties, " > kylin.security.profile=testing") > > Switch to LDAP authentication will enable the "save query" feature. But > throw this error is confusing, Kylin should fix it. Would you mind to open > a JIAR? > > 2016-05-27 17:44 GMT+08:00 boboqiu <1988...@163.com>: > > > hello, > > I made a query in the kylin UI,when saved the query ,the exception > is > > below: > > table "kyliin_metdata_user" was not found. > > I looked up tables in hbase,there was kylin_metadata . > > if I have to make the table "kyliin_metdata_user",and what's the > > description of the table. > > > > thank you! > > > > 2016-05-27 17:08:18,176 ERROR [http-bio-7070-exec-8] > > controller.BasicController:44 : > > org.apache.hadoop.hbase.TableNotFoundException: Table > 'kylin_metadata_user' > > was not found, got: kylin_metadata. > > at > > > > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1274) > > at > > > > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1155) > > at > > > > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1139) > > at > > > > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1096) > > at > > > > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:931) > > at > > > > > org.apache.hadoop.hbase.client.HRegionLocator.getRegionLocation(HRegionLocator.java:83) > > at > > > > > org.apache.hadoop.hbase.client.RegionServerCallable.prepare(RegionServerCallable.java:79) > > at > > > > > org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:124) > > at org.apache.hadoop.hbase.client.HTable.get(HTable.java:879) > > at org.apache.hadoop.hbase.client.HTable.get(HTable.java:845) > > at > > > > > org.apache.kylin.rest.service.QueryService.getQueries(QueryService.java:189) > > at > > > > > org.apache.kylin.rest.service.QueryService$$FastClassByCGLIB$$4957273f.invoke() > > at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) > > at > > > > > org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618) > > at > > > > > org.apache.kylin.rest.service.QueryService$$EnhancerByCGLIB$$146ca8ac.getQueries() > > at > > > > > org.apache.kylin.rest.controller.QueryController.getQueries(QueryController.java:124) > > 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:498) > > 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.doGet(FrameworkServlet.java:778) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) > > 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.webs
Re: when I saved queries,having exception "Table 'kylin_metadata_user' was not found"
Thank you for your apply. The version of the kylin I use is 1.5.2 -- View this message in context: http://apache-kylin.74782.x6.nabble.com/when-I-saved-queries-having-exception-Table-kylin-metadata-user-was-not-found-tp4745p4754.html Sent from the Apache Kylin mailing list archive at Nabble.com.