If the cube wasn't built, the query won't work; what's the error of the cube build?
2016-05-06 12:12 GMT+08:00 [email protected] <[email protected]>: > Build cube falied also! > But in the version of kylin 1.3 successfully ,before build cuse! > > > > [email protected] > > From: ShaoFeng Shi > Date: 2016-05-06 11:10 > To: dev > Subject: Re: Table 'KYLIN_CAL_DT' not found > 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 > -- Best regards, Shaofeng Shi
