hi Shailesh,
can you please attach the cube description? It can be found by click on the cube and find "CUBE(json)". I guess you're using fixed_length encoding for integer type column ORDER_ID, such setting is found to be buggy( https://issues.apache.org/jira/browse/KYLIN-2179) On Sun, Feb 5, 2017 at 9:42 PM, Shailesh Prajapati <shail...@infoworks.io> wrote: > What should i supposed to do now to make query work with limits? Because i > am keep getting this exception. What will happen if we remove this check? > > Thanks. > > On Sat, Feb 4, 2017 at 8:12 PM, ShaoFeng Shi <shaofeng...@apache.org> > wrote: > > > I don't know what that check is necessary, as there is a todo which says > > will remove that someday: > > https://github.com/apache/kylin/blob/master/core- > > storage/src/main/java/org/apache/kylin/storage/gtrecord/ > > SortedIteratorMergerWithLimit.java#L127 > > > > @Hongbin, any idea? > > > > > > 2017-02-04 17:05 GMT+08:00 Shailesh Prajapati <shail...@infoworks.io>: > > > > > Hi ShaoFeng, > > > > > > Here is the gist link, > > > > > > https://gist.github.com/shaipraj/780a3dcc80aa2080911b7348c76f5b88 > > > > > > Thanks. > > > > > > On Sat, Feb 4, 2017 at 2:24 PM, ShaoFeng Shi <shaofeng...@apache.org> > > > wrote: > > > > > > > Hi Shailesh, there is no attachement (attachement isn't supported by > > > > mailing list); can you paste the content directly or put it to gist? > > > > > > > > 2017-02-04 15:49 GMT+08:00 Shailesh Prajapati <shail...@infoworks.io > >: > > > > > > > > > Hi ShaoFeng, > > > > > > > > > > I am attaching a portion of kylin's log. > > > > > > > > > > Thanks. > > > > > > > > > > On Sat, Feb 4, 2017 at 12:59 PM, ShaoFeng Shi < > > shaofeng...@apache.org> > > > > > wrote: > > > > > > > > > >> Hi Shailesh, > > > > >> > > > > >> Could you please provide the error trace? We need to know where > the > > > > error > > > > >> got thrown. Thanks. > > > > >> > > > > >> 2017-02-03 18:06 GMT+08:00 Shailesh Prajapati < > > shail...@infoworks.io > > > >: > > > > >> > > > > >> > Hi, > > > > >> > > > > > >> > We are running Kylin 1.6 and successfully build Cube on it. > > > Aggregate > > > > >> > queries are running fine But, with non aggregate query we are > > > getting > > > > >> > following exception, > > > > >> > > > > > >> > org.apache.kylin.rest.exception.InternalErrorException: Not > > sorted! > > > > >> last: > > > > >> > CUSTOMER_ID=0,ORDER_ID=10345,QUANTITY=null ... and other > columns. > > > > >> > > > > > >> > Query used: select ORDERS.STATUS from ORDER_DETAILS as ORDERS > > limit > > > 5; > > > > >> > > > > > >> > One more observation, with limit less than 5 even non aggregate > > > > queries > > > > >> are > > > > >> > also working. > > > > >> > Please help us resolving this issue. let us know for any other > > > > >> information. > > > > >> > > > > > >> > Thanks > > > > >> > > > > > >> > > > > >> > > > > >> > > > > >> -- > > > > >> Best regards, > > > > >> > > > > >> Shaofeng Shi 史少锋 > > > > >> > > > > > > > > > > > > > > > > > > > > -- > > > > > Shailesh > > > > > > > > > > > > > > > > > > > > > -- > > > > Best regards, > > > > > > > > Shaofeng Shi 史少锋 > > > > > > > > > > > > > > > > -- > > > Shailesh > > > > > > > > > > > -- > > Best regards, > > > > Shaofeng Shi 史少锋 > > > > > > -- > Shailesh > -- Regards, *Bin Mahone | 马洪宾*