Hello!
This is an interesting situation to consider.
Have you tried *SELECT* * *FROM* City *AS* c *join* (SELECT * FROM Person)
*AS* p; ?
Otherwise, I don't think we support joins without conditions, unless most
of tables are replicated.
Regards,
--
Ilya Kasnacheev
чт, 26 сент. 2019 г. в
Hi Evgenii,
Even with *where condition*, I am getting the same error.
I have some use case where I can't collocate tables data, as Ignite doc
says non-collocated distributed join or cross join is supported in Ignite I
am trying to use that but getting this exception when I create tables in
Hi,
To make work this query, you can add one where clause or join condition in
the query, for example: where c.id = city_id;. I don't really understand
why do you want to run a fully distributed cross join on these tables - it
doesn't make sense, moreover, it will lead to the a lot of data
Hi all,
I am trying to do a simple cross join on two tables with non-collocated
data (without affinity key),
This non-collocated distributed join always fails with the error message:
*"java.sql.SQLException: javax.cache.CacheException: Failed to prepare
distributed join query: join condition does