[jira] [Resolved] (KYLIN-2806) Empty results from JDBC with Date filter in prepareStatement
[ https://issues.apache.org/jira/browse/KYLIN-2806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dong Li resolved KYLIN-2806. Resolution: Fixed > Empty results from JDBC with Date filter in prepareStatement > > > Key: KYLIN-2806 > URL: https://issues.apache.org/jira/browse/KYLIN-2806 > Project: Kylin > Issue Type: Bug > Components: Driver - JDBC, Query Engine >Affects Versions: v1.6.0, v2.0.0, v2.1.0 > Environment: kylin版本：apache-kylin-1.6.0-cdh5.7-bin > jdbc版本：kylin-jdbc-1.6.0.jar > java版本：java version "1.8.0_92" >Reporter: chengwansheng >Assignee: Wang Cheng > Labels: scope > Fix For: v2.2.0 > > > 用kylin的JDBC查询，查询条件是date类型的，如果通过prepareStatement、setDate是查询不出数据的，然而直接用SQL可以查出数据 -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (KYLIN-2937) 非分区cube的中间数据会累积
[ https://issues.apache.org/jira/browse/KYLIN-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203643#comment-16203643 ] Billy Liu commented on KYLIN-2937: -- As the log said, "Identical dictionary content, reuse existing dictionary" In your case, no new dictionary is building. Have you run the StorageCleanupJob? > 非分区cube的中间数据会累积 > --- > > Key: KYLIN-2937 > URL: https://issues.apache.org/jira/browse/KYLIN-2937 > Project: Kylin > Issue Type: Bug >Reporter: zhengzfand > > 非分区的cube构建之后,中间数据不会被清理. > 存放在hdfs上的字典文件,会一直累积.cube构建时会加载所有这些累积字典文件, > 有可能导致内存溢出(如果字典文件够大够多的话). -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Closed] (KYLIN-2936) 清理脚本会删除掉正在构建cube的中间表
[ https://issues.apache.org/jira/browse/KYLIN-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] zhengzfand closed KYLIN-2936. - Resolution: Duplicate > 清理脚本会删除掉正在构建cube的中间表 > > > Key: KYLIN-2936 > URL: https://issues.apache.org/jira/browse/KYLIN-2936 > Project: Kylin > Issue Type: Bug >Reporter: zhengzfand > > 清理脚本会删除掉正在构建cube的中间表,导致找不到表, > java.lang.RuntimeException: java.io.IOException: > NoSuchObjectException(message:tmp_kylin.kylin_intermediate_C_PaymentCR_Flat_clone_a3943d98_9d6c_42de_b570_7d70a216080b > table not found) > at > org.apache.kylin.source.hive.HiveMRInput$HiveTableInputFormat.configureJob(HiveMRInput.java:110) -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (KYLIN-2936) 清理脚本会删除掉正在构建cube的中间表
[ https://issues.apache.org/jira/browse/KYLIN-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203604#comment-16203604 ] zhengzfand commented on KYLIN-2936: --- thank you . > 清理脚本会删除掉正在构建cube的中间表 > > > Key: KYLIN-2936 > URL: https://issues.apache.org/jira/browse/KYLIN-2936 > Project: Kylin > Issue Type: Bug >Reporter: zhengzfand > > 清理脚本会删除掉正在构建cube的中间表,导致找不到表, > java.lang.RuntimeException: java.io.IOException: > NoSuchObjectException(message:tmp_kylin.kylin_intermediate_C_PaymentCR_Flat_clone_a3943d98_9d6c_42de_b570_7d70a216080b > table not found) > at > org.apache.kylin.source.hive.HiveMRInput$HiveTableInputFormat.configureJob(HiveMRInput.java:110) -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Created] (KYLIN-2939) Get config properties not correct
Pan, Julian created KYLIN-2939:
--
Summary: Get config properties not correct
Key: KYLIN-2939
URL: https://issues.apache.org/jira/browse/KYLIN-2939
Project: Kylin
Issue Type: Bug
Components: Web
Reporter: Pan, Julian
Assignee: Pan, Julian
Priority: Critical
When I want to get kylin.env by getDeployEnv(), it will return
kylin.env.hdfs-working-dir value. There is a bug in getProperty in
kylinProperties.js.
This function will return first properties will contains this name.
Here is the fix:
this.getProperty = function (name) {
var keyIndex = _config.indexOf('\n' + name + '=');
var keyLength = name.length;
var partialResult = _config.substr(keyIndex);
var preValueIndex = partialResult.indexOf("=");
var sufValueIndex = partialResult.indexOf("\n", 2);
return partialResult.substring(preValueIndex + 1, sufValueIndex);
}
If necessary, I can create a patch for it.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
[jira] [Commented] (KYLIN-2938) Project Update ACL issue
[ https://issues.apache.org/jira/browse/KYLIN-2938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203311#comment-16203311 ] Billy Liu commented on KYLIN-2938: -- Patch is welcomed. > Project Update ACL issue > > > Key: KYLIN-2938 > URL: https://issues.apache.org/jira/browse/KYLIN-2938 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.1.0 >Reporter: Pan, Julian >Assignee: Zhong,Jason > > I noticed there different security between updateProject and renameProject in > ProjectService. > @PreAuthorize(Constant.ACCESS_HAS_ROLE_ADMIN + " or > hasPermission(#currentProject, 'ADMINISTRATION') or > hasPermission(#currentProject, 'MANAGEMENT')") > updateProject > @PreAuthorize(Constant.ACCESS_HAS_ROLE_ADMIN + " or > hasPermission(#currentProject, 'ADMINISTRATION')") > renameProject > Even updateProject will call renameProject. Which will throws exception if > user is MANAGEMENT role. > The renameProject should be same security check with updateProject. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (KYLIN-2937) 非分区cube的中间数据会累积
[ https://issues.apache.org/jira/browse/KYLIN-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203310#comment-16203310 ] Billy Liu commented on KYLIN-2937: -- [~zfzheng], thank you for reporting this issue. Could you update the Kylin version, and upload some snapshots evidence? > 非分区cube的中间数据会累积 > --- > > Key: KYLIN-2937 > URL: https://issues.apache.org/jira/browse/KYLIN-2937 > Project: Kylin > Issue Type: Bug >Reporter: zhengzfand > > 非分区的cube构建之后,中间数据不会被清理. > 存放在hdfs上的字典文件,会一直累积.cube构建时会加载所有这些累积字典文件, > 有可能导致内存溢出(如果字典文件够大够多的话). -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (KYLIN-2938) Project Update ACL issue
[ https://issues.apache.org/jira/browse/KYLIN-2938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203305#comment-16203305 ] Billy Liu commented on KYLIN-2938: -- Agree. They should be the same permission. > Project Update ACL issue > > > Key: KYLIN-2938 > URL: https://issues.apache.org/jira/browse/KYLIN-2938 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.1.0 >Reporter: Pan, Julian >Assignee: Zhong,Jason > > I noticed there different security between updateProject and renameProject in > ProjectService. > @PreAuthorize(Constant.ACCESS_HAS_ROLE_ADMIN + " or > hasPermission(#currentProject, 'ADMINISTRATION') or > hasPermission(#currentProject, 'MANAGEMENT')") > updateProject > @PreAuthorize(Constant.ACCESS_HAS_ROLE_ADMIN + " or > hasPermission(#currentProject, 'ADMINISTRATION')") > renameProject > Even updateProject will call renameProject. Which will throws exception if > user is MANAGEMENT role. > The renameProject should be same security check with updateProject. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Created] (KYLIN-2938) Project Update ACL issue
Pan, Julian created KYLIN-2938: -- Summary: Project Update ACL issue Key: KYLIN-2938 URL: https://issues.apache.org/jira/browse/KYLIN-2938 Project: Kylin Issue Type: Bug Components: REST Service Affects Versions: v2.1.0 Reporter: Pan, Julian Assignee: Zhong,Jason I noticed there different security between updateProject and renameProject in ProjectService. @PreAuthorize(Constant.ACCESS_HAS_ROLE_ADMIN + " or hasPermission(#currentProject, 'ADMINISTRATION') or hasPermission(#currentProject, 'MANAGEMENT')") updateProject @PreAuthorize(Constant.ACCESS_HAS_ROLE_ADMIN + " or hasPermission(#currentProject, 'ADMINISTRATION')") renameProject Even updateProject will call renameProject. Which will throws exception if user is MANAGEMENT role. The renameProject should be same security check with updateProject. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (KYLIN-2929) speed up Dump file performance
[ https://issues.apache.org/jira/browse/KYLIN-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] fengYu updated KYLIN-2929: -- Attachment: 0002-KYLIN-2929-speed-up-dump-performance-write-dump-file.patch this is my patch and test result : run the same sql three times and watch coprocessor process time. Before : 2017-10-13 16:53:34,986 INFO [kylin-coproc--pool5-t70] v2.CubeHBaseEndpointRPC:200 : Endpoint RPC returned from HTable V200_NEW_KYLIN_KIJXSDW18F Shard \x56\x32\x30\x30\x5F\x4E\x45\x57\x5F\x4B\x59\x4C\x49\x4E\x5F\x4B\x49\x4A\x58\x53\x44\x57\x31\x38\x46\x2C\x00\x01\x2C\x31\x35\x30\x37\x37\x30\x33\x35\x32\x33\x36\x39\x35\x2E\x65\x39\x37\x63\x64\x38\x34\x32\x62\x33\x61\x63\x37\x63\x66\x30\x32\x38\x31\x64\x36\x32\x66\x38\x31\x63\x62\x36\x61\x38\x64\x39\x2E on host: db-53.photo.163.org.Total scanned row: 634776. Total scanned bytes: 134956120. Total filtered/aggred row: 527872. Time elapsed in EP: 19082(ms). Server CPU usage: 0.0, server physical mem left: 1.381179392E9, server swap mem left:2.075181056E9.Etc message: start latency: 34@57,agg done@18265,compress done@19081,server stats done@19081, debugGitTag:a08e52e24c99f312eaa63bd3f9ef4cdc53fa2a67;.Normal Complete: true.Compressed row size: 13954413 2017-10-13 16:55:30,633 INFO [kylin-coproc--pool5-t72] v2.CubeHBaseEndpointRPC:200 : Endpoint RPC returned from HTable V200_NEW_KYLIN_KIJXSDW18F Shard \x56\x32\x30\x30\x5F\x4E\x45\x57\x5F\x4B\x59\x4C\x49\x4E\x5F\x4B\x49\x4A\x58\x53\x44\x57\x31\x38\x46\x2C\x00\x01\x2C\x31\x35\x30\x37\x37\x30\x33\x35\x32\x33\x36\x39\x35\x2E\x65\x39\x37\x63\x64\x38\x34\x32\x62\x33\x61\x63\x37\x63\x66\x30\x32\x38\x31\x64\x36\x32\x66\x38\x31\x63\x62\x36\x61\x38\x64\x39\x2E on host: db-53.photo.163.org.Total scanned row: 634776. Total scanned bytes: 134956120. Total filtered/aggred row: 527872. Time elapsed in EP: 17371(ms). Server CPU usage: 0.08703703703703704, server physical mem left: 1.340674048E9, server swap mem left:2.075181056E9.Etc message: start latency: 12@3,agg done@16586,compress done@17371,server stats done@17371, debugGitTag:a08e52e24c99f312eaa63bd3f9ef4cdc53fa2a67;.Normal Complete: true.Compressed row size: 13954413 2017-10-13 16:56:33,382 INFO [kylin-coproc--pool5-t74] v2.CubeHBaseEndpointRPC:200 : Endpoint RPC returned from HTable V200_NEW_KYLIN_KIJXSDW18F Shard \x56\x32\x30\x30\x5F\x4E\x45\x57\x5F\x4B\x59\x4C\x49\x4E\x5F\x4B\x49\x4A\x58\x53\x44\x57\x31\x38\x46\x2C\x00\x01\x2C\x31\x35\x30\x37\x37\x30\x33\x35\x32\x33\x36\x39\x35\x2E\x65\x39\x37\x63\x64\x38\x34\x32\x62\x33\x61\x63\x37\x63\x66\x30\x32\x38\x31\x64\x36\x32\x66\x38\x31\x63\x62\x36\x61\x38\x64\x39\x2E on host: db-53.photo.163.org.Total scanned row: 634776. Total scanned bytes: 134956120. Total filtered/aggred row: 527872. Time elapsed in EP: 17184(ms). Server CPU usage: 0.0624334964886146, server physical mem left: 1.320890368E9, server swap mem left:2.075181056E9.Etc message: start latency: 12@1,agg done@16397,compress done@17184,server stats done@17184, debugGitTag:a08e52e24c99f312eaa63bd3f9ef4cdc53fa2a67;.Normal Complete: true.Compressed row size: 13954413 After : 2017-10-13 17:01:05,660 INFO [kylin-coproc--pool5-t76] v2.CubeHBaseEndpointRPC:200 : Endpoint RPC returned from HTable V200_NEW_KYLIN_KIJXSDW18F Shard \x56\x32\x30\x30\x5F\x4E\x45\x57\x5F\x4B\x59\x4C\x49\x4E\x5F\x4B\x49\x4A\x58\x53\x44\x57\x31\x38\x46\x2C\x00\x01\x2C\x31\x35\x30\x37\x37\x30\x33\x35\x32\x33\x36\x39\x35\x2E\x65\x39\x37\x63\x64\x38\x34\x32\x62\x33\x61\x63\x37\x63\x66\x30\x32\x38\x31\x64\x36\x32\x66\x38\x31\x63\x62\x36\x61\x38\x64\x39\x2E on host: db-53.photo.163.org.Total scanned row: 634776. Total scanned bytes: 134956120. Total filtered/aggred row: 527872. Time elapsed in EP: 12253(ms). Server CPU usage: 0.0900900900900901, server physical mem left: 1.328091136E9, server swap mem left:2.075181056E9.Etc message: start latency: 33@58,agg done@11463,compress done@12253,server stats done@12253, debugGitTag:a08e52e24c99f312eaa63bd3f9ef4cdc53fa2a67;.Normal Complete: true.Compressed row size: 13954413 2017-10-13 17:02:05,746 INFO [kylin-coproc--pool5-t78] v2.CubeHBaseEndpointRPC:200 : Endpoint RPC returned from HTable V200_NEW_KYLIN_KIJXSDW18F Shard \x56\x32\x30\x30\x5F\x4E\x45\x57\x5F\x4B\x59\x4C\x49\x4E\x5F\x4B\x49\x4A\x58\x53\x44\x57\x31\x38\x46\x2C\x00\x01\x2C\x31\x35\x30\x37\x37\x30\x33\x35\x32\x33\x36\x39\x35\x2E\x65\x39\x37\x63\x64\x38\x34\x32\x62\x33\x61\x63\x37\x63\x66\x30\x32\x38\x31\x64\x36\x32\x66\x38\x31\x63\x62\x36\x61\x38\x64\x39\x2E on host: db-53.photo.163.org.Total scanned row: 634776. Total scanned bytes: 134956120. Total filtered/aggred row: 527872. Time elapsed in EP: 11394(ms). Server CPU usage: 0.09580838323353294, server physical mem left: 1.10680064E9, server swap mem left:2.075181056E9.Etc message: start latency: 12@3,agg done@10605,compress done@11394,server stats done@11394,
[jira] [Commented] (KYLIN-2530) Build cube failed with NoSuchObjectException, hive table not found 'default.kylin_intermediate_xxxx'
[ https://issues.apache.org/jira/browse/KYLIN-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203267#comment-16203267 ] Zhong Yanghong commented on KYLIN-2530: --- If fixing like so, the config will override existing job configs, which may cause other issue. > Build cube failed with NoSuchObjectException, hive table not found > 'default.kylin_intermediate_' > > > Key: KYLIN-2530 > URL: https://issues.apache.org/jira/browse/KYLIN-2530 > Project: Kylin > Issue Type: Bug >Reporter: liyang >Assignee: liyang > Fix For: v2.0.0 > > > In the mapper of "Extract Fact Table Distinct Columns" job, exception like > below is thrown. However the reported table actually exists if check at the > hive command line. > java.lang.RuntimeException: java.io.IOException: > NoSuchObjectException(message:default.kylin_intermediate_ table not found) > at > org.apache.kylin.source.hive.HiveMRInput$HiveTableInputFormat.configureJob(HiveMRInput.java:110) > at > org.apache.kylin.engine.mr.steps.FactDistinctColumnsJob.setupMapper(FactDistinctColumnsJob.java:119) > at > org.apache.kylin.engine.mr.steps.FactDistinctColumnsJob.run(FactDistinctColumnsJob.java:103) > -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (KYLIN-2936) 清理脚本会删除掉正在构建cube的中间表
[ https://issues.apache.org/jira/browse/KYLIN-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203152#comment-16203152 ] zhengdong commented on KYLIN-2936: -- Hi zhengzfand, this bug should has been fixed by KYLIN-2833. Could you please apply that patch and then have another try? > 清理脚本会删除掉正在构建cube的中间表 > > > Key: KYLIN-2936 > URL: https://issues.apache.org/jira/browse/KYLIN-2936 > Project: Kylin > Issue Type: Bug >Reporter: zhengzfand > > 清理脚本会删除掉正在构建cube的中间表,导致找不到表, > java.lang.RuntimeException: java.io.IOException: > NoSuchObjectException(message:tmp_kylin.kylin_intermediate_C_PaymentCR_Flat_clone_a3943d98_9d6c_42de_b570_7d70a216080b > table not found) > at > org.apache.kylin.source.hive.HiveMRInput$HiveTableInputFormat.configureJob(HiveMRInput.java:110) -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Comment Edited] (KYLIN-2928) PUSH DOWN query cannot use order by function
[ https://issues.apache.org/jira/browse/KYLIN-2928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16202926#comment-16202926 ] Yang Hao edited comment on KYLIN-2928 at 10/13/17 7:13 AM: --- [~yimingliu] SparkSQL or HIVE was (Author: yanghaogn): [~yimingliu] SparkSQL > PUSH DOWN query cannot use order by function > > > Key: KYLIN-2928 > URL: https://issues.apache.org/jira/browse/KYLIN-2928 > Project: Kylin > Issue Type: Improvement > Components: Query Engine >Reporter: Yang Hao >Assignee: liyang > > SQL : select "DATE",count(1) from table_1 group by "DATE" order by "DATE" > desc; > Exception:org.apache.calcite.sql.SqlOrderBy cannot be cast to > org.apache.calcite.sql.SqlSelect -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Created] (KYLIN-2936) 清理脚本会删除掉正在构建cube的中间表
zhengzfand created KYLIN-2936: - Summary: 清理脚本会删除掉正在构建cube的中间表 Key: KYLIN-2936 URL: https://issues.apache.org/jira/browse/KYLIN-2936 Project: Kylin Issue Type: Bug Reporter: zhengzfand 清理脚本会删除掉正在构建cube的中间表,导致找不到表, java.lang.RuntimeException: java.io.IOException: NoSuchObjectException(message:tmp_kylin.kylin_intermediate_C_PaymentCR_Flat_clone_a3943d98_9d6c_42de_b570_7d70a216080b table not found) at org.apache.kylin.source.hive.HiveMRInput$HiveTableInputFormat.configureJob(HiveMRInput.java:110) -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (KYLIN-2928) PUSH DOWN query cannot use order by function
[ https://issues.apache.org/jira/browse/KYLIN-2928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203117#comment-16203117 ] Yang Hao commented on KYLIN-2928: - org.apache.kylin.rest.exception.InternalErrorException: org.apache.calcite.sql.SqlOrderBy cannot be cast to org.apache.calcite.sql.SqlSelect at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440) at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:78) 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:483) 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:110) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843) 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:316) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at
[jira] [Commented] (KYLIN-2931) Update correct cardinality for the modified table
[ https://issues.apache.org/jira/browse/KYLIN-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16203113#comment-16203113 ] Wang Cheng commented on KYLIN-2931: --- [~peng.jianhua], as mentioned in KYLIN-2717, each table has a copy belongs to a project, thus table's change is also isolated, and table_ext should have the same behavior. Please try v2.2.0, this issue might have been resolved. > Update correct cardinality for the modified table > - > > Key: KYLIN-2931 > URL: https://issues.apache.org/jira/browse/KYLIN-2931 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v2.0.0 >Reporter: peng.jianhua >Assignee: peng.jianhua >Priority: Minor > Labels: patch > Attachments: > 0001-KYLIN-2931-Update-correct-cardinality-for-the-modifi.patch, 01.PNG, > 02.PNG, 03.PNG, 04.PNG, 05.PNG, 06.PNG, 07.PNG, 08.PNG, Screen Shot > 2017-10-12 at 4.32.24 PM.png > > > 1,Add project_1 and project_2; > 2,Do the following steps: > a,use 'create table kylin_sales_copy as select * from kylin_sales;' to copy > table kylin_sales; > b,load table kylin_sales_copy and calculate column cardinality in project_1 > and project_2 on the web,please refer to 06.png and 07.png,now each project > has the table kylin_sales_copy; > c,use 'drop table kylin_sales_copy;' to drop table kylin_sales_copy; > d,use 'create table kylin_sales_copy as select > TRANS_ID,PART_DT,LSTG_FORMAT_NAME,LEAF_CATEG_ID,LSTG_SITE_ID,SLR_SEGMENT_CD,PRICE > from kylin_sales where price < 20;' to create the new kylin_sales_copy table; > Now the structure of kylin_sales_copy has changed, the same as the > cardinality. > 3,Reload table kylin_sales_copy in project_1 or project_2,we found that the > cardinality is not change,please refer to 02.png. > However,I found that the new cardinality was calculated but not update on the > web by debug the code,please refer to 03.png,04.png.It should update correct > cardinality like 05.png. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
