Found the issue, when fact and dimension have same column names on which group by is being done then this problem occurs. I removed similar named column from the fact table.
On Tue, Sep 20, 2016 at 2:13 AM, Sandeep Khurana <[email protected]> wrote: > btw, we are using Kylin version 1.5.2 > > On Tue, Sep 20, 2016 at 2:03 AM, Sandeep Khurana <[email protected]> > wrote: > >> Hello >> >> I have a query where i do group by on a varchar column. The column values >> are long sentences (not just single words). This column is part of a >> dimension table. >> >> When i select just from dimension table with this group by then I do >> get ~2000 records . >> >> But when I join this dimension with the fact table and run the group by >> query then I get just 1 record as Kylin somehow assumes the VARCHAR column >> values as NULL. There is not even a single row which has value of this >> VARCHAR field as null. >> >> Same query I copy paste and run on the Hive tables, I do get more than >> thousand records. >> >> Strange thing is when I change the aggregate column to another VARCHAR >> column (city_name) whose values are just one word and run on kylin SQL >> editor then I do get proper records . >> >> 2 questions >> >> - Any idea why such behaviour ? Especially when Hive gives proper records >> whereas kylin returns just one record which has value of this big varchar >> field as NULL. >> >> - Is there any work around? >> >> > > -- Architect Infoworks.io http://Infoworks.io
