why query will be push down when query a dimension table's dimension values

2019-06-10 Thread lk_hadoop
hi , all: My model json string is : { "uuid": "c28014c1-7dae-6900-6264-8794b683ffa7", "last_modified": 1560153343761, "version": "2.6.1.0", "name": "scrm_model", "owner": "ADMIN", "is_draft": false, "description": "###", "fact_table": "GJST.SH_FETCH_SALE_BASE_FACT_ALL_NEW",

Re: 请问怎么退订邮件

2019-06-10 Thread ShaoFeng Shi
Hello, Please send an empty email to dev-unsubscr...@kylin.apache.org, then it will reply to confirm with you. Just reply that email to confirm the unsubscription. The process for u...@kylin.apache.org mailing list is the same, just replace "dev" with "user". Best regards, Shaofeng Shi 史少锋

Re: cube-rowkey排序咨询

2019-06-10 Thread JiaTao Tao
And this link( https://www.slideshare.net/YangLi43/design-cube-in-apache-kylin) that Shaofeng previous shared is also very helpful, see this chapter: "The Order of Dimensions" -- Regards! Aron Tao Xiaoxiang Yu 于2019年6月11日周二 上午2:45写道: > Hi, wangfx > > Kylin converts sql query to two

Re: ask about kylin 3.0 Go-Live Date

2019-06-10 Thread ShaoFeng Shi
Hello Bryan, Kylin 3.0 alpha has been released; now the beta version is coming soon. Have you tried the alpha version, or have you encounter any problem with it? You can download it from Kylin website, and the document is also there: https://kylin.apache.org/download/

Re: cube-rowkey排序咨询

2019-06-10 Thread Xiaoxiang Yu
Hi, wangfx Kylin converts sql query to two parameters(Start_key and end_key) in the range Scan operation in HBase. The well-designed Rowkey will more effectively complete the query filtering and positioning of the data, reduce the number of IO, improve the query speed, the order of the

ask about kylin 3.0 Go-Live Date

2019-06-10 Thread Bryan Liu (CN)
Dears, I am from company Homecredit China . I would like to ask when new version 3.0 of kylin will launch? Due to we are finding some realtime olap solution recently. Waiting for your feedback. Thank you Best Regards Bryan.liu Homecredit CN, Tianjing, China.

[jira] [Created] (KYLIN-4039) ZookeeperDistributedLock may not release lock when unlock operation was interrupted

2019-06-10 Thread PENG Zhengshuai (JIRA)
PENG Zhengshuai created KYLIN-4039: -- Summary: ZookeeperDistributedLock may not release lock when unlock operation was interrupted Key: KYLIN-4039 URL: https://issues.apache.org/jira/browse/KYLIN-4039

[New blog] Kylin upgrade from 2.4.1 to 2.6.1

2019-06-10 Thread ShaoFeng Shi
Hello Kylin users, A new article from community user Iñigo Martinez has been published on Kylin website. In this article, Iñigo introduces his experience on how to prepare and carry out an upgrade from Kylin v2.4 to v2.6 with minimal downtime and low risk. He also shared his feelings with the

Re: How to handle data updates?

2019-06-10 Thread Billy Liu
The best practice is keep the easy to update data in small segments, for example, the last 2 days data in one segment, and last 7 days in another segment. If some source data is updated, only the smaller segments are required to refresh. The cost is acceptable. With Warm regards Billy Liu

cube-rowkey????????

2019-06-10 Thread wangfx
cubea??b??whereb??(3??)??c??d??whereselect??group byc>d>a>b??where??rowkey??abcd

Re:How to handle data updates?

2019-06-10 Thread nichunen
Hi Praveen, Kylin has no feature currently to deal with data update, you should refresh the specified segment in which time range data update happens. Best regards, Ni Chunen / George On 06/11/2019 09:20,Praveen Yadav wrote: Hi Team, We have a use case where we have a requirement for

Re: ORC lookup tables missed in cube calculation.

2019-06-10 Thread Xiaoxiang Yu
Thanks for reporting, we will examined it closely. Best wishes, Xiaoxiang Yu 在 2019/6/11 01:22,“Александр Сидорчук” 写入: Hello, Please help wuth solution finding. ORC is the best way to store data in hive. But we have a blocking issue on that. Please look

How to handle data updates?

2019-06-10 Thread Praveen Yadav
Hi Team, We have a use case where we have a requirement for OLAP cube. One specific requirement is that there can be updates to the data. How to handle data updates? Do we need to rebuild cube everytime there is an data update or kylin can handle updates automatically? Please advise. Thanks,

Row Level Security and Column Level security on Kylin

2019-06-10 Thread bajpais
Hi all , I have a requirement to implement row level security and column level security on Kylin cube. Is this possible? I would appreciate if someone can share their approach as to how they implemented this for their use case? I am not sure if we can create a view on top of cube to implement the

ORC lookup tables missed in cube calculation.

2019-06-10 Thread Александр Сидорчук
Hello, Please help wuth solution finding. ORC is the best way to store data in hive. But we have a blocking issue on that. Please look into it: https://issues.apache.org/jira/browse/KYLIN-4038 i've checked already source code, and looks like the problem in HCatalog, that used by Kylin. But i

[jira] [Created] (KYLIN-4037) Can't Cleanup Data in Hbase's HDFS Storage When Deploy Apache Kylin with Standalone HBase Cluster

2019-06-10 Thread wangxiaojing (JIRA)
wangxiaojing created KYLIN-4037: --- Summary: Can't Cleanup Data in Hbase's HDFS Storage When Deploy Apache Kylin with Standalone HBase Cluster Key: KYLIN-4037 URL: https://issues.apache.org/jira/browse/KYLIN-4037