?????? [KYLIN-1668] - Rowkey column shouldn??t allow delete and add

2017-09-15 Thread ???????? 
Thanks




--  --
??: "Billy Liu";;
: 2017??9??15??(??) 6:32
??: "dev"; 

: Re: [KYLIN-1668] - Rowkey column shouldn??t allow delete and add



1. Use Derived Dimension will reduce the number of rowkey, but also may
hurt the query performance.
2. Increase the threshold of the HBase region size,
# The cut size for hbase region, in GB.
kylin.storage.hbase.region-cut-gb=5

3. Split the large cube into two small cubes according to your query
patterns.

2017-09-15 14:28 GMT+08:00  <838279...@qq.com>:

> We have more dimensions, and can reach more than 20, so the number of
> region will be much larger, and rowkey also accounts for a lot, so how to
> reduce the HBase region count?
>
>
> --  --
> ??: "Billy Liu";;
> : 2017??9??15??(??) 2:24
> ??: "dev";
>
> : Re: [KYLIN-1668] - Rowkey column shouldn??t allow delete and add
>
>
>
> Rowkey is the physical format of dimensions.
>
> 2017-09-15 12:55 GMT+08:00  <838279...@qq.com>:
>
> > If you don't want to delete the dimension, how do you delete some rowkey?
> >
> >
> > --  --
> > ??: "Billy Liu";;
> > : 2017??9??15??(??) 12:51
> > ??: "dev";
> >
> > : Re: [KYLIN-1668] - Rowkey column shouldn??t allow delete and add
> >
> >
> >
> > Rowkey is generated by the chosen dimensions. If you want to remove some
> > rowkey, remove the dimension will work.
> >
> > 2017-09-15 11:54 GMT+08:00  <838279...@qq.com>:
> >
> > > [KYLIN-1668] - Rowkey column shouldn??t allow delete and add
> > > Kylin new version 2.1, this problem still exists??cannot delete
> >
>

[jira] [Created] (KYLIN-2873) relate to KYLIN-1351, no document for configure rdbms as datasource

2017-09-15 Thread Maxy (JIRA) 
Maxy created KYLIN-2873:
---

 Summary: relate to KYLIN-1351, no document for configure rdbms as 
datasource
 Key: KYLIN-2873
 URL: https://issues.apache.org/jira/browse/KYLIN-2873
 Project: Kylin
  Issue Type: Improvement
  Components: Documentation
Affects Versions: v2.1.0
Reporter: Maxy






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

[jira] [Created] (KYLIN-2872) Incorrect argument order in CubeManager#calculateHoles()

2017-09-15 Thread Ted Yu (JIRA) 
Ted Yu created KYLIN-2872:
-

 Summary: Incorrect argument order in CubeManager#calculateHoles()
 Key: KYLIN-2872
 URL: https://issues.apache.org/jira/browse/KYLIN-2872
 Project: Kylin
  Issue Type: Bug
Reporter: Ted Yu
Priority: Minor


