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

[??????]

I can not solve it in sub-query,because the substring function can't use in any 
situation in where clause,so I had to add column in hive to avoid this problem, 
such as add a column like substring(columnA exists in sourceTable,0,4) as new 
column in hive table,and only in this way can I query this column without any 
substring function.
Thanks for helping!
xingchen