Try to use sub-query, refer to latest one sample from FAQ page: http://kylin.incubator.apache.org/docs/gettingstarted/faq.html
Best Regards! --------------------- Luke Han On Wed, Nov 11, 2015 at 11:24 PM, Adunuthula, Seshu <[email protected]> wrote: > https://issues.apache.org/jira/browse/KYLIN-993 but yes this should be > prioritized… > > > > We have a JIRA filed for it… > > > On 11/11/15, 6:09 AM, "诸葛亮" <[email protected]> wrote: > > >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 > >
