Re: Cube query failing on changing rowkeys column order

>From the error log, the cube metadata seems inconsistent. Was the cube JSON manually edited? On Tue, Apr 4, 2017 at 5:32 PM, Shailesh Prajapati wrote: > Thanks for the reply. Its just not about query performance, my queries are > not working. I am actually trying with

Re: Cube query failing on changing rowkeys column order

The recommend number of Dim can be 12 or less (depends on a lot of things) Keep in mind that derived dim, are not real Dim because no are included in the cube --> que queries will be slow than normal dim http://kylin.apache.org/docs/howto/howto_optimize_cubes.html

Re: Cube query failing on changing rowkeys column order

Thanks for the reply. Its just not about query performance, my queries are not working. I am actually trying with only 50 fact rows. As per my understanding, query should not fail with any order of rowkeys. On Tue, Apr 4, 2017 at 2:46 PM, Alberto Ramón wrote: > hello,

Re: Cube query failing on changing rowkeys column order

hello, from http://kylin.apache.org/docs16/tutorial/create_cube.html "You can drag & drop a dimension column to adjust its position in rowkey; Put the mandantory dimension at the begining, then followed the dimensions that heavily involved in filters (where condition). Put high cardinality

Cube query failing on changing rowkeys column order

Hi, I am using kylin 1.6 and facing a wired issue with Cube description. Basically, I have two Cube desc having same dimensions, measures, rowkeys, aggregation groups. The only difference is the ordering of keys in them. With first cube description, my queries are working and with second i am

Cube query failing on changing rowkeys column order

Hi, I am using kylin 1.6 and facing a wired issue with Cube description. Basically, I have two Cube desc having same dimensions, measures, rowkeys, aggregation groups. The only difference is the ordering of keys in them. With first cube description, my queries are working and with second i am