[
https://issues.apache.org/jira/browse/KYLIN-4209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wangrupeng updated KYLIN-4209:
------------------------------
Description:
One kylin user met a problem when execute the sql which need to join select
table in another cube and the sql is like below:
select
"FLOOR" as "楼层" ,
"CUSTYPENAME" as "铺位类别"
,count(RESOURCE_DIM."RENTED") as "已出租数量"
from
RESOURCE_DIM
join LEVELDIMENSION_DIM on
RESOURCE_DIM.LEVEL_SK = LEVELDIMENSION_DIM.LEVEL_SK
join RESOURCETYPE_DIM on
RESOURCE_DIM.RESOURCETYPE_SK = RESOURCETYPE_DIM.RESOURCETYPE_SK
join RESOURCESTATUS_DIM on
RESOURCE_DIM.RESOURCESTATUS_SK = RESOURCESTATUS_DIM.RESOURCESTATUS_SK
join (
select * from T_RIGHT_POWERBI_ROLE
as T1
where
T1.FTABLEID = 'HQMART_DW.LEVELDIMENSION_DIM'
and T1.FROLEID = 'role2a9fb1505b2f11e9a4f079bdc111c187'
and T1.FDSVID = 'resource_model_20190828'
)
as F1
on F1.FDIMID = LEVELDIMENSION_DIM.COMPANYNAME
where
( RESOURCE_DIM.DATETIME between '2019-01-01 00:00:00' and '2019-12-31
00:00:00' )
and "RESOURCESTATUSNAME" in ('未出租',
'已出租',
'已预留')
and "RESOURCETYPENAME" = '铺位'
group by
"FLOOR",
"CUSTYPENAME"
order by
"FLOOR",
"CUSTYPENAME"
was:
One kylin user met a problem when execute the sql which need to join select
table in another cube and the sql is like below:
select
> Cannot count dimension column when join table in another cube
> --------------------------------------------------------------
>
> Key: KYLIN-4209
> URL: https://issues.apache.org/jira/browse/KYLIN-4209
> Project: Kylin
> Issue Type: Bug
> Affects Versions: v3.0.0-alpha2, v2.6.4
> Reporter: wangrupeng
> Priority: Major
>
> One kylin user met a problem when execute the sql which need to join select
> table in another cube and the sql is like below:
> select
> "FLOOR" as "楼层" ,
> "CUSTYPENAME" as "铺位类别"
> ,count(RESOURCE_DIM."RENTED") as "已出租数量"
> from
> RESOURCE_DIM
> join LEVELDIMENSION_DIM on
> RESOURCE_DIM.LEVEL_SK = LEVELDIMENSION_DIM.LEVEL_SK
> join RESOURCETYPE_DIM on
> RESOURCE_DIM.RESOURCETYPE_SK = RESOURCETYPE_DIM.RESOURCETYPE_SK
> join RESOURCESTATUS_DIM on
> RESOURCE_DIM.RESOURCESTATUS_SK = RESOURCESTATUS_DIM.RESOURCESTATUS_SK
> join (
> select * from T_RIGHT_POWERBI_ROLE
> as T1
> where
> T1.FTABLEID = 'HQMART_DW.LEVELDIMENSION_DIM'
> and T1.FROLEID = 'role2a9fb1505b2f11e9a4f079bdc111c187'
> and T1.FDSVID = 'resource_model_20190828'
> )
> as F1
> on F1.FDIMID = LEVELDIMENSION_DIM.COMPANYNAME
> where
> ( RESOURCE_DIM.DATETIME between '2019-01-01 00:00:00' and '2019-12-31
> 00:00:00' )
> and "RESOURCESTATUSNAME" in ('未出租',
> '已出租',
> '已预留')
> and "RESOURCETYPENAME" = '铺位'
> group by
> "FLOOR",
> "CUSTYPENAME"
> order by
> "FLOOR",
> "CUSTYPENAME"
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
