Hi Shaofeng, Sorry for not replying to this email in time. I searched for " kylin extended column". Some articles introduced the extended column but did not use it , But then I've tried out the usage for the query of the extended column myself. I have also searched the several articles you mentioned, which can serve as a reference for my case. Thank you very much.
Best regards, GaoYang 发件人: ShaoFeng Shi [mailto:[email protected]] 发送时间: 2019年4月30日 10:24 收件人: user <[email protected]> 主题: Re: How to use EXTENDED_COLUMN？ Hi Gaoyang, If you search "Apache Kylin" + "Extended column", there are a couple of related articles, like: http://apache-kylin.74782.x6.nabble.com/Consulting-quot-EXTENDED-COLUMN-quot-td6463.html https://blog.bcmeng.com/post/kylin-dimension.html#extended-column https://www.cnblogs.com/double-kill/p/8371595.html Regarding "which is more efficient, extended_column or joint_dimensions", I think "extended_column" is better because with it the HBase rowkey will be shorter; while "joint_dimension" will add both of the columns into the rowkey, which will impact HBase scan performance. Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: [email protected]<mailto:[email protected]> Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected]<mailto:[email protected]> Join Kylin dev mail group: [email protected]<mailto:[email protected]> 高扬02 <[email protected]<mailto:[email protected]>> 于2019年4月26日周五 下午3:50写道： 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:[email protected]<mailto:[email protected]>] 发送时间: 2019年4月26日 15:19 收件人: [email protected]<mailto:[email protected]> 主题: How to use EXTENDED_COLUMN？ 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. [cid:[email protected]] [cid:[email protected]]
