java - 远程运行 map 查询失败。在节点上执行 map 查询失败

Question

我在 ignite 2.4 v 中使用 SqlFieldsQuery
它工作正常一段时间，之后出现异常:

Failed to run map query remotely.Failed to execute map query on the node: c7823704-201f-473f-9113-776d7d9a80d8, 
class org.apache.ignite.internal.processors.query.IgniteSQLException:Failed to set schema for DB connection for thread

这是我的查询客户端的代码:

Ignition.setClientMode(true);

        try (Ignite ignite = Ignition.start("config/default-config_new_version.xml")) {

            try (IgniteCache<String, EntityFactDev> igniteCache = ignite.getOrCreateCache("ENTITY_FACT_DEV")) {

                LOGGER.debug("done");

                QueryCursor<List<?>> queryCursor = igniteCache
                        .query(new SqlFieldsQuery("select count(*) from ENTITY_FACT_DEV.EntityFactDev"));

                System.out.println(queryCursor.getAll());
            }
        }

Answer 1

您是否在缓存配置中显式指定了数据库架构？如果没有，那么您应该使用带引号的缓存名称作为查询中的架构。像这样:

new SqlFieldsQuery("select count(*) from \"ENTITY_FACT_DEV\".EntityFactDev")