[jira] [Updated] (KYLIN-1419) NullPointerException occurs when query from subqueries with order by

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

     [ https://issues.apache.org/jira/browse/KYLIN-1419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

nichunen updated KYLIN-1419:
----------------------------
    Attachment: KYLIN-1419.patch

> NullPointerException occurs when query from subqueries with order by
> --------------------------------------------------------------------
>
>                 Key: KYLIN-1419
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1419
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v1.2
>            Reporter: nichunen
>            Assignee: liyang
>             Fix For: v1.3
>
>         Attachments: KYLIN-1419.patch
>
>
> 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.



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