[jira] [Created] (KYLIN-2784) Set User-Agent for ODBC/JDBC Drivers

[Dong Li (JIRA)]

Dong Li created KYLIN-2784:
--

 Summary: Set User-Agent for ODBC/JDBC Drivers
 Key: KYLIN-2784
 URL: https://issues.apache.org/jira/browse/KYLIN-2784
 Project: Kylin
  Issue Type: Improvement
  Components: Driver - JDBC, Driver - ODBC
Affects Versions: v2.2.0
Reporter: Dong Li


Set specified user-agent for ODBC/JDBC users, so that we can identify http 
request from drivers in tomcat access logs.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Re: The REST query request failed

[Billy Liu]

This sql is not generated by kylin, Kylin does not generate any query.
Kylin is read only OLAP system. Kylin accepts SQL and returns query result.

Please try that SQL in Kylin insight tab directly, if not work, you could
adjust the statement to figure out which one is the incompatible one.

2017-08-10 17:26 GMT+08:00 578300...@qq.com :

> You mean that the tableau's calculation field query and kylin can not be
> well fused?
> Beacause the sql is automatically generated by kylin on the basis of
> tableau's calculation field.
> And the environment is:
> jdk1.7.0_80
> hadoop-2.5.0-cdh5.3.9
> hbase-0.98.6-cdh5.3.9
> apache-kylin-1.6.0
> tableau 9
>
>
> -- 原始邮件 --
> 发件人: "Billy Liu";;
> 发送时间: 2017年8月10日(星期四) 下午5:05
> 收件人: "dev";
>
> 主题: Re: The REST query request failed
>
>
>
> The error is clear, some sql grammar did not work in your case, such as "{d
> '2017-06-30'))}"
>
> 2017-08-10 15:58 GMT+08:00 578300...@qq.com :
>
> > Oh，I see.
> > I will redescribe with word.
> >
> >
> > I created a calculated field in tableau to judge the date(统计日期) is or not
> > the last month of last year:
> > YEAR([统计日期])=YEAR(DATEADD('year',-1,[截止日期])) and MONTH([统计日期])=12
> >
> >
> >
> > when I use the calculated field ,there is an error in kylin.log:
> > 2017-08-10 15:44:27,279 ERROR [http-bio-7070-exec-2]
> > controller.BasicController:44 :
> > org.apache.kylin.rest.exception.InternalErrorException: Encountered ")"
> > at line 1, column 154. Was expecting: "}" ...
> > at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> > QueryService.java:391)
> > at org.apache.kylin.rest.controller.QueryController.
> > query(QueryController.java:69)
> > 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.
> > doInvoke(InvocableHandlerMethod.java:221)
> > at org.springframework.web.method.support.
> InvocableHandlerMethod.
> > invokeForRequest(InvocableHandlerMethod.java:136)
> > at org.springframework.web.servlet.mvc.method.annotation.
> > ServletInvocableHandlerMethod.invokeAndHandle(
> > ServletInvocableHandlerMethod.java:104)
> > at org.springframework.web.servlet.mvc.method.annotation.
> > RequestMappingHandlerAdapter.invokeHandleMethod(
> > RequestMappingHandlerAdapter.java:743)
> > at org.springframework.web.servlet.mvc.method.annotation.
> > RequestMappingHandlerAdapter.handleInternal(
> RequestMappingHandlerAdapter.
> > java:672)
> > at org.springframework.web.servlet.mvc.method.
> > AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.
> java:82)
> > at org.springframework.web.servlet.DispatcherServlet.
> > doDispatch(DispatcherServlet.java:933)
> > at org.springframework.web.servlet.DispatcherServlet.
> > doService(DispatcherServlet.java:867)
> > at org.springframework.web.servlet.FrameworkServlet.
> > processRequest(FrameworkServlet.java:951)
> > at org.springframework.web.servlet.FrameworkServlet.
> > doPost(FrameworkServlet.java:853)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> > at org.springframework.web.servlet.FrameworkServlet.
> > service(FrameworkServlet.java:827)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> > at org.apache.catalina.core.ApplicationFilterChain.
> > internalDoFilter(ApplicationFilterChain.java:303)
> > at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:208)
> > at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> > WsFilter.java:52)
> > at org.apache.catalina.core.ApplicationFilterChain.
> > internalDoFilter(ApplicationFilterChain.java:241)
> > at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:208)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java: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 

