kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "peng.jianhua (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (KYLIN-3109) Remove duplicate cube names in query results
Date Thu, 14 Dec 2017 10:37:00 GMT

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

peng.jianhua updated KYLIN-3109:
--------------------------------
    Attachment: 01.PNG
                02.PNG
                03.PNG

> Remove duplicate cube names in query results
> --------------------------------------------
>
>                 Key: KYLIN-3109
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3109
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: peng.jianhua
>            Assignee: peng.jianhua
>            Priority: Minor
>         Attachments: 01.PNG, 02.PNG, 03.PNG
>
>
> When we query sql like following:
> select KYLIN_SALES.PART_DT, sum(KYLIN_SALES.PRICE)
> from KYLIN_SALES
> inner join (select ACCOUNT_ID, ACCOUNT_BUYER_LEVEL from KYLIN_ACCOUNT where ACCOUNT_COUNTRY
= 'US' ) as TT
> on KYLIN_SALES.BUYER_ID = TT.ACCOUNT_ID
> inner join (select LEAF_CATEG_ID,SITE_ID from KYLIN_CATEGORY_GROUPINGS where LEAF_CATEG_ID
> 20000  ) as TTT
> on KYLIN_SALES.LSTG_SITE_ID = TTT.SITE_ID
> group by KYLIN_SALES.PART_DT
> the query results will show cubes like 01.png.
> The cube name repeate three times.please refer to 02.png.
> It should better be like 03.png.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message