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

Yifei Wu updated KYLIN-3038:
----------------------------
    Description: 
when run the SQL Query in kylin like 
{code}
SELECT SUM({ fn convert("DISTANCE", SQL_DOUBLE) }) from "DEFAULT"."TABLENAME" 
group by "DESTCITYNAME" LIMIT 1000001
{code}
,
it cannot be recognized correctly


  was:
when run the SQL Query like 
{code}
SELECT SUM({ fn convert("DISTANCE", SQL_DOUBLE) }) from "DEFAULT"."TABLENAME" 
group by "DESTCITYNAME" LIMIT 1000001
,
it cannot be worked



> cannot support sum of type-converted column SQL
> -----------------------------------------------
>
>                 Key: KYLIN-3038
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3038
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: Yifei Wu
>
> when run the SQL Query in kylin like 
> {code}
> SELECT SUM({ fn convert("DISTANCE", SQL_DOUBLE) }) from "DEFAULT"."TABLENAME" 
> group by "DESTCITYNAME" LIMIT 1000001
> {code}
> ,
> it cannot be recognized correctly



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to