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!




 

Reply via email to