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)