Hi, Glad to hear you that you have fix previous issue and thank you for your update, that is great. For the AWS Glue support with Kylin, that feature will be introduced in future release(should be 3.0.2 and 3.1.0), please check https://issues.apache.org/jira/browse/KYLIN-4206, the doc https://kylin.apache.org/docs31/install/kylin_aws_emr.html is for Kylin 3.1, and it is not released yet.
For now, you can build binary package from master branch and do a test, this is my https://github.com/hit-lacus/hit-lacus.github.io/issues/81 . Besides, another committer Kaige has another suggestion(but I didn't test it), you can check it: https://issues.apache.org/jira/browse/KYLIN-3685 . -- Best wishes to you ! From :Xiaoxiang Yu At 2020-04-10 05:29:04, "mvishnubhatta" <mvishnubha...@argusinformation.com> wrote: >Hi, > >I am trying to set up Kylin on an EMR cluster (trying both on a master node >and on an edge node). While the GUI shows up, I get a "Cannot get >HiveTableMeta" error when trying to load a hive table. > >The hive metastore is AWS Glue. > >Curiously, the most recent version of the document ><https://kylin.apache.org/docs/install/kylin_aws_emr.html> does not say >anything about Glue) > >Looking at an older version of the document ><https://kylin.apache.org/docs31/install/kylin_aws_emr.html> , I tried the >following: > >cp /usr/lib/hive/auxlib/aws-glue-datacatalog-hive2-client.jar >$KYLIN_HOME/lib/ >cp >/usr/share/aws/hmclient/lib/aws-glue-datacatalog-client-common-1.11.0-SNAPSHOT.jar >$KYLIN_HOME/lib/ >#Modify kylin.properties to uncomment the entry >kylin.source.hive.client=cli >#Modify kylin.properties to add an entry that says >kylin.source.hive.metadata-type=gluecatalog > >But I still get the same error on the GUI. > >I feel this Kylin server is not even aware that Glue is the hive catalog >since I cannot find any reference to Glue in any of the logs or error >messages. > >Any ideas on how to set up the hive metastore correctly? > >Hadoop version is Hadoop 2.8.5-amzn-4 >Kylin version is 3.0.1 >Hive 2.3.5-amzn-0 > >I exported the following variables: >export KYLIN_HOME=/usr/local/kylin/apache-kylin-3.0.1-bin-hbase1x >#export HADOOP_HOME=/usr/lib/hadoop/etc/hadoop >export HADOOP_HOME=/usr/lib/hadoop >export HBASE_HOME=/usr/lib/hbase/ >export HIVE_HOME=/usr/lib/hive/ >export HADOOP_CONF_DIR=/etc/hadoop/conf >export HIVE_LIB=/usr/lib/hive/lib >export HIVE_CONF=/etc/hive/conf >export HCAT_HOME=/usr/lib/hive-hcatalog > >The kylin.log file throws this error: >2020-04-09 21:17:21,243 ERROR [http-bio-7070-exec-1] >controller.TableController:130 : Failed to load Hive Table >java.lang.RuntimeException: cannot get HiveTableMeta > at >org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:68) > at >org.apache.kylin.rest.service.TableService.extractHiveTableMeta(TableService.java:211) > at >org.apache.kylin.rest.service.TableService.loadHiveTablesToProject(TableService.java:137) > at >org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:114) > 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.doInvoke(InvocableHandlerMethod.java:205) > at >org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) > at >org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at >org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at >org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at >org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at >org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at >org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at >org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at >org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at >org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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:317) > at >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) > at >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) > at >org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) > at >org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) > at >org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) > 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:219) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) > at >org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) > at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) > at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) > at >org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) > at >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) > at >org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) > at >org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) > at >org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at >java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at >java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at >org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:748) >Caused by: NoSuchObjectException(message:DEFAULT.test_emr_from_airflow table >not found) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result$get_table_req_resultStandardScheme.read(ThriftHiveMetastore.java:55064) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result$get_table_req_resultStandardScheme.read(ThriftHiveMetastore.java:55032) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result.read(ThriftHiveMetastore.java:54963) > at >org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550) > at >org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344) > at >org.apache.kylin.source.hive.CLIHiveClient.getHiveTableMeta(CLIHiveClient.java:79) > at >org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:66) > ... 79 more >2020-04-09 21:17:21,249 ERROR [http-bio-7070-exec-1] >controller.BasicController:63 : >org.apache.kylin.rest.exception.InternalErrorException: cannot get >HiveTableMeta > at >org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:131) > 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.doInvoke(InvocableHandlerMethod.java:205) > at >org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) > at >org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at >org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at >org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at >org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at >org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at >org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at >org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at >org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at >org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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:317) > at >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) > at >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) > at >org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) > at >org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) > at >org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) > 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:219) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) > at >org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) > at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) > at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) > at >org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) > at >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) > at >org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) > at >org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) > at >org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at >java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at >java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at >org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:748) >Caused by: java.lang.RuntimeException: cannot get HiveTableMeta > at >org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:68) > at >org.apache.kylin.rest.service.TableService.extractHiveTableMeta(TableService.java:211) > at >org.apache.kylin.rest.service.TableService.loadHiveTablesToProject(TableService.java:137) > at >org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:114) > ... 76 more >Caused by: NoSuchObjectException(message:DEFAULT.test_emr_from_airflow table >not found) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result$get_table_req_resultStandardScheme.read(ThriftHiveMetastore.java:55064) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result$get_table_req_resultStandardScheme.read(ThriftHiveMetastore.java:55032) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result.read(ThriftHiveMetastore.java:54963) > at >org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550) > at >org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344) > at >org.apache.kylin.source.hive.CLIHiveClient.getHiveTableMeta(CLIHiveClient.java:79) > at >org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:66) > ... 79 more >2020-04-09 21:17:48,986 INFO [FetcherRunner 1782733336-47] >threadpool.DefaultFetcherRunner:111 : Job Fetcher: 0 should running, 0 >actual running, 0 stopped, 0 ready, 0 already succeed, 0 error, 0 discarded, >0 others >2020-04-09 21:18:12,474 ERROR [http-bio-7070-exec-2] >controller.TableController:130 : Failed to load Hive Table >java.lang.RuntimeException: cannot get HiveTableMeta > at >org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:68) > at >org.apache.kylin.rest.service.TableService.extractHiveTableMeta(TableService.java:211) > at >org.apache.kylin.rest.service.TableService.loadHiveTablesToProject(TableService.java:137) > at >org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:114) > 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.doInvoke(InvocableHandlerMethod.java:205) > at >org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) > at >org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at >org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at >org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at >org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at >org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at >org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at >org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at >org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at >org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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:317) > at >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) > at >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) > at >org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) > at >org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) > at >org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) > 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:219) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) > at >org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) > at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) > at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) > at >org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) > at >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) > at >org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) > at >org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) > at >org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at >java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at >java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at >org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:748) >Caused by: NoSuchObjectException(message:DEFAULT.test_emr_from_airflow table >not found) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result$get_table_req_resultStandardScheme.read(ThriftHiveMetastore.java:55064) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result$get_table_req_resultStandardScheme.read(ThriftHiveMetastore.java:55032) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result.read(ThriftHiveMetastore.java:54963) > at >org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550) > at >org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344) > at >org.apache.kylin.source.hive.CLIHiveClient.getHiveTableMeta(CLIHiveClient.java:79) > at >org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:66) > ... 79 more >2020-04-09 21:18:12,476 ERROR [http-bio-7070-exec-2] >controller.BasicController:63 : >org.apache.kylin.rest.exception.InternalErrorException: cannot get >HiveTableMeta > at >org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:131) > 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.doInvoke(InvocableHandlerMethod.java:205) > at >org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) > at >org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at >org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at >org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at >org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at >org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at >org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at >org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at >org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > at >org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > 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:317) > at >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) > at >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) > at >org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) > at >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at >org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) > at >org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) > at >org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) > at >org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) > 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:219) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) > at >org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) > at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) > at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) > at >org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) > at >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) > at >org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) > at >org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) > at >org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at >java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at >java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at >org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:748) >Caused by: java.lang.RuntimeException: cannot get HiveTableMeta > at >org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:68) > at >org.apache.kylin.rest.service.TableService.extractHiveTableMeta(TableService.java:211) > at >org.apache.kylin.rest.service.TableService.loadHiveTablesToProject(TableService.java:137) > at >org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:114) > ... 76 more >Caused by: NoSuchObjectException(message:DEFAULT.test_emr_from_airflow table >not found) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result$get_table_req_resultStandardScheme.read(ThriftHiveMetastore.java:55064) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result$get_table_req_resultStandardScheme.read(ThriftHiveMetastore.java:55032) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_req_result.read(ThriftHiveMetastore.java:54963) > at >org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563) > at >org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550) > at >org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344) > at >org.apache.kylin.source.hive.CLIHiveClient.getHiveTableMeta(CLIHiveClient.java:79) > at >org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:66) > ... 79 more > > > >-- >Sent from: http://apache-kylin.74782.x6.nabble.com/