I also want to add that if you have Star Schema design described by Alexey Goncharuk in this thread, then you do not need to worry about collocation.
We can make better suggestions, if you describe the data size of your tables. Also, are they growing at the same rate, or some of them grow faster than others. Also, what is the size of the cluster you plan to use for your deployment? D. On Tue, Nov 3, 2015 at 2:33 AM, iceguo <[email protected]> wrote: > Thank you for your kindness. > > Could you please help me to collocate the following object? > > CREATE TABLE T1 > ( LAT_ID SMALLINT, > DEV_ID VARCHAR(20), > DEV_LV SMALLINT > ); > > CREATE TABLE T2 > ( THE_DATE DATE, > DEV_ID VARCHAR(20), > DEV_LV SMALLINT > ); > > CREATE TABLE T3 > ( ID INTEGER PRIMARY KEY NOT NULL, > DEV_TYPE VARCHAR(200), > DEV_ID VARCHAR(100) > ); > > p.s: > table T1 and T2 have no primary key. > > SQL query: > SELECT t1.* from t1,t2,t3 where t2.DEV_ID = t1.DEV_ID and > t2.DEV_LV = t1.DEV_LV and > t1.DEV_ID = t3.DEV_ID; > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/The-result-of-cross-cache-SQL-joins-is-incomplete-tp1723p1819.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
