为什么hazelcastjsonvalue不能用imap和hazelcastjsonvalue查询不正确的结果

Question

    Gson gson = new Gson();
    String json = "{\"orderId\":\"-20200822-221116-188-quote-100002\",\"securityId\":\"130015\",\"tradingAccount\":\"xtrinterbanktra01\",\"subSystemId\":\"QDM-ESP\",\"userId\":\"xtrinterbankat01\",\"securityExchange\":\"B\",\"systemNodeId\":710,\"quoteId\":\"1598145974197\",\"execId\":\"22550774606679263\",\"investAccount\":\"xtrinterbankinvest01\",\"productAccount\":\"xtrinterbankprod01\",\"assetAccount\":\"xtrinterbankasst01\",\"securityAccount\":\"111010032010000205011\",\"securityType\":\"4\",\"settlType\":\"1\",\"orderModel\":\"legs\",\"orderStatus\":\"8\",\"createdTime\":1598145974,\"createdDate\":\"20200824\",\"tradeDate\":\"20200824\",\"positionFlag\":1,\"price\":111.0,\"orderQty\":1.0E7,\"accumulatedExecQty\":1.0E7,\"lastQty\":1.0E7,\"finalFlag\":true,\"symbol\":\"13国债15\",\"side\":\"1\",\"orderVersion\":2,\"classType\":\"OrderBO\",\"messageId\":87350933198472267,\"uniqueKey\":\"-20200822-221116-188-quote-100002\",\"topicName\":\"order\",\"subject\":\"business/order/130015/B/xtrinterbanktra01/xtrinterbankat01\",\"publisherId\":\"oms-710-9577@168-61-73-136\",\"tenantId\":\"ficc\",\"extFields\":{\"quotaionType\":\"5\",\"clOrdId\":\"-20200822-221116-188-quote-100001\",\"marketIndicator\":\"4\",\"deliveryType\":\"0\",\"transcatTime\":\"1883635200\",\"quoteStaus\":\"16\",\"clearingMethod\":\"13\",\"execType\":\"F\",\"validUnitTime\":\"1883635200\"}}";

    String tableName = "__UT_TestMap";

    IMap map = instance.getMap(tableName);
    map.addIndex(new IndexConfig(IndexType.HASH,"orderId"));

    map.put("-20200822-221116-188-quote-100002",json);

    System.out.println(map.entrySet(Predicates.sql("side='1'")));

“条件是正确的，但结果是空的，为什么？当我没有添加索引时，查询结果是正确的。

Answer 1

在map.put中，尝试将value子句从json更改为new HazelcastJsonValue(json))

您命名为JSON的变量实际上是一个字符串，因此它是形式为map 的映射。

Hazelcast不会在字符串中搜索字段，因为它不会知道其中包含任何形式的结构化数据。您将获得发布的代码的IllegalOperationException。