Changing the query to include setParitions solved the problem with SELECT query. However, SQL statements with DELETE and UPDATE are still not working.
Change made - SqlFieldsQuery folquery = new SqlFieldsQuery("UPDATE A set b = 111 where c = ?").setArgs(someArg); folquery.setDistributedJoins(false); folquery.setSchema("PUBLIC"); Affinity aff = Ignition.ignite().affinity(CacheNameConstants.FULFILL_ORDER_CACHE_NAME); int parts = aff.partition(fulfillOrderId); int[] parts = aff.primaryPartitions(locNode); folquery.setPartitions(parts); focache.query(folquery); -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/SqlFieldsQuery-NPE-on-my-schema-tp16409p16416.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.