?????? The REST query request failed

[578300...@qq.com]

You mean that the tableau's calculation field query and kylin can not be well 
fused?
Beacause the sql is automatically generated by kylin on the basis of tableau's 
calculation field.
And the environment is:
jdk1.7.0_80
hadoop-2.5.0-cdh5.3.9
hbase-0.98.6-cdh5.3.9
apache-kylin-1.6.0
tableau 9


--  --
??: "Billy Liu";;
: 2017??8??10??(??) 5:05
??: "dev"; 

: Re: The REST query request failed



The error is clear, some sql grammar did not work in your case, such as "{d
'2017-06-30'))}"

2017-08-10 15:58 GMT+08:00 578300...@qq.com :

> Oh??I see.
> I will redescribe with word.
>
>
> I created a calculated field in tableau to judge the date() is or not
> the last month of last year:
> YEAR([])=YEAR(DATEADD('year',-1,[])) and MONTH([])=12
>
>
>
> when I use the calculated field ,there is an error in kylin.log:
> 2017-08-10 15:44:27,279 ERROR [http-bio-7070-exec-2]
> controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Encountered ")"
> at line 1, column 154. Was expecting: "}" ...
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:391)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> 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.
> doInvoke(InvocableHandlerMethod.java:221)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
> at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:951)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:303)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> WsFilter.java:52)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java: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$
> 

Re: The REST query request failed

[Billy Liu]

The error is clear, some sql grammar did not work in your case, such as "{d
'2017-06-30'))}"

2017-08-10 15:58 GMT+08:00 578300...@qq.com :

> Oh，I see.
> I will redescribe with word.
>
>
> I created a calculated field in tableau to judge the date(统计日期) is or not
> the last month of last year:
> YEAR([统计日期])=YEAR(DATEADD('year',-1,[截止日期])) and MONTH([统计日期])=12
>
>
>
> when I use the calculated field ,there is an error in kylin.log:
> 2017-08-10 15:44:27,279 ERROR [http-bio-7070-exec-2]
> controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Encountered ")"
> at line 1, column 154. Was expecting: "}" ...
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:391)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> 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.
> doInvoke(InvocableHandlerMethod.java:221)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
> at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:951)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:303)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> WsFilter.java:52)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java: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$
> 

[jira] [Created] (KYLIN-2783) Refactor CuboidScheduler to be extensible

[liyang (JIRA)]

liyang created KYLIN-2783:
-

 Summary: Refactor CuboidScheduler to be extensible
 Key: KYLIN-2783
 URL: https://issues.apache.org/jira/browse/KYLIN-2783
 Project: Kylin
  Issue Type: Improvement
Reporter: liyang






--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

?????? The REST query request failed

[578300...@qq.com]

Oh??I see.
I will redescribe with word.


I created a calculated field in tableau to judge the date() is or not 
the last month of last year:
YEAR([])=YEAR(DATEADD('year',-1,[])) and MONTH([])=12



when I use the calculated field ,there is an error in kylin.log:
2017-08-10 15:44:27,279 ERROR [http-bio-7070-exec-2] 
controller.BasicController:44 : 
org.apache.kylin.rest.exception.InternalErrorException: Encountered ")" at line 
1, column 154. Was expecting: "}" ... 
at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:391)
at 
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
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.doInvoke(InvocableHandlerMethod.java:221)
at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)
at 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
at 
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at 
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at 
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java: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 

Re: Kylin often hangs up

[shendandan]

Thanks for your respond,but Zk is working normally.





