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)