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 group: user-subscr...@kylin.apache.org
Join Kylin dev mail group: dev-subscr...@kylin.apache.org




Gods_Dusk <197795...@qq.com> 于2019年5月28日周二 下午3:16写道：

> 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-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,
>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
> 5"
>
> 把left join改为inner join则不会报错
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>

使用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'
   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 5"

把left join改为inner join则不会报错

--
Sent from: http://apache-kylin.74782.x6.nabble.com/