java - 我可以在嵌套在另一个文档中的文档中的字段上创建 MongoDB 文本索引吗？（爪哇）

Question

我有一个将嵌套文档设置为“名称”变量的文档： Document{{name=Document{{he=דמטריוס הכרונוגראף, en=Demetrius the Chronographer}}}}

它包含在一个模拟数据库中，我打算在其中实现搜索功能。我想索引我的集合中文档的“名称”字段以加快标准collection.find()函数的时间复杂度，但我的名称字段设置为一个文档，其中多个名称包含在一个数组中。

我希望能够分别索引“he”变体和“en”变体，以便我可以搜索这两个字段，但不确定如何通过 Java 驱动程序执行此操作。目前，我正在尝试使用：

db.getCollection(collectioName).createIndex(text(name.en));

但是，我收到一条错误消息，内容如下：

Exception in thread "main" com.mongodb.MongoCommandException: Command failed with error 67 (CannotCreateIndex): 'Error in specification { key: { $text: { $search: "name.en" } }, name: "$text_", ns: "60d4a208049d3506e1c36083_alhatorah.people" } :: caused by :: Values in v:2 index key pattern cannot be of type object. Only numbers > 0, numbers < 0, and strings are allowed.' on server cluster0-shard-00-02.l1p7n.mongodb.net:27017. The full response is { "operationTime" : { "$timestamp" : { "t" : 1625086457, "i" : 22 } }, "ok" : 0.0, "errmsg" : "Error in specification { key: { $text: { $search: \"name.en\" } }, name: \"$text_\", ns: \"60d4a208049d3506e1c36083_alhatorah.people\" } :: caused by :: Values in v:2 index key pattern cannot be of type object. Only numbers > 0, numbers < 0, and strings are allowed.", "code" : 67, "codeName" : "CannotCreateIndex", "$clusterTime" : { "clusterTime" : { "$timestamp" : { "t" : 1625086457, "i" : 22 } }, "signature" : { "hash" : { "$binary" : "BCifcktqC8uoPcR7ncgMmas8qY8=", "$type" : "00" }, "keyId" : { "$numberLong" : "6930011667187105794" } } } }

at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:179)
    at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:299)
    at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255)
    at com.mongodb.internal.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:99)
    at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:444)
    at com.mongodb.internal.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:72)
    at com.mongodb.internal.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:200)
    at com.mongodb.internal.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:269)
    at com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:131)
    at com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:123)
    at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:242)
    at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:233)
    at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:170)
    at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:163)
    at com.mongodb.operation.CreateIndexesOperation$1.call(CreateIndexesOperation.java:175)
    at com.mongodb.operation.CreateIndexesOperation$1.call(CreateIndexesOperation.java:170)
    at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:453)
    at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:415)
    at com.mongodb.operation.CreateIndexesOperation.execute(CreateIndexesOperation.java:170)
    at com.mongodb.operation.CreateIndexesOperation.execute(CreateIndexesOperation.java:70)
    at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:193)
    at com.mongodb.client.internal.MongoCollectionImpl.executeCreateIndexes(MongoCollectionImpl.java:805)
    at com.mongodb.client.internal.MongoCollectionImpl.createIndexes(MongoCollectionImpl.java:788)
    at com.mongodb.client.internal.MongoCollectionImpl.createIndexes(MongoCollectionImpl.java:783)
    at com.mongodb.client.internal.MongoCollectionImpl.createIndex(MongoCollectionImpl.java:768)
    at com.mongodb.client.internal.MongoCollectionImpl.createIndex(MongoCollectionImpl.java:763)
    at DatabaseManager.createIndex(DatabaseManager.java:57)
    at Main.main(Main.java:23)

Process finished with exit code 1

我该怎么做才能在这里索引名称字段？

标签： javamongodbindexingmongo-java-drivermongodb-indexes