答复: error with send mail

2019-08-07 Thread 02
w.smart-etech.tn/> P: +216 27 782 201 khalilme...@istic.u-carthage.tn<mailto:khalilme...@istic.u-carthage.tn> - www.smart-etech.tn<http://www.smart-etech.tn/> Technopark Borj Cedria [图像已被发件人删除。 Facebook icon]<https://www.facebook.com/eTechSmart/> [图像已被发件人删除。 LinkedIn icon] <https:/

error with send mail

2019-08-07 Thread 02
Hello, I have set the mail-port , but it is still 25 . Please tell me where to modify it. Thank you very much. Best regards, YangGao [cid:image001.png@01D54D47.EBD9BD70] [cid:image002.png@01D54D47.EBD9BD70]

error with send mail

2019-08-07 Thread 02
Hello, I have set the mail-port , but it is still 25 . Please tell me where to modify it. Thank you very much. Best regards, YangGao [cid:image001.png@01D54D43.54872BF0] [cid:image002.png@01D54D43.54872BF0]

答复: Where the high cardinality dimension should be placed in the rowkey

2019-07-15 Thread 02
rowkey If those dimensions before the two with high cardinality will be used for filtering, maybe, you are right. [image.png] On Mon, Jul 15, 2019 at 2:49 PM 高扬02 mailto:gaoyan...@bianfeng.com>> wrote: Hello, I have two high cardinality dimensions , which only “group by bmid_user”, but no

Where the high cardinality dimension should be placed in the rowkey

2019-07-14 Thread 02
Hello, I have two high cardinality dimensions , which only “group by bmid_user”, but no “where bmid_user in (xx,xx)”, so I put them in the end of rowkeys. Is this right? [cid:image001.png@01D53B1C.83B025A0] Thanks very much.

答复: How to use EXTENDED_COLUMN?

2019-04-29 Thread 02
dev-subscr...@kylin.apache.org<mailto:dev-subscr...@kylin.apache.org> 高扬02 mailto:gaoyan...@bianfeng.com>> 于2019年4月26日周五 下午3:50写道: Hello, By the way, in the situation "select host_column , extended_column where host_column..", which is more efficient, extende

转发: How to use EXTENDED_COLUMN?

2019-04-26 Thread 02
Hello, By the way, in the situation "select host_column , extended_column where host_column..", which is more efficient, extended_column or joint_dimensions? Thanks a lot. Best regards. 发件人: 高扬02 [mailto:gaoyan...@bianfeng.com] 发送时间: 2019年4月26日 15:19 收件人: user@kylin.apache.org 主题:

How to use EXTENDED_COLUMN?

2019-04-26 Thread 02
Hello, Kylin 2.6.0. As the picture , I set dayplus2 as EXTENDED_COLUMN , and data_day is the dimension and host column. But how to query with them? I queryed dayplus2 with filtered data_day , but it has no result. Please show me how to query the extended_column , thanks a lot. Best regards. [ci

答复: 答复: 答复: cube关联后的distinct问题

2018-10-29 Thread 02
these two tables.(Maybe union them, that might solve you question.) After that you can define a new cube use that view. Wish that could be help. Best wishes, Xiaoxiang Yu 发件人: 高扬02 mailto:gaoyan...@bianfeng.com>> 答复: "user@kylin.apache.org<mailto:user@ky

答复: 答复: cube关联后的distinct问题

2018-10-29 Thread 02
r_id which occur in both two sides. If what I understand is correct, I guess you should enable query pushdown to let other sql engine to do such task. Best wishes, Xiaoxiang Yu 发件人: 高扬02 mailto:gaoyan...@bianfeng.com>> 答复: "user@kylin.apache.org<mail

答复: cube关联后的distinct问题

2018-10-29 Thread 02
[http://kylin.apache.org/docs/gettingstarted/faq.html] Is Kylin a generic SQL engine for big data? * No, Kylin is an OLAP engine with SQL interface. The SQL queries need be matched with the pre-defined OLAP model. Xiaoxiang Yu 发件人: 高扬02 mailto:gaoyan...@bianfeng.com>

cube关联后的distinct问题

2018-10-25 Thread 02
请教各位: 我需要关联两个fact表,所以目前是分别构建两个cube,要关联的字段为user_id,我将它设置同时为dimension和measure,以便可以取得明细(dimension)和计算count_distinct(measure),且不用开启query-push-down 但两个子查询分别命中了对应的cuboid,可是最外层去重查询报错,未知原因? sql如下: select count(distinct a.r_id) from (select r.user_id as r_id,l.user_id as l_id from (select user_id from reg

答复: how to define a snowflake model

2018-10-18 Thread 02
the query pattern between your two "fact" tables is fixed, just like factA left join with factB. You could define factB as lookup table and skip the snapshot for this huge lookup table. With Warm regards Billy Liu 高扬02 于2018年10月18日周四 上午11:36写道: > > Kylin 2.5. > > How to de

how to define a snowflake model

2018-10-17 Thread 02
Kylin 2.5. How to define a snowflake model ? I did not find the place to set it. I have two fact tables , now I must create two cubes , and query “cube join cube”. To query the raw data of the measure column for “join” sql ,Now I set the measure column to be the dimension column also,because it t