Re: join column derived vs normal

[陶 加涛]

Hi Sachin Aggarwal 

When a lookup table is stored as snapshot, all columns in that table will be 
taken as derived dimension by default during cube design.

Compare to normal dimension, derived dimension does not participate in cube 
calculation directly. Instead, it is represented by its FK (Foreign Key) in 
cube. That is why using derived dimensions can greatly reduce cube complexity. 
During query, derived dimensions have to be converted to their FKs first, 
causing a small panalty to performance.

---
Regards!
Aron Tao
 
 

On [DATE], "[NAME]" <[ADDRESS]> wrote:

Hi Team,

while creating cube what are recommendations across join column between
fact and dimension.
should we mark it as derived or normal while selecting it from dimension
column.
what factors play a role in making this decision.


-- 

Thanks & Regards

Sachin Aggarwal

Re: user ADMIN can't login

[陶 加涛]

Seems similar with this JIRA (https://issues.apache.org/jira/browse/KYLIN-3562).


---
Regards!
Aron Tao



发件人: Fei Yi 
答复: "u...@kylin.apache.org" 
日期: 2018年10月25日 星期四 11:26
收件人: "dev@kylin.apache.org" , "u...@kylin.apache.org" 

主题: Re: user ADMIN can't login

env:kylin2.5.0-cdh57 and  cdh.5.14.4

Fei Yi mailto:yijianhui...@gmail.com>> 于2018年10月25日周四 
上午11:20写道：
User ADMIN can't log in. After restarting kylin, it will be normal, but can't 
log in the next day, ANALYST user has been normal.

HTTP Status 500 %E2%80%93 Internal Server Error
HTTP Status 500 %E2%80%93 Internal Server Error


Type Exception Report

Message Overwriting conflict /user/ADMIN, expect old TS 1540406402017, but it 
is 1540406402299

Description The server encountered an unexpected condition that prevented it 
from fulfilling the request.

Exception

org.apache.kylin.common.persistence.WriteConflictException: Overwriting 
conflict /user/ADMIN, expect old TS 1540406402017, but it is 
1540406402299%0A%09org.apache.kylin.storage.hbase.HBaseResourceStore.checkAndPutResourceImpl(HBaseResourceStore.java:325)%0A%09org.apache.kylin.common.persistence.ResourceStore.checkAndPutResourceCheckpoint(ResourceStore.java:323)%0A%09org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:308)%0A%09org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:287)%0A%09org.apache.kylin.metadata.cachesync.CachedCrudAssist.save(CachedCrudAssist.java:192)%0A%09org.apache.kylin.rest.security.KylinUserManager.update(KylinUserManager.java:122)%0A%09org.apache.kylin.rest.service.KylinUserService.updateUser(KylinUserService.java:85)%0A%09org.apache.kylin.rest.security.KylinAuthenticationProvider.authenticate(KylinAuthenticationProvider.java:117)%0A%09org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:174)%0A%09org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:199)%0A%09org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:180)%0A%09org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)%0A%09org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)%0A%09org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)%0A%09org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)%0A%09org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)%0A%09org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)%0A%09org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)%0A%09org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)%0A%09org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)%0A%09org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)%0A%09org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)%0A%09org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)%0A%09org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)%0A%09org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)%0A%09org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)%0A%09org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)%0A%09org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)%0A%09org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)%0A%09com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)%0A%09com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)%0A

Note The full stack trace of the root cause is available in the server logs.


Apache Tomcat/7.0.90
HTTP Status 500 �C Internal Server Error


Type Exception Report

Message Overwriting conflict /user/ADMIN, expect old TS 1540406402017, but it 
is 1540406402299

Description The server encountered an unexpected condition that prevented it 
from fulfilling the request.

Exception

org.apache.kylin.common.persistence.WriteConflictException: Overwriting 
conflict /user/ADMIN, expect old TS 1540406402017, but it is 1540406402299

 
org.apache.kylin.storage.hbase.HBaseResourceStore.checkAndPutResourceImpl(HBaseResourceStore.java:325)

 
org.a