Could you define "can't finish the sql query successfully"? Does the query hang? Or return with an error? Try attach kylin.log so people can analyze.
Also need your Hadoop version and Kylin version. On Fri, Oct 30, 2015 at 3:57 PM, 诸葛亮 <[email protected]> wrote: > I had a problem that I can't finish the sql query successfully when I > using the Kylin RestAPI for querying. I couldn't use "having" to filter > with many conditions after grouping. For example, There is a simple sql > statement--"select A,B,count(*) from table1 group by A,B having A=1 and B=2 > ",but I can't do it successfully. Strangely,I can do the sql--"select > A,B,count(*) from table1 group by A,B having A=1 or B=2 " successfully. My > classmates and I have talked about it,but we can't solve it. So I need > your help. > > ---------------------------------------------------------- > when A or B include substring clause,the query can not finish successfully!
