Hi Feng, Usually, the partition date column is a dimension.
But it is not required. For example, your table has two date columns: "partition_date" and "order_date"; You data is partitioned with the "partition_date" in Hive, so you'd better use the same in Kylin, but you can use the "order_date" as a dimension and "partition_date" not in dimension list. Francis Liang <[email protected]> 于2018年9月19日周三 下午3:13写道： > Hi: > > > > I am having a question regarding two types of columns mentioned above. If > I am using a column as a segment column, such as DAY, and it’s required as > the filter in queries, should I also put it in the dimension columns, or is > it redundant to do so? If it’s included in the dimension columns, does it > mean the records from different segments can’t be merged since the DAY > field is different (DAY=20180918, DAY=20180919)? > > > > Thanks for your help! > > > > Best, Feng. > > > > 发送自 Windows 10 版邮件 <https://go.microsoft.com/fwlink/?LinkId=550986>应用 > > > -- Best regards, Shaofeng Shi 史少锋
