hi Shailesh,
from your cube desc:
"rowkey": {
"rowkey_columns": [
{
"column": "SUPPKEY",
"encoding": "fixed_length:8",
"isShardBy": false
},
{
"column": "ORDERKEY",
"encoding": "fixed_length:8",
"isShardBy": false
},
{
"column": "PARTKEY",
"encoding": "fixed_length:8",
"isShardBy": false
}
]
},
if any of the three columns "SUPPKEY", "ORDERKEY", or "PARTKEY" is of
numeric type, the exception is expected. The reason is illustrated in my
previous reply.
Try to avoid applying "fixed_length" for numeric types, in fact, in our
coming new release, "fixed_length" is only valid with string types.
On Wed, Feb 8, 2017 at 2:34 PM, Shailesh Prajapati <shail...@infoworks.io>
wrote:
> Hi HongBin,
>
> Cube for which i provided logs has been deleted, So attaching description
> gist of another Cube which is giving the same error,
>
> https://gist.github.com/shaipraj/fc930e8e39be82a23d910d6388439776
>
> On Mon, Feb 6, 2017 at 7:33 PM, hongbin ma <mahong...@apache.org> wrote:
>
> > 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 | 马洪宾*
> >
>
>
>
> --
> Shailesh
>
--
Regards,
*Bin Mahone | 马洪宾*
