?????? flink sql count????

Tue, 29 Sep 2020 02:51:41 -0700 

????????????????????????????????????????????????????????????????????????????????????????count????????????0
????????flink????count??????????????????????????????????????????if????????????????????????where??????????
?????? select count(if(name like '????%',1 , null)) where name 
like '????%'  or name like '????%'  group by ** ????


------------------ ???????? ------------------
??????:                                                                         
                                               "user-zh"                        
                                                            
<vincent2015q...@outlook.com&gt;;
????????:&nbsp;2020??9??29??(??????) ????5:32
??????:&nbsp;"user-zh"<user-zh@flink.apache.org&gt;;

????:&nbsp;Re: flink sql count????



Hi lemon,
&nbsp;&nbsp;&nbsp; ????????if??????????????case when

Best??
Robin


lemon wrote
&gt; ??????????
&gt; 
????????sql????????????count????count????????????????????count????????????????
&gt; ??????hive??????????????count(if(name like '????%',1 , null))??????flink
&gt; sql??count??????null????????????????????????????????
&gt; ????????flink1.10.1 blink
&gt; &amp;nbsp;





--
Sent from: http://apache-flink.147419.n8.nabble.com/

回复