kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "nithya.mb4790@gmail.com" <nithya.mb4...@gmail.com>
Subject Cartesian Join not supported
Date Thu, 09 May 2019 05:39:37 GMT
Hello,
I have created a cube in KYLIN that has TOP_N measure. When I run the query
in Insight I am getting Cartesian Join Not supported error. I have given the
details in the below email thread. Can you please let me know If I am doing
anything wrong? Or is my usage wrong? If yes, how to use this measure?



Below are complete details:

Fact: Product_ID, Amount.
Product Dimension: Product_ID, PROD_DESC
TIME Dimension: Time_ID, TIME_DESC

In Kylin Cube:
Dimensions: TIME.TIME_DESC

Measure: TOP_N.
Column: FACT.Amount
GROUP BY: PRODUCT.PROD_DESC

Query:
SELECT SUM(FACT.AMOUNT), PRODUCT.PROD_DESC
FROM FACT,PRODUCT
GROUP BY PRODUCT.PROD_DESC
ORDER BY SUM(FACT.AMOUNT) DESC;

Error:
Cartesian join not supported. While executing SQL: 
SELECT SUM(FACT.AMOUNT), PRODUCT.PROD_DESC
FROM FACT,PRODUCT
GROUP BY PRODUCT.PROD_DESC
ORDER BY SUM(FACT.AMOUNT) DESC;

Regards,
Nithya

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Mime
View raw message