[jira] [Updated] (KYLIN-4831) sql error when max/min/sum param is constant

["Xiaoxiang Yu (Jira)" <ji...@apache.org>]

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

Xiaoxiang Yu updated KYLIN-4831:
--------------------------------
    Fix Version/s: v3.1.2

> sql error when max/min/sum param is constant
> --------------------------------------------
>
>                 Key: KYLIN-4831
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4831
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v3.1.0
>            Reporter: hcy
>            Priority: Major
>             Fix For: v3.1.2
>
>
> 如果聚合函数中是常量(字符串或数字)时，报cube未命中的错误。
> 通过在DefaultQueryTransformer中正则匹配转换可以解决部分问题，如max('aaa')=>'aaa',sum(10)=>10*count(1).
> 但是怎么样从后端解决呢？因为从前端通过正则替换的方式解决会面临一些问题，如{color:#172b4d}SUM(cast(1.22 as bigint)){color}) 会替换为1.22*count(1)，没有达到数据转换cast的效果，当然也可以匹配出bigint从前端做转换，但总觉得在后端做会更好更彻底。在某些查询场景下，这类SQL无法避免。
> test cube "KYLINS_SALES_CUBE"
> test sql:
> select ops_region,
>  max('AAA'),
>  min('AAA'),
>  sum(10)
> from kylin_sales
> group by ops_region
> error log:
> {color:#b94a48}No realization found for OLAPContext, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_UNMATCHED_AGGREGATION[FunctionDesc [expression=MIN, parameter=UNKNOWN_MODEL:DEFAULT._KYLIN_TABLE.AAA, returnType=null], FunctionDesc [expression=MAX, parameter=UNKNOWN_MODEL:DEFAULT._KYLIN_TABLE.AAA, returnType=null]], CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_READY, rel#482:OLAPTableScan.OLAP.[](table=[DEFAULT, KYLIN_SALES],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]) while executing SQL: "select ops_region, max('AAA'), min('AAA'), 10*count(1) from kylin_sales group by ops_region"{color}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)