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] Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] 高扬02 <[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]] > *发送时间:* 2019年4月26日 15:19 > *收件人:* [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. > > > > > >
