[jira] [Commented] (KYLIN-2887) Subquery columns not exported in OLAPContext allColumns
[ https://issues.apache.org/jira/browse/KYLIN-2887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16307694#comment-16307694 ] Roger Shi commented on KYLIN-2887: -- Fixed in commit b15164ac23280ebad4e1ef92c637e070ea47b016 > Subquery columns not exported in OLAPContext allColumns > --- > > Key: KYLIN-2887 > URL: https://issues.apache.org/jira/browse/KYLIN-2887 > Project: Kylin > Issue Type: Bug >Reporter: Roger Shi > Fix For: v2.3.0 > > > Query like this returns empty value, because olap context allColumns field > isn't set rightly. > ```sql > select c.COUNTRY, c.NAME,b.TRANS_ID, b.BUYER_ID from KYLIN_COUNTRY c join ( > select * from KYLIN_SALES s join KYLIN_ACCOUNT a on s.SELLER_ID = > a.ACCOUNT_ID where a.ACCOUNT_ID <= 1866 >) b on b.ACCOUNT_COUNTRY = c.COUNTRY > ``` -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (KYLIN-2887) Subquery columns not exported in OLAPContext allColumns
[ https://issues.apache.org/jira/browse/KYLIN-2887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16307662#comment-16307662 ] jiatao.tao commented on KYLIN-2887: --- Roger Shi , you already fixed this? > Subquery columns not exported in OLAPContext allColumns > --- > > Key: KYLIN-2887 > URL: https://issues.apache.org/jira/browse/KYLIN-2887 > Project: Kylin > Issue Type: Bug >Reporter: Roger Shi > > Query like this returns empty value, because olap context allColumns field > isn't set rightly. > ```sql > select c.COUNTRY, c.NAME,b.TRANS_ID, b.BUYER_ID from KYLIN_COUNTRY c join ( > select * from KYLIN_SALES s join KYLIN_ACCOUNT a on s.SELLER_ID = > a.ACCOUNT_ID where a.ACCOUNT_ID <= 1866 >) b on b.ACCOUNT_COUNTRY = c.COUNTRY > ``` -- This message was sent by Atlassian JIRA (v6.4.14#64029)