You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "Wang Cheng (JIRA)" <ji...@apache.org> on 2016/11/23 03:16:58 UTC

[jira] [Updated] (KYLIN-2224) "select * from fact inner join lookup " does not return values for look up columns

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

Wang Cheng updated KYLIN-2224:
------------------------------
    Description: 
sample cube:

select * from "DEFAULT"."KYLIN_SALES" as KYLIN_SALES
INNER JOIN "DEFAULT"."KYLIN_CAL_DT" as KYLIN_CAL_DT
ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
INNER JOIN "DEFAULT"."KYLIN_CATEGORY_GROUPINGS" as KYLIN_CATEGORY_GROUPINGS
ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID limit 10



  was:
sample cube:

select * from "DEFAULT"."KYLIN_SALES" as KYLIN_SALES
INNER JOIN "DEFAULT"."KYLIN_CAL_DT" as KYLIN_CAL_DT
ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
INNER JOIN "DEFAULT"."KYLIN_CATEGORY_GROUPINGS" as KYLIN_CATEGORY_GROUPINGS
ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID limit 10

image
image


> "select * from fact inner join lookup " does not return values for look up columns
> ----------------------------------------------------------------------------------
>
>                 Key: KYLIN-2224
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2224
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: Wang Cheng
>            Priority: Minor
>
> sample cube:
> select * from "DEFAULT"."KYLIN_SALES" as KYLIN_SALES
> INNER JOIN "DEFAULT"."KYLIN_CAL_DT" as KYLIN_CAL_DT
> ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
> INNER JOIN "DEFAULT"."KYLIN_CATEGORY_GROUPINGS" as KYLIN_CATEGORY_GROUPINGS
> ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID limit 10



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