I have a set of nodes with metadata like

I have a set of nodes with metadata like below for each of my documents ingested into a PostgresDB with pgvector

Plain Text

{'name': 'Reliance Industries Ltd.', 'date': '2023-05-02', 'type': 'NCM', 'uuid': '91f19fce-1dc6-4a8b-9a4a-4fdfdcabfbfc'}

When I query the documents using query like "What is the EBITDA for the year 2023 and 2020 for XYZ company?" I want to retrieve different documents based on the "date" metadata and "name" along with semantic search using LLM.

Currently metadata is not taken into consideration and documents returned are also from 2013 etc.

2 comments

mmohammed

@ravitheja thoughts?

LLogan M

When you query, it's purely based on semantics/vectors. And vectors are bad at capturing precise details like dates.

What you probably want is something like metadata filtering (either manually, or automatically with an auto-retriever) or text2sql and putting your data in a db

Add a reply

Find answers from the community

I have a set of nodes with metadata like