Re: 使用left join查询时报错

2019-05-28 Thread ShaoFeng Shi
Define another cube with inner join. Kylin will automatically match the join type in query with the cube/model definition. Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail

Re: 使用left join查询时报错

2019-05-28 Thread Gods_Dusk
inner join, and I modify to left join, it works well, thx a lot. besides, if I want to use both inner and left, how can I do? -- Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: 使用left join查询时报错

2019-05-26 Thread JiaTao Tao
Hi What's your join type in your model? -- Regards! Aron Tao Gods_Dusk <197795...@qq.com> 于2019年5月26日周日 下午12:18写道: > 使用下面的语句查询时报错 > select bingrenxingming, >jiaofeibiaoji, >yaowumingcheng, >danjia, >shuliang, >jiuzhenriqi, >kaidankeshi, >

使用left join查询时报错

2019-05-26 Thread Gods_Dusk
使用下面的语句查询时报错 select bingrenxingming, jiaofeibiaoji, yaowumingcheng, danjia, shuliang, jiuzhenriqi, kaidankeshi, keshimingcheng from TBMENZHENFEIYONG tb left join akeshidict d on tb.kaidankeshi = d.keshibianma WHERE tb.kaidankeshi = '0963'