[jira] [Commented] (KYLIN-2317) Hybrid Cube CLI Tools

2017-01-02 Thread Billy Liu (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15794146#comment-15794146
 ] 

Billy Liu commented on KYLIN-2317:
--

Thanks [~Shaofengshi]. Patch merged.
https://github.com/apache/kylin/commit/d7196d20ed7a70d11192d6f36eb802ee21f5539a

I will prepare some documents later and continue maintain this tool.

> Hybrid Cube CLI Tools
> -
>
> Key: KYLIN-2317
> URL: https://issues.apache.org/jira/browse/KYLIN-2317
> Project: Kylin
>  Issue Type: New Feature
>  Components: Metadata
>Affects Versions: v1.6.0
>Reporter: Billy Liu
>Assignee: Billy Liu
> Fix For: v2.0.0
>
> Attachments: KYLIN-2317.patch
>
>
> Provide CLI tools for Hybrid Cube feature
> 1. Create new Hybrid Cube by merging existing cubes
> 2. Check cubes no overlap
> 3. Merge existing Cube into existing Hybrid Cube



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Resolved] (KYLIN-2317) Hybrid Cube CLI Tools

2017-01-02 Thread Billy Liu (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Billy Liu resolved KYLIN-2317.
--
   Resolution: Fixed
Fix Version/s: v2.0.0

> Hybrid Cube CLI Tools
> -
>
> Key: KYLIN-2317
> URL: https://issues.apache.org/jira/browse/KYLIN-2317
> Project: Kylin
>  Issue Type: New Feature
>  Components: Metadata
>Affects Versions: v1.6.0
>Reporter: Billy Liu
>Assignee: Billy Liu
> Fix For: v2.0.0
>
> Attachments: KYLIN-2317.patch
>
>
> Provide CLI tools for Hybrid Cube feature
> 1. Create new Hybrid Cube by merging existing cubes
> 2. Check cubes no overlap
> 3. Merge existing Cube into existing Hybrid Cube



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (KYLIN-2323) Refine Table load/unload error message

2017-01-02 Thread Billy Liu (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Billy Liu updated KYLIN-2323:
-
Attachment: KYLIN-2323-2.patch

Hi [~zhongjian], there is more refactor work in this update. Including: display 
table type in ext info, remove unused table APIs, unify the ext data structure. 
Could you have a check?

> Refine Table load/unload error message
> --
>
> Key: KYLIN-2323
> URL: https://issues.apache.org/jira/browse/KYLIN-2323
> Project: Kylin
>  Issue Type: Improvement
>  Components: REST Service
>Affects Versions: v1.6.0
>Reporter: Billy Liu
>Assignee: Billy Liu
>Priority: Minor
> Fix For: v2.0.0
>
> Attachments: KYLIN-2323-2.patch, KYLIN-2323.patch
>
>
> There is no exception handling in TableController, so most of exceptions will 
> not be found in kylin.log, but kylin.out. The TableController should provide 
> more useful messages, and be stable when exception happens. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (KYLIN-2348) TPC-H query 20, requires multiple models in one query

2017-01-02 Thread liyang (JIRA)
liyang created KYLIN-2348:
-

 Summary: TPC-H query 20, requires multiple models in one query
 Key: KYLIN-2348
 URL: https://issues.apache.org/jira/browse/KYLIN-2348
 Project: Kylin
  Issue Type: Bug
Reporter: liyang






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (KYLIN-2347) TPC-H query 13, too many HLLC objects exceed memory budget

2017-01-02 Thread liyang (JIRA)
liyang created KYLIN-2347:
-

 Summary: TPC-H query 13, too many HLLC objects exceed memory budget
 Key: KYLIN-2347
 URL: https://issues.apache.org/jira/browse/KYLIN-2347
 Project: Kylin
  Issue Type: Bug
Reporter: liyang






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (KYLIN-2342) When NoClassDefFoundError occurred in building cube, no error in kylin.log

2017-01-02 Thread Shaofeng SHI (JIRA)

 [ 
https://issues.apache.org/jira/browse/KYLIN-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shaofeng SHI updated KYLIN-2342:

Description: 
When some jar is missing in kylin, trigger the cube build will get error, but 
there is no any warn/error message in backend kylin.log; The front web page 
also doesn't provide much message. Finally I get the root cause in the HTTP 
response.

The error should not be exposed to web gui; at least some trace need be left in 
kylin.log:

Below is the error in HTTP response:
{code}
root cause java.lang.NoClassDefFoundError: 
org/apache/kafka/clients/consumer/KafkaConsumer

org.apache.kylin.source.kafka.util.KafkaClient.getKafkaConsumer(KafkaClient.java:43)

org.apache.kylin.source.kafka.KafkaSource.parsePartitionBeforeBuild(KafkaSource.java:95)
org.apache.kylin.rest.service.JobService.submitJob(JobService.java:216)

org.apache.kylin.rest.service.JobService$$FastClassBySpringCGLIB$$83a44b2a.invoke(generated)
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:700)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633)

org.apache.kylin.rest.service.JobService$$EnhancerBySpringCGLIB$$afd3dab7.submitJob(generated)

org.apache.kylin.rest.controller.CubeController.buildInternal(CubeController.java:295)

org.apache.kylin.rest.controller.CubeController.rebuild(CubeController.java:287)

org.apache.kylin.rest.controller.CubeController.build(CubeController.java:280)
sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:606)

