HI, sorry,my English very pool. I have some problem when I do demo. I want take some fields to percent function. For example: table1 id host pid 1 local 321 2 local 123 3 google 987 4 google 789 SELECT (SUM(CASE WHEN (host="local") then 1 else 0 end)/count(*)*100) as hostpercent FROM table1 The sql result is 50%. Mysql or hive can do this,but i don't know does kylin support this action? please help me, thank you!
- Does Kylin support percent function? 陈光亮
- Re: Does Kylin support percent function? Alberto Ramón
- Re: Does Kylin support percent function? ShaoFeng Shi