You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Xiaoxiang Yu (Jira)" <ji...@apache.org> on 2021/02/20 08:38:00 UTC
[jira] [Updated] (KYLIN-4830) avg(metric) error when dynamic column
is set true
[ https://issues.apache.org/jira/browse/KYLIN-4830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiaoxiang Yu updated KYLIN-4830:
--------------------------------
Fix Version/s: v3.1.2
> avg(metric) error when dynamic column is set true
> -------------------------------------------------
>
> Key: KYLIN-4830
> URL: https://issues.apache.org/jira/browse/KYLIN-4830
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v3.1.0
> Reporter: hcy
> Priority: Major
> Fix For: v3.1.2
>
>
> When set kylin.query.enable-dynamic-column=true,avg() is error.
> Test Cube is kylin sample cube "KYLIN_SALES_CUBE",
> test sql:
> select ops_region,
> sum(price),
> count(1),
> sum(price)/count(1),
> {color:#FF0000}avg(price){color}
> from kylin_sales
> group by ops_region
> error log:
> {color:#b94a48}Can't find $4 from child columnrowtype while executing SQL: "select ops_region, sum(price), count(1), sum(price)/count(1), avg(price) from kylin_sales group by ops_region"{color}
> if no avg(price) or not set dynamic-column,the sql query is ok.
>
>
> {color:#808080} {color}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)