Select nodes based on a keyword/phrase using Full-text search index not working

Neo4j Graph Platform Procedures & APOC
,
1

Hi,

My DB has around 2 million nodes(10 different types of nodes) and 3 million relationships in total.

Problem:
I want to run a query on the DB and select a set of nodes (similar type) based on the presence of a keyword(or phrase) in one of their fields called 'Description'.
'Description' field is plaintext (around 10 lines of text).

So, I tried to make a Full-text search index on this field using the following command.

CREATE FULLTEXT INDEX Descriptions FOR (n:Nodename) ON EACH [n.Description]

This command completes after 1 second without any errors, and I can see the newly created index in the list of indexes.
But when I try to run my query, nothing returns. I guess there is something wrong with the index because I believe index creating should take some time in a massive DB like mine.

I used the following command to search and return the nodes:

CALL db.index.fulltext.queryNodes("Descriptions", "Keyword or Phrase") YIELD node, score
RETURN node.Description, score

Any idea about this problem?
Or any other solution for a fuzzy text search on a field based on a keyword/phrase?

Thanks.

2

Hello @mehdi_kh2012 and welcome to the Neo4j community :slight_smile:

Can you try this query? I used a regex.

CALL db.index.fulltext.queryNodes("Descriptions", "(?i)*(keyword)|(phrase)*") YIELD node, score
RETURN node.description, score

Regards,
Cobra

3

Hi @cobra, Thanks for your response.
Your command didn't retrieve anything either. I believe there is something wrong with the creation of the index. As I mentioned in my question, my index creation command completes after only 1 second. It seems to me that it is a bug. Index creation should take some time in a massive DB with millions of nodes.

4

Execute this query please:

SHOW FULLTEXT INDEXES
5

index-after
index-after1702×902 66.4 KB

6

The index is created so, can you add the PROFILE front of the query to check if the query uses the index?

7

Can you eloborate please?

8

Execute this query in Neo4j browser:

PROFILE CALL db.index.fulltext.queryNodes("Descriptions", "(?i)*(keyword)|(phrase)*") YIELD node, score
RETURN node.description, score
9

image
image378×550 17.5 KB

10

I am sure that I have hundreds of matches in my DB.