You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Zhou Yao (Jira)" <ji...@apache.org> on 2022/01/26 12:54:00 UTC

[jira] [Created] (KYLIN-5158) Result is not show in kylin webui

Zhou Yao created KYLIN-5158:
-------------------------------

             Summary: 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
             Fix For: v4.0.0
         Attachments: image-2022-01-26-20-51-23-296.png

 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! 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)