Re: select with catalog fails

Hi, Firstly, Kylin does not support catalog, so you cannot create one. The name of catalog you see is a static final filed of org.apache.kylin.rest.constant.Constant as follow: public final static String FakeCatalogName = "defaultCatalog"; You can also see getMetadata method of

Re: Kylin Interpreter on Zeppelin doesnt allow stting project name on paragraph

Hi Moises, It doesn't support project name following "%kylin" I think. The project name can only be set in the interpreter configuration with "kylin.query.project". But I agree with you that it should be flexible to support connecting with multiple projects. Would you like to report a JIRA to

答复: Segment columns and dimension columns

Thanks a lot, Shaofeng, it really helps! 发送自 Windows 10 版邮件应用 发件人: ShaoFeng Shi 发送时间: Tuesday, September 25, 2018 11:57:00 AM 收件人: user 主题: Re: Segment columns and dimension columns Right; The cuboids that have no

Re: Segment columns and dimension columns

Right; The cuboids that have no "partition_date" can be merged. Francis Liang 于2018年9月25日周二 上午11:44写道： > So the cuboids in different segments with “partition_date” included in the > dimensions can not be merged since the “partition_date” is different, is it > right? > > > > 发送自 Windows 10 版邮件

答复: Segment columns and dimension columns

So the cuboids in different segments with “partition_date” included in the dimensions can not be merged since the “partition_date” is different, is it right? 发送自 Windows 10 版邮件应用 发件人: ShaoFeng Shi 发送时间: Tuesday,

Re: Segment columns and dimension columns

If “partition_date” is not in dimension list, you couldn't query it in SQL. In this case, it is just a cursor to load data into Cube. For query please use "ORDER_DATE". Francis Liang 于2018年9月25日周二 上午11:14写道： > Hi Shaofeng, many thanks for your reply. Just to confirm that per your > example, if

Re: select with catalog fails

Hi Hari, Thanks for your comment. The default schema is supported, but please aware that the 'default' is a keyword in Calcite, so in the SQL please use "DEFAULT" to escape. For example: select count(*) from "DEFAULT".kylin_sales Regarding the catalog issue, would you like to report a JIRA to

答复: Segment columns and dimension columns

Hi Shaofeng, many thanks for your reply. Just to confirm that per your example, if the “partition_date” are only used as a partition column and not being included in the dimension list, queries including it will work exactly the same as it are included both as a partition column and in the

How to build necessary cuboids rather than building all cuboids when adding or removing one dimension

Hybrid cube does not affect all segments, and not cover removing situation. So how to build the related adding or removing dimension cuboids only?

Re: select column returns null values

Hi ShaoFeng, Thank you. I'll check that. Best Regards, Hari On Mon, 24 Sep 2018, 11:59 ShaoFeng Shi, wrote: > Hi Hari, > > You're right that Cube has joined data (from fact and lookup tables), and > then aggregate them by the dimensions. But Kylin doesn't keep the raw data > after the cube be

Re: Segment columns and dimension columns

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"

Re: [Announce] Apache Kylin 2.5.0 released

Adding a blog post to introduce this release, we encourage you to upgrade and provide feedback in the mailing list: English: https://kylin.apache.org/blog/2018/09/20/release-v2.5.0/ Chinese: https://kylin.apache.org/cn/blog/2018/09/20/release-v2.5.0/ Thanks! Billy Liu 于2018年9月19日周三 下午9:23写道：

Re: Fact table alias

Hi You, What kind of alias, can you give an example? you Zhuang 于2018年9月20日周四 上午11:43写道： > Is there a way to alias fact table when constructing model? > -- Best regards, Shaofeng Shi 史少锋

Re: select column returns null values

Hi Hari, You're right that Cube has joined data (from fact and lookup tables), and then aggregate them by the dimensions. But Kylin doesn't keep the raw data after the cube be built, only keep the cuboid (group by certain dimensions), so couldn't answer the "select * " without "group by" query.