You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Krzysztof Zarzycki <k....@gmail.com> on 2019/04/10 15:50:18 UTC

Derived dimensions are empty [Kylin 2.6.1-hadoop3]

Hi Kylin community,
I am using Kylin 2.6.1-hadoop3.
I have a fact table TRANSACTION and lookup table STORE. When I select a
derived dimension from a lookup table and try to group by the derived
dimension, I always get a single row with an empty value for that dimension.
SELECT
     store.region,
     sum(sale_value)
FROM
    transaction
JOIN
    store
ON
    transaction.store_id = store.store_id
GROUP BY
    store.region
;
However, when I define a new cube, where the dimension is marked as normal,
query results are as expected.

What have I missed while using derived dimensions? Any suggestions?


Thank you,
Krzysztof