phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Ubale <siddharth.ub...@syncoms.com>
Subject FW: Hi
Date Tue, 18 Nov 2014 11:58:52 GMT
Hi,

The query for which I get this :

select * from "Customers_3" as c
inner join "Address_3" as a on a."A_C_Id" = c."C_Id"
inner join "Orders_3" as o on o."O_C_Id" = c."C_Id"
inner join "Order_Details_3" as od on od."O_No" = o."O_No"
where c."C_Name" = 'Amit500';

Thanks,
Siddharth

From: Siddharth Ubale
Sent: Tuesday, November 18, 2014 5:28 PM
To: user@phoenix.apache.org
Subject: Hi

HI All,

Can anyone explain why we get this error while running joins on many tables in Phoenix :

Error: Encountered exception in sub plan [2] execution. (state=,code=0)

Thanks,
Siddharth Ubale,
Synchronized Communications
#43, Velankani Tech Park, Block No. II,
3rd Floor, Electronic City Phase I,
Bangalore – 560 100
Tel : +91 80 3202 4060
Web: www.syncoms.com<http://www.syncoms.com/>
[LogoNEWmohLARGE]
London|Bangalore|Orlando

we innovate, plan, execute, and transform the business​

Mime
View raw message