Hi Bart, Kylin assumes the join columns are PK; Then it will take Hashmap snapshot with the PK as the Key. If the join column isn't unique, it will report such error.
In your case, I think you're join the AUTHORSHIP table with "AUTHOR" as the condition. While "AUTHOR" isn't unique. Furthermore, join in this way will cause the data in fact table be appeared multiple times in the flat table, then it will cause aggregation data wrong. So you need consolidate the data model first. This is just my comments. 2017-08-02 21:46 GMT+08:00 Bart <[email protected]>: > Oh my God, probably I have to change Hive tables... > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/Multiple-keys-tp8616p8624.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi 史少锋
