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:41:00 GMT

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

peng.jianhua updated KYLIN-3109:
--------------------------------
    Description: 
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.

  was:
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.


> 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: 0001-KYLIN-3109-Remove-duplicate-cube-names-in-query-resu.patch,
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