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
