kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: Cartesian Join not supported
Date Thu, 09 May 2019 15:16:06 GMT
Hi Nithya,

The fact table and lookup table need be joined explicitly. That means, the
sql need be:

select bla, bla FROM FACT inner join PRODUCT on FACT.fk = PRODUCT.pk group
by x, y


Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org




nithya.mb4790@gmail.com <nithya.mb4790@gmail.com> 于2019年5月9日周四 下午3:08写道:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message