[
https://issues.apache.org/jira/browse/KYLIN-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
mukvin updated KYLIN-5158:
--------------------------
Description:
rusult is not show
{code:sql}
// Some comments here
SELECT
SELLER_ACCOUNT.ACCOUNT_COUNTRY,count(*)
FROM KYLIN_SALES as KYLIN_SALES
INNER JOIN KYLIN_CAL_DT as KYLIN_CAL_DT
ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
INNER JOIN 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
INNER JOIN KYLIN_ACCOUNT as BUYER_ACCOUNT
ON KYLIN_SALES.BUYER_ID = BUYER_ACCOUNT.ACCOUNT_ID
INNER JOIN KYLIN_ACCOUNT as SELLER_ACCOUNT
ON KYLIN_SALES.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_ID
INNER JOIN KYLIN_COUNTRY as BUYER_COUNTRY
ON BUYER_ACCOUNT.ACCOUNT_COUNTRY = BUYER_COUNTRY.COUNTRY
INNER JOIN KYLIN_COUNTRY as SELLER_COUNTRY
ON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY
group by SELLER_ACCOUNT.ACCOUNT_COUNTRY
{code}
!image-2022-01-26-20-51-23-296.png|width=650,height=398!
was:
rusult is not show
{code:sql}
// Some comments here
SELECT
SELLER_ACCOUNT.ACCOUNT_COUNTRY,count(*)
FROM KYLIN_SALES as KYLIN_SALES
INNER JOIN KYLIN_CAL_DT as KYLIN_CAL_DT
ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
INNER JOIN 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
INNER JOIN KYLIN_ACCOUNT as BUYER_ACCOUNT
ON KYLIN_SALES.BUYER_ID = BUYER_ACCOUNT.ACCOUNT_ID
INNER JOIN KYLIN_ACCOUNT as SELLER_ACCOUNT
ON KYLIN_SALES.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_ID
INNER JOIN KYLIN_COUNTRY as BUYER_COUNTRY
ON BUYER_ACCOUNT.ACCOUNT_COUNTRY = BUYER_COUNTRY.COUNTRY
INNER JOIN KYLIN_COUNTRY as SELLER_COUNTRY
ON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY
group by SELLER_ACCOUNT.ACCOUNT_COUNTRY
{code}
!image-2022-01-26-20-51-23-296.png!
> Result is not show in kylin webui
> ---------------------------------
>
> Key: KYLIN-5158
> URL: https://issues.apache.org/jira/browse/KYLIN-5158
> Project: Kylin
> Issue Type: Improvement
> Components: Web
> Affects Versions: v4.0.0
> Reporter: Zhou Yao
> Priority: Major
> Fix For: v4.0.0
>
> Attachments: image-2022-01-26-20-51-23-296.png
>
> Original Estimate: 5h
> Remaining Estimate: 5h
>
> rusult is not show
> {code:sql}
> // Some comments here
> SELECT
> SELLER_ACCOUNT.ACCOUNT_COUNTRY,count(*)
> FROM KYLIN_SALES as KYLIN_SALES
> INNER JOIN KYLIN_CAL_DT as KYLIN_CAL_DT
> ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT
> INNER JOIN 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
> INNER JOIN KYLIN_ACCOUNT as BUYER_ACCOUNT
> ON KYLIN_SALES.BUYER_ID = BUYER_ACCOUNT.ACCOUNT_ID
> INNER JOIN KYLIN_ACCOUNT as SELLER_ACCOUNT
> ON KYLIN_SALES.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_ID
> INNER JOIN KYLIN_COUNTRY as BUYER_COUNTRY
> ON BUYER_ACCOUNT.ACCOUNT_COUNTRY = BUYER_COUNTRY.COUNTRY
> INNER JOIN KYLIN_COUNTRY as SELLER_COUNTRY
> ON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY
> group by SELLER_ACCOUNT.ACCOUNT_COUNTRY
> {code}
> !image-2022-01-26-20-51-23-296.png|width=650,height=398!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
