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

NullPointerException occurs when query from subqueries with order by

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v1.2
    • Fix Version/s: v1.3.0, v1.4.0, v1.5.0
    • Component/s: Query Engine
    • Labels:
      None

      Description

      Context may not have table scan which is created by OLAPJoinRel, so it does not have realization. In org.apache.kylin.query.relnode.OLAPSortRel#findMeasure, it visits "this.context.realization" directly, so makes the NullPointerException. For example, query like "select a.LSTG_FORMAT_NAME from (select LEAF_CATEG_ID,LSTG_FORMAT_NAME from KYLIN_SALES)a, (select LEAF_CATEG_ID,PART_DT from KYLIN_SALES)b order by a.LSTG_FORMAT_NAME".

      Attached is the patch to fix, added a null protection.

        Attachments

        1. KYLIN-1419.patch
          1 kB
          nichunen
        2. KYLIN-1419-V2.patch
          4 kB
          nichunen

          Activity

            People

            • Assignee:
              nichunen nichunen
              Reporter:
              nichunen nichunen
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: