Hi Jennie,

I did provide schema in the initial mail that's a collection of the 5 hosts each separated by a comment line.

Regards,

Brian Hood

On Nov 25, 2015 7:39 AM, "Ying Zhang" <Y.Zhang@cwi.nl> wrote:

> On Nov 23, 2015, at 18:36, Brian Hood <brianh6854@googlemail.com> wrote:
>
> Hi Guys,
>
> I have 1 master and 4 mserver nodes running.
>
> I have 4 ippacket and 4 tcppacket schemas identical per table schemas across all nodes.
>
> i have 4 remote references on the master to ippacket remote nodes and the same for tcppacket.
>
> However when i try and join 2 MERGE tables each containing 4 schemas i get the following.
>
> sql>select count(*) from ippacket a, tcppacket b where a.guid = b.guid;
> (mapi:monetdb://monetdb@172.17.0.5/threatmonitor) GDK reported error.
> ERROR: BATproject: does not match always

Hai Brian,

Could you please add the schema, incl. the merge/remote tables?  thanks.

Jennie

>
>
> Any pointers please ?
>
> Regards,
>
> Brian Hood
> <monetdb_remote_tables.sql>_______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list