Re: Cartesian Join not supported

2019-05-09 Thread ShaoFeng Shi
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: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.a

[jira] [Created] (KYLIN-3998) Make "bpus-min-benefit-ratio" configurable in cube planner phase 1

2019-05-09 Thread Chao Long (JIRA)
Chao Long created KYLIN-3998: Summary: Make "bpus-min-benefit-ratio" configurable in cube planner phase 1 Key: KYLIN-3998 URL: https://issues.apache.org/jira/browse/KYLIN-3998 Project: Kylin Iss

Cartesian Join not supported

2019-05-09 Thread nithya.mb4...@gmail.com
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 m