You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2017/08/05 10:32:00 UTC

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

     [ https://issues.apache.org/jira/browse/KYLIN-2575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shaofeng SHI resolved KYLIN-2575.
---------------------------------
    Resolution: Fixed

> 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
>             Fix For: v2.1.0
>
>
> 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
(v6.4.14#64029)