Folks, After we added CACHE_NAME, KEY_TYPE and VALUE_TYPE parameters [1] to CREATE TABLE syntax for 2.3, I’ve returned to a simple demo application [2] that aims to show how to use key-value, compute, service grid APIs in the cluster fully configured with DDL.
So, what was done and works: * started the cluster with this config [3] (built binary from 2.3 branch). * configured the cluster and preloaded data using this SQL script [4] fed to SQLLine tool. * double checked that Java SQL APIs are workable.[5] * could get a value with the key of BinaryObject type! [6] Something we didn’t support in 2.2. But then got stuck with the following: * failed to deserialize BinaryObject value to City type [7]. Just classical "class org.apache.ignite.binary.BinaryInvalidTypeException: City" caused by "Caused by: java.lang.ClassNotFoundException: City”. * failed to implement hashCode for CityKey for non binary key-val access. Thought I could setup BinaryArrayIdentityResolver for CityKey type to address the issue but we removed resolvers from the public configuration. * as a Java developer I was forced to name at least CityKey’s affinity field [9] in the way it's named in CREATE TABLE command [2]. Not a blocker but a big usability issue. Can we have case insensitive policy for fields names? Vladimir, Alex P., will highly appreciate if you look at this before the release and help to overcome the issues I’m facing. [1] https://apacheignite-sql.readme.io/docs/create-table#section-parameters [2] https://github.com/dmagda/ignite_world_demo [3] https://github.com/dmagda/ignite_world_demo/blob/master/config/ignite-config.xml [4] https://github.com/dmagda/ignite_world_demo/blob/master/ignite_world.sql [5] https://github.com/dmagda/ignite_world_demo/tree/master/src/main/java/demo/sql [6] https://github.com/dmagda/ignite_world_demo/blob/master/src/main/java/demo/keyvalue/KeyValueDataProcessing.java#L83 [7] https://github.com/dmagda/ignite_world_demo/blob/master/src/main/java/demo/keyvalue/KeyValueDataProcessing.java#L86 [8] https://github.com/dmagda/ignite_world_demo/blob/master/src/main/java/demo/model/CityKey.java#L44 [9] https://github.com/dmagda/ignite_world_demo/blob/master/src/main/java/demo/model/CityKey.java#L14 — Denis
