kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JiaTao Tao <taojia...@gmail.com>
Subject Re: 使用left join查询时报错
Date Mon, 27 May 2019 01:51:46 GMT
Hi
What's your join type in your model?

-- 


Regards!

Aron Tao



Gods_Dusk <197795352@qq.com> 于2019年5月26日周日 下午12:18写道:

> 使用下面的语句查询时报错
> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message