if you could give some sample data only and make sure the issue can be reproduceable on the sample data
On Thu, Sep 24, 2015 at 12:28 PM, vipul jhawar <[email protected]> wrote: > hi > > For the cube > > JSON model is > http://www.jsoneditoronline.org/?id=1da42fe018b14c7522d3937ba81cd37e > JSON cube is > http://www.jsoneditoronline.org/?id=97008080361a2388888acd128004753d > > On minimal data for the cube, even if we generate it how will we share it > with you ? or you want sample fact table. > I can show you the kylin query in play on our current cube which is hosted > if you want. > > Thanks > > On Wed, Sep 23, 2015 at 1:54 PM, hongbin ma <[email protected]> wrote: > > > Hi, > > > > We cannot reproduce it with our test cases. > > > > However, we'd love to help to analyze the problem for you. If possible, > can > > you please try to use a minimal cube definition(maybe with a little > sample > > data) that will pin-point the issue? > > > > The cube desc consist of three parts: > > 1. Cube Desc (json file) > > 2. Model Desc (json file) > > 3. Hive table schema > > > > the first two files can be checked directly in kylin web, go to "Cubes" > > tab, click the cube, and checkout contents in "Json(Cube)" and > > "Json(Model)" > > > > > > On Wed, Sep 23, 2015 at 3:11 PM, hongbin ma <[email protected]> > wrote: > > > > > hi vipul > > > > > > I'm looking into this > > > > > > On Wed, Sep 23, 2015 at 3:10 PM, vipul jhawar <[email protected]> > > > wrote: > > > > > >> hi > > >> > > >> Just wanted to check if someone has had a chance to look at this case. > > >> > > >> Thanks > > >> > > >> On Tue, Sep 22, 2015 at 10:33 PM, vipul jhawar < > [email protected]> > > >> wrote: > > >> > > >> > Hi > > >> > > > >> > Please let us know if you need more details on this as it is > affecting > > >> the > > >> > results and its not predictable. > > >> > We are on 0.7.2 > > >> > > > >> > Thanks > > >> > > > >> > On Tue, Sep 22, 2015 at 10:04 AM, Vadim Semenov <[email protected]> > > >> wrote: > > >> > > > >> >> Hi, > > >> >> > > >> >> We've found issues while running some queries: > > >> >> they return inconsistent results, i.e. in some cases we don't get > any > > >> >> rows, in some cases we get some rows but never all that we expected > > to > > >> get. > > >> >> > > >> >> I was able to pin-point the queries, so here're the cases: > > >> >> > > >> >> 1. SELECT dim, measure FROM table WHERE partition = one partition > AND > > >> dim > > >> >> IN (a,b,c) GROUP BY dim > > >> >> We get results for a,c only > > >> >> http://i.imgur.com/SZu6f2E.png > > >> >> > > >> >> 2. IN (b) > > >> >> We get results for b as expected > > >> >> http://i.imgur.com/8c8UMWj.png > > >> >> > > >> >> 3. IN (a,b) > > >> >> We don't get any results > > >> >> http://i.imgur.com/qIepe8d.png > > >> >> > > >> >> 4. IN (b,c) > > >> >> We get results for b,c as expected > > >> >> http://i.imgur.com/Qq6yuuS.png > > >> >> > > >> >> We tried to run the queries with acceptPartial=false and with empty > > >> cache > > >> >> and the issues are still the same. > > >> >> > > >> >> What should we do to debug this? > > >> >> What might be causing these issues? > > >> > > > >> > > > >> > > > >> > > > > > > > > > > > > -- > > > Regards, > > > > > > *Bin Mahone | 马洪宾* > > > Apache Kylin: http://kylin.io > > > Github: https://github.com/binmahone > > > > > > > > > > > -- > > Regards, > > > > *Bin Mahone | 马洪宾* > > Apache Kylin: http://kylin.io > > Github: https://github.com/binmahone > > > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
