Calcite integration. Join returns partial resultset.

    /** */
    public static class MyClass {
        /** */
        @QuerySqlField
        public String name;

        /** */
        @QuerySqlField
        @AffinityKeyMapped
        public Integer amount;
...
    }

    /** */
    public static class MyClass2 {
        /** */
        @QuerySqlField
        public String name;

        /** */
        @QuerySqlField
        @AffinityKeyMapped
        public Integer amount2;
....
    }

        IgniteCache<Integer, MyClass> cache1 = ignite.getOrCreateCache(new CacheConfiguration<Integer, MyClass>()
            .setName("tbl1")
            .setSqlSchema("PUBLIC")
            .setQueryEntities(F.asList(new QueryEntity(Integer.class, MyClass.class).setTableName("TBL1")))
            .setBackups(1)
        );

        IgniteCache<Integer, MyClass2> cache2 = ignite.getOrCreateCache(new CacheConfiguration<Integer, MyClass2>()
            .setName("tbl2")
            .setSqlSchema("PUBLIC")
            .setQueryEntities(F.asList(new QueryEntity(Integer.class, MyClass2.class).setTableName("TBL2")))
            .setBackups(1)
        );