You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "hcy (Jira)" <ji...@apache.org> on 2020/12/01 08:09: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 ]
hcy updated KYLIN-4830:
-----------------------
Description:
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(*),
sum(price)/count(*),
avg(price)
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(*), sum(price)/count(*), avg(price) from kylin_sales group by ops_region"{color}
if not set dynamic-column,the sql query is ok.
{color:#808080} {color}
was:
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(*),
sum(price)/count(*),
avg(price)
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(*), sum(price)/count(*), avg(price) from kylin_sales group by ops_region"{color}
if not set dynamic-column,the sql query is ok.
{color:#808080} {color}
> 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
>
> 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(*),
> sum(price)/count(*),
> avg(price)
> 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(*), sum(price)/count(*), avg(price) from kylin_sales group by ops_region"{color}
> if not set dynamic-column,the sql query is ok.
>
>
> {color:#808080} {color}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)