sql icon indicating copy to clipboard operation
sql copied to clipboard

Published 20 hours ago • verified publisher icon opendistro-for-elasticsearch

Multiple indexes

Open benwq opened this issue 4 years ago • 5 comments

Are there plans to implement multi index join?(more than 2)

benwq avatar Jan 13 '21 08:01 benwq

Could you please share some usecase. We are definitely considering it. Contributions are welcome too!

anirudha avatar Jan 13 '21 08:01 anirudha

Could you please share some usecase. We are definitely considering it. Contributions are welcome too! ex. select t0.,t1.,t2.* from t0 left join t1 on t0.a_id=t1.id left join t2 on t0.b_id=t2.id throw RuntimeException:currently supports only 2 tables join

benwq avatar Jan 13 '21 08:01 benwq

Related issue: #351

chloe-zh avatar Jan 13 '21 13:01 chloe-zh

Thanks for your request! Yes we do have plans to support multi table join, it should be available soon. Will keep you updated when this feature is supported!

chloe-zh avatar Jan 14 '21 03:01 chloe-zh

Thank you!

benwq avatar Jan 15 '21 03:01 benwq