phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Puneet Kumar Ojha <puneet.ku...@pubmatic.com>
Subject RE: OR condition in Join
Date Mon, 24 Nov 2014 14:41:49 GMT
Di you try using subquery provided in Phoenix release 4.2

Logic:-
a.itemid in (select b.itemid) or a.name in (select b.name)

From: Komal Thombare [mailto:komal.thombare@tcs.com]
Sent: Monday, November 24, 2014 7:23 PM
To: user@phoenix.apache.org
Subject: OR condition in Join

Hi,

Does anyone know any way or workaround to apply OR condition in Join.

for example: select * from a join b on a.itemid=b.itemid OR a.name=b.name;

This is not supported in Phoenix and there also no Union operator support yet.


Thanks and Regards,
Komal Ravindra Thombare

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

Mime
View raw message