使用下面的语句查询时报错 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' and tb.kaidanyisheng = '0320' and tb.id = '47442018-06-08T08:52:01'
No realization found for OLAPContext, MODEL_UNMATCHED_JOIN, rel#37347:OLAPTableScan.OLAP.[](table=[COST_SUM, TBMENZHENFEIYONG],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15]), JoinDesc [type=LEFT, primary_key=[KESHIBIANMA], foreign_key=[KAIDANKESHI]] while executing SQL: "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' and tb.kaidanyisheng = '0320' and tb.id = '47442018-06-08T08:52:01' LIMIT 50000" 把left join改为inner join则不会报错 -- Sent from: http://apache-kylin.74782.x6.nabble.com/