At 2017-08-10 15:21:49, "Billy Liu"  wrote:
>The first WARN happened during ZK timeout. Please check the ZK connection
>first.
>
>2017-08-10 10:58 GMT+08:00 shendandan :
>
>> Hi!
>>The process of kylin often hangs up,and the erroe in kylin,log:
>>
>>
>> 2017-08-10 10:14:22,292 INFO  [BadQueryDetector]
>> service.BadQueryDetector:151 : System free memory less than 100 MB. 1
>> queries running.
>> 2017-08-10 10:14:34,498 INFO  [Thread-11-EventThread]
>> state.ConnectionStateManager:228 : State change: SUSPENDED
>> 2017-08-10 10:14:34,506 INFO  [pool-7-thread-1]
>> threadpool.DefaultScheduler:118 : Job Fetcher: 0 should running, 0 actual
>> running, 0 ready, 63 already succeed, 3 error, 13 discarded, 0 others
>> 2017-08-10 10:14:34,999 INFO  [localhost-startStop-1-SendThread(
>> hadoop-senior01.ctcf.com:2181)] zookeeper.ClientCnxn:975 : Opening socket
>> connection to server hadoop-senior01.ctcf.com/10.1.8.90:2181. Will not
>> attempt to authenticate using SASL (unknown error)
>> 2017-08-10 10:14:34,999 INFO  [Thread-11-SendThread(hadoop-
>> senior03.ctcf.com:2181)] zookeeper.ClientCnxn:975 : Opening socket
>> connection to server hadoop-senior03.ctcf.com/10.1.8.92:2181. Will not
>> attempt to authenticate using SASL (unknown error)
>> 2017-08-10 10:14:34,999 INFO  [localhost-startStop-1-SendThread(
>> hadoop-senior01.ctcf.com:2181)] zookeeper.ClientCnxn:852 : Socket
>> connection established, initiating session, client: /10.1.8.90:38229,
>> server: hadoop-senior01.ctcf.com/10.1.8.90:2181
>> 2017-08-10 10:14:34,999 INFO  [Thread-11-SendThread(hadoop-
>> senior03.ctcf.com:2181)] zookeeper.ClientCnxn:852 : Socket connection
>> established, initiating session, client: /10.1.8.90:32962, server:
>> hadoop-senior03.ctcf.com/10.1.8.92:2181
>> 2017-08-10 10:14:35,001 INFO  [Thread-11-SendThread(hadoop-
>> senior03.ctcf.com:2181)] zookeeper.ClientCnxn:1094 : Unable to reconnect
>> to ZooKeeper service, session 0x25dc4bd90cc002a has expired, closing socket
>> connection
>> 2017-08-10 10:14:35,002 INFO  [localhost-startStop-1-SendThread(
>> hadoop-senior01.ctcf.com:2181)] zookeeper.ClientCnxn:1094 : Unable to
>> reconnect to ZooKeeper service, session 0x35dc4bd90460028 has expired,
>> closing socket connection
>> 2017-08-10 10:14:35,013 WARN  [localhost-startStop-1-EventThread]
>> client.HConnectionManager$HConnectionImplementation:2468 : This client
>> just lost it's session with ZooKeeper, closing it. It will be recreated
>> next time someone needs it
>> org.apache.zookeeper.KeeperException$SessionExpiredException:
>> KeeperErrorCode = Session expired
>> at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.connectionEvent(
>> ZooKeeperWatcher.java:517)
>> at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.
>> process(ZooKeeperWatcher.java:435)
>> at org.apache.zookeeper.ClientCnxn$EventThread.
>> processEvent(ClientCnxn.java:522)
>> at org.apache.zookeeper.ClientCnxn$EventThread.run(ClientCnxn.java:498)
>> 2017-08-10 10:14:35,013 INFO  [Thread-11-EventThread]
>> state.ConnectionStateManager:228 : State change: LOST
>> 2017-08-10 10:14:35,014 INFO  [localhost-startStop-1-EventThread]
>> client.HConnectionManager$HConnectionImplementation:1837 : Closing
>> zookeeper sessionid=0x35dc4bd90460028
>> 2017-08-10 10:14:35,014 WARN  [Thread-11-EventThread]
>> curator.ConnectionState:289 : Session expired event received
>> 2017-08-10 10:14:35,014 INFO  [localhost-startStop-1-EventThread]
>> zookeeper.ClientCnxn:512 : EventThread shut down
>> 2017-08-10 10:14:35,015 INFO  [Thread-11-EventThread]
>> zookeeper.ZooKeeper:438 : Initiating client connection, connectString=
>> hadoop-senior01.ctcf.com:2181,hadoop-senior02.ctcf.com:2181,
>> hadoop-senior03.ctcf.com:2181 sessionTimeout=6
>> watcher=org.apache.curator.ConnectionState@4d6f4fa7
>> 2017-08-10 10:14:35,017 INFO  [Thread-11-SendThread(hadoop-
>> senior02.ctcf.com:2181)] zookeeper.ClientCnxn:975 : Opening socket
>> connection to server hadoop-senior02.ctcf.com/10.1.8.91:2181. Will not
>> attempt to authenticate using SASL (unknown error)
>> 2017-08-10 10:14:35,017 INFO  [Thread-11-SendThread(hadoop-
>> senior02.ctcf.com:2181)] zookeeper.ClientCnxn:852 : Socket connection
>> established, initiating session, client: /10.1.8.90:57503, server:
>> hadoop-senior02.ctcf.com/10.1.8.91:2181
>> 2017-08-10 10:14:35,021 INFO  [Thread-11-EventThread]
>> zookeeper.ClientCnxn:512 : EventThread shut down
>> 2017-08-10 10:14:35,021 INFO  [Thread-11-SendThread(hadoop-
>> senior02.ctcf.com:2181)] zookeeper.ClientCnxn:1235 : Session
>> establishment complete on server hadoop-senior02.ctcf.com/10.1.8.91:2181,
>> sessionid = 0x25dc4bd90cc002c, negotiated timeout = 4
>> 2017-08-10 10:14:35,021 INFO  [Thread-11-EventThread]
>> state.ConnectionStateManager:228 : State change: RECONNECTED
>> 2017-08-10 10:15:09,204 INFO  [pool-7-thread-1]
>> threadpool.DefaultScheduler:118 : Job 

