fengYu created KYLIN-2286: ----------------------------- Summary: global snapshot table for one cube Key: KYLIN-2286 URL: https://issues.apache.org/jira/browse/KYLIN-2286 Project: Kylin Issue Type: Improvement Reporter: fengYu Assignee: fengYu
I current version, Kylin build a snapshot table for a segment and isolate with each other in the same cube, even though some segments share the same snapshot table storage . I some scene, we need global snapshot table for one cube, such as we has a cube with snapshot table,ID is PK,the first day, the table look like: id name 1 A 2 B 3 C the query 'select name, count(1) from fact join dimension group by name' get result: A xx B xx C xx the next day(segment), lookup table modified, it looks like : id name 1 A 2 D 3 E the same query return : A xx B xx C xx D xx E xx However B and D, C and E has the same ID, we need the newest result. so a global snapshot table shared by all segments which has always the newest values is needed. -- This message was sent by Atlassian JIRA (v6.3.4#6332)