kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gods_Dusk <197795...@qq.com>
Subject 使用left join查询时报错
Date Fri, 24 May 2019 07:37:24 GMT
使用下面的语句查询时报错
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/

Mime
View raw message