org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)

org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)

org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)

org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)

org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)

org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)

org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)

org.springframework.web.servlet.FrameworkServlet.doPut(FrameworkServlet.java:864)
javax.servlet.http.HttpServlet.service(HttpServlet.java:653)

org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)


[jira] [Commented] (KYLIN-2317) Hybrid Cube CLI Tools

2017-01-02 Thread Shaofeng SHI (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15793844#comment-15793844
 ] 

Shaofeng SHI commented on KYLIN-2317:
-

Billy, the patch looks good; please merge to master, thank you!

> Hybrid Cube CLI Tools
> -
>
> Key: KYLIN-2317
> URL: https://issues.apache.org/jira/browse/KYLIN-2317
> Project: Kylin
>  Issue Type: New Feature
>  Components: Metadata
>Affects Versions: v1.6.0
>Reporter: Billy Liu
>Assignee: Billy Liu
> Attachments: KYLIN-2317.patch
>
>
> Provide CLI tools for Hybrid Cube feature
> 1. Create new Hybrid Cube by merging existing cubes
> 2. Check cubes no overlap
> 3. Merge existing Cube into existing Hybrid Cube



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (KYLIN-2345) Not able to open web interface for Kylin

2017-01-02 Thread Billy Liu (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15792999#comment-15792999
 ] 

Billy Liu commented on KYLIN-2345:
--

Please do not open JIRA for this kind of question. Please raise your question 
with more detail exception log in kylin user mailer. Most of these cases are 
classpath issue or misconfigured. 

> Not able to open web interface for Kylin
> 
>
> Key: KYLIN-2345
> URL: https://issues.apache.org/jira/browse/KYLIN-2345
> Project: Kylin
>  Issue Type: Bug
>Reporter: Anurag 
>Priority: Blocker
>
> Not able to open web interface for Kylin
> 1. hadoop version is hadoop-2.7.3
> 2. apache kylin version apache-kylin-1.6.0-hbase1.x-bin
> 3 .hbase version hbase-1.1.7
> 4. hive version is apache-hive-2.1.0-bin
> issues in log 
> :org.springframework.beans.factory.BeanCurrentlyInCreationException: Error 
> creating bean with name 'mvcContentNegotiationManager': Requested bean is 
> currently in creation: Is there an unresolvable circular reference?
>   at 
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.beforeSingletonCreation(DefaultSingletonBeanRegistry.java:327)
>   at 
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:217)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (KYLIN-2346) OLAP TableScan MUST NOT be shared by more than one prent

2017-01-02 Thread Billy Liu (JIRA)

[ 
https://issues.apache.org/jira/browse/KYLIN-2346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15792989#comment-15792989
 ] 

Billy Liu commented on KYLIN-2346:
--

Sorry, could not catch up what you mean. What is "prent"? What is your expected 
result? To find the SQL reference, please check 
http://calcite.apache.org/docs/reference.html first. Thank you. 

And one more thing, please do not ask question in JIRA. JIRA is designed for 
confirmed bug tracking or feature proposal. 

> OLAP TableScan MUST NOT be shared by more than one prent
> 
>
> Key: KYLIN-2346
> URL: https://issues.apache.org/jira/browse/KYLIN-2346
> Project: Kylin
>  Issue Type: Bug
>Reporter: james
>Priority: Blocker
>
> i am a new fresher of the apache-kylin,
> i build cube,success.
> i want to run a sql sentence
> the result of the relation-database is right..what i want..
> the result of the cube modile is wrong..the results is as the titles
> the sql is 
> select * from tradectr.dbo.g_og_corpinfo t1 left join 
> tradectr.dbo.g_og_corpinfo t2 on t1.parentsid = t2.corpsid where 
> t2.levelscode = 'G011' AND t2.corpname like '%湖北%'
> it is a simple sql,just to find the company of the hubei province...
> also somebody could tell me the type of the sql which apache-kylin 
> supports,thanks very much。



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (KYLIN-2346) OLAP TableScan MUST NOT be shared by more than one prent

2017-01-02 Thread james (JIRA)
james created KYLIN-2346:


 Summary: OLAP TableScan MUST NOT be shared by more than one prent
 Key: KYLIN-2346
 URL: https://issues.apache.org/jira/browse/KYLIN-2346
 Project: Kylin
  Issue Type: Bug
Reporter: james
Priority: Blocker


i am a new fresher of the apache-kylin,
i build cube,success.
i want to run a sql sentence
the result of the relation-database is right..what i want..
the result of the cube modile is wrong..the results is as the titles
the sql is 
select * from tradectr.dbo.g_og_corpinfo t1 left join 
tradectr.dbo.g_og_corpinfo t2 on t1.parentsid = t2.corpsid where t2.levelscode 
= 'G011' AND t2.corpname like '%湖北%'
it is a simple sql,just to find the company of the hubei province...
also somebody could tell me the type of the sql which apache-kylin 
supports,thanks very much。



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)