have you successfully build the "kylin_sales" cube? 2016-05-06 10:17 GMT+08:00 [email protected] <[email protected]>:
> > My environmental information is hdp (version 2.3.2): > hadoop 2.7.1 > hbase 1.1 > hive 1.2 > > So I chose the apache-kylin-1.5.1-HBase1.1.3-bin.tar.gz to install,But > the installation is complete in the interface query failed，the sql > is：select * from KYLIN_CAL_DT LIMIT 50000 > interface error is： > Error while executing SQL "select * from KYLIN_CAL_DT LIMIT 50000": From > line 1, column 16 to line 1, column 27: Table 'KYLIN_CAL_DT' not found > > the kylin.log error is： > 2016-05-06 10:06:27,365 INFO [http-bio-7070-exec-10] service.QueryService: > ==========================[QUERY]=============================== > SQL: select * from KYLIN_CAL_DT > User: ADMIN > Success: false > Duration: 0.0 > Project: learn_kylin > Realization Names: [] > Cuboid Ids: [] > Total scan count: 0 > Result row count: 0 > Accept Partial: true > Is Partial Result: false > Hit Exception Cache: false > Storage cache used: false > Message: Error while executing SQL "select * from KYLIN_CAL_DT LIMIT > 50000": From line 1, column 16 to line 1, column 27: Table 'KYLIN_CAL_DT' > not found > ==========================[QUERY]=============================== > > 2016-05-06 10:06:27,365 ERROR [http-bio-7070-exec-10] > controller.BasicController: > org.apache.kylin.rest.exception.InternalErrorException: Error while > executing SQL "select * from KYLIN_CAL_DT LIMIT 50000": From line 1, > column 16 to line 1, column 27: Table 'KYLIN_CAL_DT' not found > at > org.apache.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213) > at > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) > at > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) > at > org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) > at > org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) > at > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) > at > org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:195) > at > com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:745) > > I am in the interface of the menu Model>Data Source can find the > KYLIN_CAL_DT table and can see the table structure > > my kylin.properties is: > > hive.url=jdbc:hive2://192.168.1.12:10000 > hive.user="" > hive.password="" > # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. > # See the License for the specific language governing permissions and > # limitations under the License. > # > crossdomain.enable=false > # kylin server's mode > kylin.server.mode=all > > # optional information for the owner of kylin platform, it can be your > team's email > # currently it will be attached to each kylin's htable attribute > [email protected] > > # List of web servers in use, this enables one web server instance to sync > up with other servers. > kylin.rest.servers=192.168.1.12:7070 > > # The metadata store in hbase > kylin.metadata.url=kylin_metadata@hbase > > # The storage for final cube file in hbase > kylin.storage.url=hbase > > # Temp folder in hdfs, make sure user has the right access to the hdfs > directory > kylin.hdfs.working.dir=/kylin > kylin.job.yarn.app.rest.check.status.url= > http://spark04:8088/ws/v1/cluster/apps/${job_id}? > kylin.job.yarn.app.rest.check.interval.seconds=20 > > # HBase Cluster FileSystem, which serving hbase, format as > hdfs://hbase-cluster:8020 > # leave empty if hbase running on same cluster with hive and mapreduce > > kylin.hbase.cluster.fs=hdfs://spark01:8020/apps/hbase/data_new > kylin.route.hive.enabled=true > #kylin.hive.keep.flat.table=true > kylin.route.hive.url=jdbc:hive2://192.168.1.12:10000 > kylin.job.mapreduce.default.reduce.input.mb=500 > kylin.query.run.local.coprocessor = true > kylin.query.cache.threshold.duration=2000 > kylin.query.cache.threshold.scancount=10240 > kylin.hive.beeline.params=-n root --hiveconf > hive.security.authorization.sqlstd.confwhitelist.append='mapreduce.job.*|dfs.*' > -u 'jdbc:hive2://192.168.1.12:10000' > # max job retry on error, default 0: no retry > kylin.job.retry=0 > > # If true, job engine will not assume that hadoop CLI reside on the same > server as it self > # you will have to specify kylin.job.remote.cli.hostname, > kylin.job.remote.cli.username and kylin.job.remote.cli.password > # It should not be set to "true" unless you're NOT running Kylin.sh on a > hadoop client machine > # (Thus kylin instance has to ssh to another real hadoop client machine to > execute hbase,hive,hadoop commands) > kylin.job.run.as.remote.cmd=false > > # Only necessary when kylin.job.run.as.remote.cmd=true > kylin.job.remote.cli.hostname= > > # Only necessary when kylin.job.run.as.remote.cmd=true > kylin.job.remote.cli.username= > > # Only necessary when kylin.job.run.as.remote.cmd=true > kylin.job.remote.cli.password= > > # Used by test cases to prepare synthetic data for sample cube > kylin.job.remote.cli.working.dir=/tmp/kylin > > # Max count of concurrent jobs running > kylin.job.concurrent.max.limit=10 > > # Time interval to check hadoop job status > kylin.job.yarn.app.rest.check.interval.seconds=10 > > # Hive database name for putting the intermediate flat tables > kylin.job.hive.database.for.intermediatetable=default > > #default compression codec for htable,snappy,lzo,gzip,lz4 > kylin.hbase.default.compression.codec=snappy > > #the percentage of the sampling, default 100% > kylin.job.cubing.inmem.sampling.percent=100 > > # The cut size for hbase region, in GB. > # E.g, for cube whose capacity be marked as "SMALL", split region per 5GB > by default > kylin.hbase.region.cut.small=5 > kylin.hbase.region.cut.medium=10 > kylin.hbase.region.cut.large=50 > > # The hfile size of GB, smaller hfile leading to the converting hfile MR > has more reducers and be faster > # set 0 to disable this optimization > kylin.hbase.hfile.size.gb=5 > > # Enable/disable ACL check for cube query > kylin.query.security.enabled=false > kylin.query.cache.enabled =false > # whether get job status from resource manager with kerberos authentication > kylin.job.status.with.kerberos=false > > ## kylin security configurations > > # spring security profile, options: testing, ldap, saml > # with "testing" profile, user can use pre-defined name/pwd like > KYLIN/ADMIN to login > kylin.security.profile=testing > > # default roles and admin roles in LDAP, for ldap and saml > acl.defaultRole=ROLE_ANALYST,ROLE_MODELER > acl.adminRole=ROLE_ADMIN > > #LDAP authentication configuration > ldap.server=ldap://ldap_server:389 > ldap.username= > ldap.password= > > #LDAP user account directory; > ldap.user.searchBase= > ldap.user.searchPattern= > ldap.user.groupSearchBase= > > #LDAP service account directory > ldap.service.searchBase= > ldap.service.searchPattern= > ldap.service.groupSearchBase= > > #SAML configurations for SSO > # SAML IDP metadata file location > saml.metadata.file=classpath:sso_metadata.xml > saml.metadata.entityBaseURL=https://hostname/kylin > saml.context.scheme=https > saml.context.serverName=hostname > saml.context.serverPort=443 > saml.context.contextPath=/kylin > > > ganglia.group= > ganglia.port=8664 > > ## Config for mail service > > # If true, will send email notification; > mail.enabled=false > mail.host= > mail.username= > mail.password= > mail.sender= > > ###########################config info for web####################### > > #help info ,format{name|displayName|link} ,optional > kylin.web.help.length=4 > kylin.web.help.0=start|Getting Started| > kylin.web.help.1=odbc|ODBC Driver| > kylin.web.help.2=tableau|Tableau Guide| > kylin.web.help.3=onboard|Cube Design Tutorial| > > #guide user how to build streaming cube > kylin.web.streaming.guide=http://kylin.apache.org/ > > #hadoop url link ,optional > kylin.web.hadoop= > #job diagnostic url link ,optional > kylin.web.diagnostic= > #contact mail on web page ,optional > kylin.web.contact_mail= > > ###########################config info for front####################### > > #env DEV|QA|PROD > deploy.env=DEV > > ###########################deprecated configs####################### > kylin.sandbox=true > kylin.web.hive.limit=200000000 > > > > [email protected] > -- Best regards, Shaofeng Shi
