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:/
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]
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]
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
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.
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
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
主题:
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
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
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
[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>
请教各位:
我需要关联两个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
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
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
14 matches
Mail list logo