Re: Kylin often hangs up

[Billy Liu]

The first WARN happened during ZK timeout. Please check the ZK connection
first.

2017-08-10 10:58 GMT+08:00 shendandan :

> Hi!
>The process of kylin often hangs up,and the erroe in kylin,log:
>
>
> 2017-08-10 10:14:22,292 INFO  [BadQueryDetector]
> service.BadQueryDetector:151 : System free memory less than 100 MB. 1
> queries running.
> 2017-08-10 10:14:34,498 INFO  [Thread-11-EventThread]
> state.ConnectionStateManager:228 : State change: SUSPENDED
> 2017-08-10 10:14:34,506 INFO  [pool-7-thread-1]
> threadpool.DefaultScheduler:118 : Job Fetcher: 0 should running, 0 actual
> running, 0 ready, 63 already succeed, 3 error, 13 discarded, 0 others
> 2017-08-10 10:14:34,999 INFO  [localhost-startStop-1-SendThread(
> hadoop-senior01.ctcf.com:2181)] zookeeper.ClientCnxn:975 : Opening socket
> connection to server hadoop-senior01.ctcf.com/10.1.8.90:2181. Will not
> attempt to authenticate using SASL (unknown error)
> 2017-08-10 10:14:34,999 INFO  [Thread-11-SendThread(hadoop-
> senior03.ctcf.com:2181)] zookeeper.ClientCnxn:975 : Opening socket
> connection to server hadoop-senior03.ctcf.com/10.1.8.92:2181. Will not
> attempt to authenticate using SASL (unknown error)
> 2017-08-10 10:14:34,999 INFO  [localhost-startStop-1-SendThread(
> hadoop-senior01.ctcf.com:2181)] zookeeper.ClientCnxn:852 : Socket
> connection established, initiating session, client: /10.1.8.90:38229,
> server: hadoop-senior01.ctcf.com/10.1.8.90:2181
> 2017-08-10 10:14:34,999 INFO  [Thread-11-SendThread(hadoop-
> senior03.ctcf.com:2181)] zookeeper.ClientCnxn:852 : Socket connection
> established, initiating session, client: /10.1.8.90:32962, server:
> hadoop-senior03.ctcf.com/10.1.8.92:2181
> 2017-08-10 10:14:35,001 INFO  [Thread-11-SendThread(hadoop-
> senior03.ctcf.com:2181)] zookeeper.ClientCnxn:1094 : Unable to reconnect
> to ZooKeeper service, session 0x25dc4bd90cc002a has expired, closing socket
> connection
> 2017-08-10 10:14:35,002 INFO  [localhost-startStop-1-SendThread(
> hadoop-senior01.ctcf.com:2181)] zookeeper.ClientCnxn:1094 : Unable to
> reconnect to ZooKeeper service, session 0x35dc4bd90460028 has expired,
> closing socket connection
> 2017-08-10 10:14:35,013 WARN  [localhost-startStop-1-EventThread]
> client.HConnectionManager$HConnectionImplementation:2468 : This client
> just lost it's session with ZooKeeper, closing it. It will be recreated
> next time someone needs it
> org.apache.zookeeper.KeeperException$SessionExpiredException:
> KeeperErrorCode = Session expired
> at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.connectionEvent(
> ZooKeeperWatcher.java:517)
> at org.apache.hadoop.hbase.zookeeper.ZooKeeperWatcher.
> process(ZooKeeperWatcher.java:435)
> at org.apache.zookeeper.ClientCnxn$EventThread.
> processEvent(ClientCnxn.java:522)
> at org.apache.zookeeper.ClientCnxn$EventThread.run(ClientCnxn.java:498)
> 2017-08-10 10:14:35,013 INFO  [Thread-11-EventThread]
> state.ConnectionStateManager:228 : State change: LOST
> 2017-08-10 10:14:35,014 INFO  [localhost-startStop-1-EventThread]
> client.HConnectionManager$HConnectionImplementation:1837 : Closing
> zookeeper sessionid=0x35dc4bd90460028
> 2017-08-10 10:14:35,014 WARN  [Thread-11-EventThread]
> curator.ConnectionState:289 : Session expired event received
> 2017-08-10 10:14:35,014 INFO  [localhost-startStop-1-EventThread]
> zookeeper.ClientCnxn:512 : EventThread shut down
> 2017-08-10 10:14:35,015 INFO  [Thread-11-EventThread]
> zookeeper.ZooKeeper:438 : Initiating client connection, connectString=
> hadoop-senior01.ctcf.com:2181,hadoop-senior02.ctcf.com:2181,
> hadoop-senior03.ctcf.com:2181 sessionTimeout=6
> watcher=org.apache.curator.ConnectionState@4d6f4fa7
> 2017-08-10 10:14:35,017 INFO  [Thread-11-SendThread(hadoop-
> senior02.ctcf.com:2181)] zookeeper.ClientCnxn:975 : Opening socket
> connection to server hadoop-senior02.ctcf.com/10.1.8.91:2181. Will not
> attempt to authenticate using SASL (unknown error)
> 2017-08-10 10:14:35,017 INFO  [Thread-11-SendThread(hadoop-
> senior02.ctcf.com:2181)] zookeeper.ClientCnxn:852 : Socket connection
> established, initiating session, client: /10.1.8.90:57503, server:
> hadoop-senior02.ctcf.com/10.1.8.91:2181
> 2017-08-10 10:14:35,021 INFO  [Thread-11-EventThread]
> zookeeper.ClientCnxn:512 : EventThread shut down
> 2017-08-10 10:14:35,021 INFO  [Thread-11-SendThread(hadoop-
> senior02.ctcf.com:2181)] zookeeper.ClientCnxn:1235 : Session
> establishment complete on server hadoop-senior02.ctcf.com/10.1.8.91:2181,
> sessionid = 0x25dc4bd90cc002c, negotiated timeout = 4
> 2017-08-10 10:14:35,021 INFO  [Thread-11-EventThread]
> state.ConnectionStateManager:228 : State change: RECONNECTED
> 2017-08-10 10:15:09,204 INFO  [pool-7-thread-1]
> threadpool.DefaultScheduler:118 : Job Fetcher: 0 should running, 0 actual
> running, 0 ready, 63 already succeed, 3 error, 13 discarded, 0 others
> 2017-08-10 10:15:26,969 INFO  [BadQueryDetector]
> service.BadQueryDetector:179 : Slow query has 

Re: The REST query request failed

[Billy Liu]

Attachment is not allowed in the mailer, you could upload the images to
some public image services.

2017-08-09 19:21 GMT+08:00 578300...@qq.com :

>
> The picture may not show up, I put them in the attachment.Thank you!
>
> -- 原始邮件 --
> *发件人:* "578300...@qq.com";;
> *发送时间:* 2017年8月9日(星期三) 晚上6:08
> *收件人:* "dev";
> *主题:* The REST query request failed
>
> Hello!
> when I use tableau to connect to kylin,some error arised.
>
>  I created a calculated field in tableau
>
>
> and in kylin.log,the sql is:
>
>
>   How is this caused  and how can I solve it. Thank you very much!
>
>