[jira] [Created] (KYLIN-1927) FK/PK one to one relationship is not honored

["hongbin ma (JIRA)" <ji...@apache.org>]

hongbin ma created KYLIN-1927:
---------------------------------

             Summary: FK/PK one to one relationship is not honored
                 Key: KYLIN-1927
                 URL: https://issues.apache.org/jira/browse/KYLIN-1927
             Project: Kylin
          Issue Type: Improvement
            Reporter: hongbin ma
            Assignee: liyang


when querying like


select p_partkey, s_suppkey
from v_lineorder
left join dates on lo_orderdate = d_datekey
left join customer on lo_custkey = c_custkey
left join supplier on lo_suppkey = s_suppkey
left join part on lo_partkey = p_partkey
where c_custkey = 584306 group by p_partkey, s_suppkey

kylin is trying to translate the PK to FK. however the one to one relationship is ingored, kylin will still read the snapshot table in GTCubeStorageQueryBase.translateDerivedInCompare



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)