Hi All,

We want to use "if else" construct in kylin query.

Sample query:
SELECT f.a, IF(SUM(x) < SUM(y), SUM(x), SUM(y)) FROM kylin.test f WHERE dt
= '2016-01-19' GROUP BY f.a

As such there is no support for function signature IF(<BOOLEAN>, <NUMERIC>,
<NUMERIC>)

1. Is there any alternative way to use "if else" construct in Kylin ?
2. What standard functions are supported in Kylin? What we can expect in
future releases?  It will be help full, if i can get pointers for them.

Regards
Prashant

Reply via email to