如何在Weaviate查询中包含交叉引用属性?

huangapple go评论67阅读模式
英文:

How to include cross-reference property in weaviate query?

问题

The problem is that I don't know how to include cross-reference property wrotePublications in query result.

我不知道如何在查询结果中包括交叉引用属性wrotePublications

英文:

The problem is that I don't know how to include cross-reference property wrotePublications in query result

I have 2 collections in weaviate database -- Researcher and Publication.

Schemas:

publication_class_schema = {
    "class": publication_class_name,
    "description": "Publication information",
    "properties": [
        {
            "name": "content",
            "dataType": ["text"],
            "description": "Content of the publication",
        },
        {
            "name": "title",
            "dataType": ["text"],
            "description": "Title of the publication",
        },
        . . .
        {
            "name": "citedby",
            "dataType": ["int"],
            "description": "Total number of citations of the publication",
        },
    ],
}

researcher_class_schema = {
    "class": researcher_class_name,
    "description": "Researcher profile information and statistics",
    "properties": [
        {
            "name": "name",
            "dataType": ["text"],
            "description": "The name of the researcher",
        },
        . . .
        {
            "name": "wrotePublications",
            "dataType": [publication_class_name],
            "description": "Cross-reference objects of publications writed by the researcher",
        },
    ],
}

I imported data by using weaviate-python-client as follows:

with client.batch as batch:
    researcher_obj_uuid = batch.add_data_object(researcher_obj, class_name=researcher_class_name)
    pub_obj_uuid = batch.add_data_object(publication_obj, class_name=publication_class_name)
    batch.add_reference(
        from_object_uuid=researcher_obj_uuid,
        from_object_class_name=researcher_class_name,
        from_property_name="wrotePublications",
        to_object_uuid=pub_obj_uuid,
        to_object_class_name=publication_class_name,
    )

Sample Researcher record:

{'class': 'Researcher',
 'creationTimeUnix': 1683744762093,
 'id': '9f1f09f7-dc73-4a08-a914-0f6df5c8fc3f',
 'lastUpdateTimeUnix': 1683744762298,
 'properties': {
   'affiliation': 'res univ',
   'citedby': 485,
   'name': 'res name',
   'wrotePublications': [
    {'beacon': 'weaviate://localhost/Publication/8884d468-2a3a-4344-ada9-07e1876c5364',
     'href': '/v1/objects/Publication/8884d468-2a3a-4344-ada9-07e1876c5364'}
  ]
},
 'vectorWeights': None}

Publication object from above record beacon:

{'class': 'Publication',
 'creationTimeUnix': 1683744762092,
 'id': '8884d468-2a3a-4344-ada9-07e1876c5364',
 'lastUpdateTimeUnix': 1683744762092,
 'properties': {'citedby': 2,
  'content': '',
  'pub_year': 1910,
  'title': 'pub title'},
 'vectorWeights': None}

I've tried code below but it returns an error message:

client.query
   .get(researcher_class_name, ["name", "wrotePublications"]) \
   .with_near_text(nearText) \
   .with_limit(3) \
   .with_additional(['certainty']) \
   .do()
{
  "errors": [
    {
      "locations": [
        {
          "column": 217,
          "line": 1
        }
      ],
      "message": "Field \"wrotePublications\" of type \"[ResearcherWrotePublicationsObj]\" must have a sub selection.",
      "path": null
    }
  ]
}

答案1

得分: 2

Here is the translation of the provided text:

"你可以使用类似以下的语法来完成这个操作(如果我正确理解了你的结构)。

client.query
.get(researcher_class_name, ["name wrotePublications {... on Publication {title} }"]) \
.with_near_text(nearText) \
.with_limit(3) \
.with_additional(['certainty']) \
.do()

请查看这个链接:https://weaviate.io/developers/weaviate/api/graphql/get#query-beacon-references

如果你想要按引用进行筛选,你可以按照这里显示的示例进行操作:https://weaviate.io/developers/weaviate/api/graphql/filters#beacon-reference-filters

希望这有所帮助!"

英文:

you should be able to do it with a syntax like this (if I understood your structure correctly).

client.query
.get(researcher_class_name, ["name wrotePublications {... on Publication {title} }"]) \
.with_near_text(nearText) \
.with_limit(3) \
.with_additional(['certainty']) \
.do()

Take a look at this: https://weaviate.io/developers/weaviate/api/graphql/get#query-beacon-references

And if you want to filter by references, you can do it by following examples shown here: https://weaviate.io/developers/weaviate/api/graphql/filters#beacon-reference-filters

I hope that helps!

huangapple
  • 本文由 发表于 2023年5月11日 04:28:54
  • 转载请务必保留本文链接:https://go.coder-hub.com/76222325.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定