[
https://issues.apache.org/jira/browse/KYLIN-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
peng.jianhua updated KYLIN-2931:
--------------------------------
Description:
1,Add project_1；
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.
was:
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.
> 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；
> 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)
