You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by George Lu <lu...@gmail.com> on 2015/09/18 05:23:20 UTC
sample cube query issue
Hi all,
I follow the instruction and query below "select part_dt, sum(price) as
total_selled, count(distinct seller_id) as sellers from kylin_sales group
by part_dt order by part_dt".
I build the cube previously and can query, however, after I query this the
next day, kylin says:
>From line 1, column 87 to line 1, column 97: Table 'KYLIN_SALES' not found
while executing SQL: "select part_dt, sum(price) as total_selled,
count(distinct seller_id) as sellers from kylin_sales group by part_dt
order by part_dt LIMIT 50000"
why is that?
And in the table tab, after I sync for the sample tables (use sampe.sql in
bin folder), there is no tables show up.
What is the problem?
Thanks,
George
Re: sample cube query issue
Posted by Li Yang <li...@apache.org>.
Em.. what posted is the cached exception. Need the initial exception for
troubleshooting..
Could you restart Kylin, query again and post the full log as attachment?
On Fri, Sep 18, 2015 at 4:45 PM, George Lu <lu...@gmail.com> wrote:
> After I excute "
> select part_dt, sum(price) as total_selled, count(distinct seller_id) as
> sellers from kylin_sales group by part_dt order by part_dt;"
>
> java.io.IOException: No such file or directory
>
> [pool-16-thread-1]:[2015-09-18
>
> 01:42:02,809][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
> - Job Fetcher: 0 running, 0 actual running, 0 ready, 9 others
> [http-bio-7070-exec-11]:[2015-09-18
>
> 01:42:40,933][INFO][org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:176)]
> - Using project: learn_kylin
> [http-bio-7070-exec-11]:[2015-09-18
>
> 01:42:40,937][INFO][org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:177)]
> - The original query: select part_dt, sum(price) as total_selled,
> count(distinct seller_id) as sellers from kylin_sales group by part_dt
> order by part_dt;
> [http-bio-7070-exec-11]:[2015-09-18
>
> 01:42:40,941][ERROR][org.apache.kylin.rest.controller.BasicController.handleError(BasicController.java:46)]
> -
> org.apache.kylin.rest.exception.InternalErrorException:
> java.io.IOException: No such file or directory
> at
>
> org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:219)
> at
>
> org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:165)
> at
>
> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:497)
> 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
>
> org.apache.kylin.rest.filter.KylinApiFilter.doFilterInternal(KylinApiFilter.java:66)
> at
>
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> 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:314)
> at
>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at
>
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:745)
> [http-bio-7070-exec-11]:[2015-09-18
>
> 01:42:40,947][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
> - REQUEST: REQUESTER=ADMIN;REQ_TIME=PDT 2015-09-18
>
> 01:42:40;URI=/kylin/api/query;METHOD=POST;QUERY_STRING=null;PAYLOAD={"sql":"select
> part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers
> from kylin_sales group by part_dt order by
>
> part_dt;","offset":0,"limit":50000,"acceptPartial":true,"project":"learn_kylin"};RESP_STATUS=500;
> [pool-16-thread-1]:[2015-09-18
>
> 01:43:02,772][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
> - Job Fetcher: 0 running, 0 actual running, 0 ready, 9 others
>
> On Fri, Sep 18, 2015 at 4:03 PM, Li Yang <li...@apache.org> wrote:
>
> > Was the cube build successful? If it is and the cube status is green
> (ready
> > state), please post logs and then we can help.
> >
> > Logs are found at KYLIN_HOME/tomcat/logs/kylin.log
> >
> > On Fri, Sep 18, 2015 at 11:51 AM, George Lu <lu...@gmail.com>
> wrote:
> >
> > > I refreshed two tables and kylin says refresh success, but after I
> click
> > > the default schema, only one table show up.
> > > Is that a bug?
> > > I use kylin 1.0.
> > >
> > > On Fri, Sep 18, 2015 at 11:23 AM, George Lu <lu...@gmail.com>
> > wrote:
> > >
> > > > Hi all,
> > > >
> > > > I follow the instruction and query below "select part_dt, sum(price)
> as
> > > > total_selled, count(distinct seller_id) as sellers from kylin_sales
> > group
> > > > by part_dt order by part_dt".
> > > >
> > > > I build the cube previously and can query, however, after I query
> this
> > > the
> > > > next day, kylin says:
> > > > From line 1, column 87 to line 1, column 97: Table 'KYLIN_SALES' not
> > > found
> > > > while executing SQL: "select part_dt, sum(price) as total_selled,
> > > > count(distinct seller_id) as sellers from kylin_sales group by
> part_dt
> > > > order by part_dt LIMIT 50000"
> > > >
> > > > why is that?
> > > >
> > > > And in the table tab, after I sync for the sample tables (use
> sampe.sql
> > > in
> > > > bin folder), there is no tables show up.
> > > >
> > > > What is the problem?
> > > >
> > > > Thanks,
> > > > George
> > > >
> > >
> >
>
Re: sample cube query issue
Posted by George Lu <lu...@gmail.com>.
After I excute "
select part_dt, sum(price) as total_selled, count(distinct seller_id) as
sellers from kylin_sales group by part_dt order by part_dt;"
java.io.IOException: No such file or directory
[pool-16-thread-1]:[2015-09-18
01:42:02,809][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 9 others
[http-bio-7070-exec-11]:[2015-09-18
01:42:40,933][INFO][org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:176)]
- Using project: learn_kylin
[http-bio-7070-exec-11]:[2015-09-18
01:42:40,937][INFO][org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:177)]
- The original query: select part_dt, sum(price) as total_selled,
count(distinct seller_id) as sellers from kylin_sales group by part_dt
order by part_dt;
[http-bio-7070-exec-11]:[2015-09-18
01:42:40,941][ERROR][org.apache.kylin.rest.controller.BasicController.handleError(BasicController.java:46)]
-
org.apache.kylin.rest.exception.InternalErrorException:
java.io.IOException: No such file or directory
at
org.apache.kylin.rest.controller.QueryController.doQueryInternal(QueryController.java:219)
at
org.apache.kylin.rest.controller.QueryController.doQuery(QueryController.java:165)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
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
org.apache.kylin.rest.filter.KylinApiFilter.doFilterInternal(KylinApiFilter.java:66)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
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:314)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
[http-bio-7070-exec-11]:[2015-09-18
01:42:40,947][DEBUG][org.apache.kylin.rest.filter.KylinApiFilter.logRequest(KylinApiFilter.java:120)]
- REQUEST: REQUESTER=ADMIN;REQ_TIME=PDT 2015-09-18
01:42:40;URI=/kylin/api/query;METHOD=POST;QUERY_STRING=null;PAYLOAD={"sql":"select
part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers
from kylin_sales group by part_dt order by
part_dt;","offset":0,"limit":50000,"acceptPartial":true,"project":"learn_kylin"};RESP_STATUS=500;
[pool-16-thread-1]:[2015-09-18
01:43:02,772][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:112)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 9 others
On Fri, Sep 18, 2015 at 4:03 PM, Li Yang <li...@apache.org> wrote:
> Was the cube build successful? If it is and the cube status is green (ready
> state), please post logs and then we can help.
>
> Logs are found at KYLIN_HOME/tomcat/logs/kylin.log
>
> On Fri, Sep 18, 2015 at 11:51 AM, George Lu <lu...@gmail.com> wrote:
>
> > I refreshed two tables and kylin says refresh success, but after I click
> > the default schema, only one table show up.
> > Is that a bug?
> > I use kylin 1.0.
> >
> > On Fri, Sep 18, 2015 at 11:23 AM, George Lu <lu...@gmail.com>
> wrote:
> >
> > > Hi all,
> > >
> > > I follow the instruction and query below "select part_dt, sum(price) as
> > > total_selled, count(distinct seller_id) as sellers from kylin_sales
> group
> > > by part_dt order by part_dt".
> > >
> > > I build the cube previously and can query, however, after I query this
> > the
> > > next day, kylin says:
> > > From line 1, column 87 to line 1, column 97: Table 'KYLIN_SALES' not
> > found
> > > while executing SQL: "select part_dt, sum(price) as total_selled,
> > > count(distinct seller_id) as sellers from kylin_sales group by part_dt
> > > order by part_dt LIMIT 50000"
> > >
> > > why is that?
> > >
> > > And in the table tab, after I sync for the sample tables (use sampe.sql
> > in
> > > bin folder), there is no tables show up.
> > >
> > > What is the problem?
> > >
> > > Thanks,
> > > George
> > >
> >
>
Re: sample cube query issue
Posted by Li Yang <li...@apache.org>.
Was the cube build successful? If it is and the cube status is green (ready
state), please post logs and then we can help.
Logs are found at KYLIN_HOME/tomcat/logs/kylin.log
On Fri, Sep 18, 2015 at 11:51 AM, George Lu <lu...@gmail.com> wrote:
> I refreshed two tables and kylin says refresh success, but after I click
> the default schema, only one table show up.
> Is that a bug?
> I use kylin 1.0.
>
> On Fri, Sep 18, 2015 at 11:23 AM, George Lu <lu...@gmail.com> wrote:
>
> > Hi all,
> >
> > I follow the instruction and query below "select part_dt, sum(price) as
> > total_selled, count(distinct seller_id) as sellers from kylin_sales group
> > by part_dt order by part_dt".
> >
> > I build the cube previously and can query, however, after I query this
> the
> > next day, kylin says:
> > From line 1, column 87 to line 1, column 97: Table 'KYLIN_SALES' not
> found
> > while executing SQL: "select part_dt, sum(price) as total_selled,
> > count(distinct seller_id) as sellers from kylin_sales group by part_dt
> > order by part_dt LIMIT 50000"
> >
> > why is that?
> >
> > And in the table tab, after I sync for the sample tables (use sampe.sql
> in
> > bin folder), there is no tables show up.
> >
> > What is the problem?
> >
> > Thanks,
> > George
> >
>
Re: sample cube query issue
Posted by George Lu <lu...@gmail.com>.
I refreshed two tables and kylin says refresh success, but after I click
the default schema, only one table show up.
Is that a bug?
I use kylin 1.0.
On Fri, Sep 18, 2015 at 11:23 AM, George Lu <lu...@gmail.com> wrote:
> Hi all,
>
> I follow the instruction and query below "select part_dt, sum(price) as
> total_selled, count(distinct seller_id) as sellers from kylin_sales group
> by part_dt order by part_dt".
>
> I build the cube previously and can query, however, after I query this the
> next day, kylin says:
> From line 1, column 87 to line 1, column 97: Table 'KYLIN_SALES' not found
> while executing SQL: "select part_dt, sum(price) as total_selled,
> count(distinct seller_id) as sellers from kylin_sales group by part_dt
> order by part_dt LIMIT 50000"
>
> why is that?
>
> And in the table tab, after I sync for the sample tables (use sampe.sql in
> bin folder), there is no tables show up.
>
> What is the problem?
>
> Thanks,
> George
>