the substring isn't supported well in kylin(query engin)

[??????]

Hello all,    when I need to query the detail info in kylin, if the SQL 
statement inculdes 'substring' clause in where, the query will fail to execute, 
is the query engin(calcite) not very mature or Haven't I use the SQL statement 
in the true way?
e g.SQL:select substring(columnA,1,4) from table_name where 
substring(columnA,1,4)>num.


Hoping someone who can help me, thx very much!
xingchen