0: jdbc:ignite:thin://192.168.1.144:10805> CREATE TABLE City ( . . . . . . . . . . . . . . . . . . . . .> id LONG PRIMARY KEY, name VARCHAR) . . . . . . . . . . . . . . . . . . . . .> WITH "backups=1"; No rows affected (0.181 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> 0: jdbc:ignite:thin://192.168.1.144:10805> CREATE TABLE Person ( . . . . . . . . . . . . . . . . . . . . .> id LONG, name VARCHAR, city_id LONG, PRIMARY KEY (id, city_id)) . . . . . . . . . . . . . . . . . . . . .> WITH "backups=1"; No rows affected (0.3 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> 0: jdbc:ignite:thin://192.168.1.144:10805> CREATE INDEX idx_city_name ON City (name); No rows affected (0.016 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> 0: jdbc:ignite:thin://192.168.1.144:10805> CREATE INDEX idx_person_name ON Person (name); No rows affected (0.018 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> 0: jdbc:ignite:thin://192.168.1.144:10805> INSERT INTO City (id, name) VALUES (1, 'Forest Hill'); 1 row affected (0.034 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> INSERT INTO City (id, name) VALUES (2, 'Denver'); 1 row affected (0.012 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> INSERT INTO City (id, name) VALUES (3, 'St. Petersburg'); 1 row affected (0.016 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> 0: jdbc:ignite:thin://192.168.1.144:10805> INSERT INTO Person (id, name, city_id) VALUES (1, 'John Doe', 3); 1 row affected (0.054 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> INSERT INTO Person (id, name, city_id) VALUES (2, 'Jane Roe', 2); 1 row affected (0.012 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> INSERT INTO Person (id, name, city_id) VALUES (3, 'Mary Major', 1); 1 row affected (0.009 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> INSERT INTO Person (id, name, city_id) VALUES (4, 'Richard Miles', 2); 1 row affected (0.012 seconds) 0: jdbc:ignite:thin://192.168.1.144:10805> SELECT * FROM City AS c CROSS join Person AS p; Error: javax.cache.CacheException: Failed to prepare distributed join query: join condition does not use index [joinedCache=SQL_PUBLIC_CITY, plan=SELECT C__Z0.ID AS __C0_0, C__Z0.NAME AS __C0_1, P__Z1.ID AS __C0_2, P__Z1.NAME AS __C0_3, P__Z1.CITY_ID AS __C0_4 FROM PUBLIC.PERSON P__Z1 /* PUBLIC.PERSON.__SCAN_ */ /* WHERE TRUE */ INNER JOIN PUBLIC.CITY C__Z0 /* batched:broadcast PUBLIC."IDX_CITY_NAME_proxy" */ ON 1=1 WHERE TRUE] (state=50000,code=1) java.sql.SQLException: javax.cache.CacheException: Failed to prepare distributed join query: join condition does not use index [joinedCache=SQL_PUBLIC_CITY, plan=SELECT C__Z0.ID AS __C0_0, C__Z0.NAME AS __C0_1, P__Z1.ID AS __C0_2, P__Z1.NAME AS __C0_3, P__Z1.CITY_ID AS __C0_4 FROM PUBLIC.PERSON P__Z1 /* PUBLIC.PERSON.__SCAN_ */ /* WHERE TRUE */ INNER JOIN PUBLIC.CITY C__Z0 /* batched:broadcast PUBLIC."IDX_CITY_NAME_proxy" */ ON 1=1 WHERE TRUE] at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750) at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212) at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475) at sqlline.Commands.execute(Commands.java:823) at sqlline.Commands.sql(Commands.java:733) at sqlline.SqlLine.dispatch(SqlLine.java:795) at sqlline.SqlLine.begin(SqlLine.java:668) at sqlline.SqlLine.start(SqlLine.java:373) at sqlline.SqlLine.main(SqlLine.java:265) 0: jdbc:ignite:thin://192.168.1.144:10805>