kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yifei Wu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (KYLIN-3217) Dimension As Measures should only support Max and Min when the first table in select SQL is fact table
Date Wed, 31 Jan 2018 12:58:00 GMT

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

Yifei Wu updated KYLIN-3217:
----------------------------
    Description: DemensionAsMeaures is a way to get the SQL query's result directly through
making use of Calcite, when several special measures cannot be matched with the pre-calculated
cube. But it should only support the Max and Min when selected from the fact table, because
the data in cubes has been aggregated so as to inaccurate results.  (was: DemensionAsMeaures
is a way to get the SQL query's result directly through making use of Calcite, when several
special measures cannot be matched with the pre-calculated cube. But it should only support
the Max and Min because the data in cubes has been aggregated so as to unaccurate result.)

> Dimension As Measures should only support Max and Min when the first table in select
SQL is fact table
> ------------------------------------------------------------------------------------------------------
>
>                 Key: KYLIN-3217
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3217
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: Yifei Wu
>            Assignee: Yifei Wu
>            Priority: Minor
>
> DemensionAsMeaures is a way to get the SQL query's result directly through making use
of Calcite, when several special measures cannot be matched with the pre-calculated cube.
But it should only support the Max and Min when selected from the fact table, because the
data in cubes has been aggregated so as to inaccurate results.



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

Mime
View raw message