Can Kylin support Sub-query or Case when with SQL

[Hong Wei]

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.