{code}
if (first.isOffsetCube()) {
hole.setSegRange(new SegmentRange(first.getSegRange().end, 
second.getSegRange().start));
{code}
The arguments to SegmentRange are reversed.



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

Re: [KYLIN-1668] - Rowkey column shouldn’t allow delete and add

2017-09-15 Thread Billy Liu 
1. Use Derived Dimension will reduce the number of rowkey, but also may
hurt the query performance.
2. Increase the threshold of the HBase region size,
# The cut size for hbase region, in GB.
kylin.storage.hbase.region-cut-gb=5

3. Split the large cube into two small cubes according to your query
patterns.

2017-09-15 14:28 GMT+08:00 谁主沉浮 <838279...@qq.com>:

> We have more dimensions, and can reach more than 20, so the number of
> region will be much larger, and rowkey also accounts for a lot, so how to
> reduce the HBase region count?
>
>
> -- 原始邮件 --
> 发件人: "Billy Liu";;
> 发送时间: 2017年9月15日(星期五) 下午2:24
> 收件人: "dev";
>
> 主题: Re: [KYLIN-1668] - Rowkey column shouldn’t allow delete and add
>
>
>
> Rowkey is the physical format of dimensions.
>
> 2017-09-15 12:55 GMT+08:00 谁主沉浮 <838279...@qq.com>:
>
> > If you don't want to delete the dimension, how do you delete some rowkey?
> >
> >
> > -- 原始邮件 --
> > 发件人: "Billy Liu";;
> > 发送时间: 2017年9月15日(星期五) 中午12:51
> > 收件人: "dev";
> >
> > 主题: Re: [KYLIN-1668] - Rowkey column shouldn’t allow delete and add
> >
> >
> >
> > Rowkey is generated by the chosen dimensions. If you want to remove some
> > rowkey, remove the dimension will work.
> >
> > 2017-09-15 11:54 GMT+08:00 谁主沉浮 <838279...@qq.com>:
> >
> > > [KYLIN-1668] - Rowkey column shouldn’t allow delete and add
> > > Kylin new version 2.1, this problem still exists，cannot delete
> >
>

Review Request 62346: KYLIN-2870 Shortcut key description is error at Kylin-Web

2017-09-15 Thread pengjianhua 

---
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/62346/
---

Review request for kylin, Dayue Gao, Dong Li, hongbin ma, and Wang Xiaoyu.


Bugs: KYLIN-2870
https://issues.apache.org/jira/browse/KYLIN-2870


Repository: kylin


Description
---

Shortcut key description is error at Kylin-Web?when i click Ctrl+Shift+Space to 
create a sql.
Please see 1.jpg.


Diffs
-

  webapp/app/partials/query/query.html 894113e0d 


Diff: https://reviews.apache.org/r/62346/diff/1/


Testing
---


Thanks,

pengjianhua

[jira] [Created] (KYLIN-2870) Shortcut key description is error at Kylin-Web

2017-09-15 Thread peng.jianhua (JIRA) 
peng.jianhua created KYLIN-2870:
---

 Summary: Shortcut key description is error at Kylin-Web
 Key: KYLIN-2870
 URL: https://issues.apache.org/jira/browse/KYLIN-2870
 Project: Kylin
  Issue Type: Bug
  Components: Web 
Affects Versions: v2.1.0
Reporter: peng.jianhua
Assignee: peng.jianhua


Shortcut key description is error at Kylin-Web，when i click Ctrl+Shift+Space to 
create a sql.
Please see 1.jpg.



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

?????? [KYLIN-1668] - Rowkey column shouldn??t allow delete and add

2017-09-15 Thread ???????? 
We have more dimensions, and can reach more than 20, so the number of region 
will be much larger, and rowkey also accounts for a lot, so how to reduce the 
HBase region count?


--  --
??: "Billy Liu";;
: 2017??9??15??(??) 2:24
??: "dev"; 

: Re: [KYLIN-1668] - Rowkey column shouldn??t allow delete and add



Rowkey is the physical format of dimensions.

2017-09-15 12:55 GMT+08:00  <838279...@qq.com>:

> If you don't want to delete the dimension, how do you delete some rowkey?
>
>
> --  --
> ??: "Billy Liu";;
> : 2017??9??15??(??) 12:51
> ??: "dev";
>
> : Re: [KYLIN-1668] - Rowkey column shouldn??t allow delete and add
>
>
>
> Rowkey is generated by the chosen dimensions. If you want to remove some
> rowkey, remove the dimension will work.
>
> 2017-09-15 11:54 GMT+08:00  <838279...@qq.com>:
>
> > [KYLIN-1668] - Rowkey column shouldn??t allow delete and add
> > Kylin new version 2.1, this problem still exists??cannot delete
>

Re: [KYLIN-1668] - Rowkey column shouldn’t allow delete and add

2017-09-15 Thread Billy Liu 
Rowkey is the physical format of dimensions.

2017-09-15 12:55 GMT+08:00 谁主沉浮 <838279...@qq.com>:

> If you don't want to delete the dimension, how do you delete some rowkey?
>
>
> -- 原始邮件 --
> 发件人: "Billy Liu";;
> 发送时间: 2017年9月15日(星期五) 中午12:51
> 收件人: "dev";
>
> 主题: Re: [KYLIN-1668] - Rowkey column shouldn’t allow delete and add
>
>
>
> Rowkey is generated by the chosen dimensions. If you want to remove some
> rowkey, remove the dimension will work.
>
> 2017-09-15 11:54 GMT+08:00 谁主沉浮 <838279...@qq.com>:
>
> > [KYLIN-1668] - Rowkey column shouldn’t allow delete and add
> > Kylin new version 2.1, this problem still exists，cannot delete
>