Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-1855

Inner-join query partially matches inner-join model can return incorrect result

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • v1.5.4
    • None
    • None

    Description

      A cube is based on a model in which a star schema is defined. In some cases, the cube utilizes only a few lookup tables rather than all. In this case, when creating the sql for the flat table, those lookup tables should not be included. Otherwise, it will confuse users when query. If users do query according to the definition of the flat table, error of no realization will occur due to lack of the related join.

      Attachments

        1. exclude_unused_joins.patch
          5 kB
          Zhong Yanghong

        Activity

          People

            liyang.gmt8@gmail.com liyang
            yaho Zhong Yanghong
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: