[jira] [Commented] (KYLIN-2575) Experimental feature: Computed Column

["yuzhang qiu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-2575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16751067#comment-16751067 ] 

yuzhang qiu commented on KYLIN-2575:
------------------------------------

Our group add the computed column feature based on Kylin2.5.2. We define the computed column on DataSource page and add the computed column data into table detail metadata.

> Experimental feature: Computed Column
> -------------------------------------
>
>                 Key: KYLIN-2575
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2575
>             Project: Kylin
>          Issue Type: New Feature
>            Reporter: hongbin ma
>            Assignee: hongbin ma
>            Priority: Major
>
> Computed column is a virtual column that is calculated from an expression of existing columns. For example, TAX is computed from PRICE * TAX_RATE; TX_YEAR is from EXTRACT(year from TX_DATE).
> Currently user have to create a view to enrich these computed columns, then feed the view to cube. This has two inconvenience:
> Create a view is not easy.
> The query has to be rewritten to use view instead of the original table.
> Let Kylin directly support computed column will be a big step forward.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)