[
https://issues.apache.org/jira/browse/KYLIN-2575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shaofeng SHI updated KYLIN-2575:
Description:
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.
was:
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/KAP directly support computed column will be a big step forward.
> 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)
