You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "wenyefbl@163.com" <we...@163.com> on 2016/05/06 02:17:06 UTC
Table 'KYLIN_CAL_DT' not found
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
kylin.owner=whoami@kylin.apache.org
# 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
wenyefbl@163.com
Re: Re: Table 'KYLIN_CAL_DT' not found
Posted by ShaoFeng Shi <sh...@apache.org>.
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 wenyefbl@163.com <we...@163.com>:
> Build cube falied also!
> But in the version of kylin 1.3 successfully ,before build cuse!
>
>
>
> wenyefbl@163.com
>
> 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 wenyefbl@163.com <we...@163.com>:
>
> >
> > 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
> > kylin.owner=whoami@kylin.apache.org
> >
> > # 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
> >
> >
> >
> > wenyefbl@163.com
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
--
Best regards,
Shaofeng Shi
Re: Re: Table 'KYLIN_CAL_DT' not found
Posted by "wenyefbl@163.com" <we...@163.com>.
Build cube falied also!
But in the version of kylin 1.3 successfully ,before build cuse!
wenyefbl@163.com
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 wenyefbl@163.com <we...@163.com>:
>
> 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
> kylin.owner=whoami@kylin.apache.org
>
> # 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
>
>
>
> wenyefbl@163.com
>
--
Best regards,
Shaofeng Shi
Re: Table 'KYLIN_CAL_DT' not found
Posted by ShaoFeng Shi <sh...@apache.org>.
have you successfully build the "kylin_sales" cube?
2016-05-06 10:17 GMT+08:00 wenyefbl@163.com <we...@163.com>:
>
> 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
> kylin.owner=whoami@kylin.apache.org
>
> # 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
>
>
>
> wenyefbl@163.com
>
--
Best regards,
Shaofeng Shi