for example, I want to query this SQL which is wrong in kylin: select test.dim1 as c0, sum((case when t.EL_DATE <= '2015-01-01' and t.EL_TYPE = 0 then 1 else 0 end)) as m0 from test as t where t.dim1 = 'engineer' group by t.dim1
------------------ Original ------------------ From: "Hong Wei";<[email protected]>; Date: Tue, Jul 26, 2016 07:52 PM To: "dev"<[email protected]>; Subject: Can Kylin support Sub-query or Case when with SQL Dear Kylin: I want to know whether kylin is able to support sub query or case when with SQL. I have tried, but failed. Best regards.
