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

NullPointerException occurs when query from subqueries with order by

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • v1.2
    • v1.3.0, v1.4.0, v1.5.0
    • Query Engine
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment