You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@kylin.apache.org by "xwzlcb@163.com" <xw...@163.com> on 2021/06/11 06:58:09 UTC

子查询case when 问题

子查询case when 问题：

子查询嵌套后聚合值丢失，子查询中多个case when最后结果只有case when中的第一行值，且对case when后的值筛选不生效；

另外一条语句最后返回success，但无结果数据

  
发自我的荣耀手机

Re: 子查询case when 问题

Posted by Yaqian Zhang <Ya...@126.com>.

Hi：

I can't understand the problem you described. Please clearly describe your SQL statement and provide a screenshot of the query when there is a problem and a comparison between the correct result and the wrong result.

 In addition, providing the kylin version you are using can help others reproduce this problem.

> 在 2021年6月11日，14:58，xwzlcb@163.com 写道：
> 
> 子查询case when 问题：
> 子查询嵌套后聚合值丢失，子查询中多个case when最后结果只有case when中的第一行值，且对case when后的值筛选不生效；
> 另外一条语句最后返回success，但无结果数据
> 
> 发自我的荣耀手机