Hi. We are having a problem with the fulltext index. We have reduced the
default minWordLength for one of our indexes to 2, but sometimes the index
stop creating radix with length of 2.
This is the raw results from Orient Studio:
This is information about the index.
select from (SELECT expand(indexes) from metadata:indexmanager) where name
= 'Tag.name'
{
"result": [
{
"@type": "d",
"@version": 0,
"name": "Tag.name",
"type": "FULLTEXT",
"indexDefinition": {
},
"indexDefinitionClass":
"com.orientechnologies.orient.core.index.OPropertyIndexDefinition",
"clusters": [
2
],
"mapRid": "#1:69",
"algorithm": "SBTREE",
"valueContainerAlgorithm": "SBTREEBONSAISET",
"separatorChars": " \r\n\t:;,.|+*/\\=!?[]()",
"ignoreChars": "'\"",
"stopWords": [
22
],
"minWordLength": 2,
"indexRadix": true,
"@fieldTypes": "clusters=e,stopWords=e"
}
],
"notification": "Query executed in 0.036 sec. Returned 1 record(s)"
}
As you can see, the minWordLength is set 2.
But if I list the results from the index:
SELECT FROM index:Tag.name where key > 'a'
{
"result": [
{
"@type": "d",
"@version": 0,
"key": "aba",
"rid": "#18:90"
},
{
"@type": "d",
"@version": 0,
"key": "abat",
"rid": "#18:90"
},
{
"@type": "d",
"@version": 0,
"key": "abate",
"rid": "#18:90"
},
{
"@type": "d",
"@version": 0,
"key": "abated",
"rid": "#18:90"
},
{
"@type": "d",
"@version": 0,
"key": "abatedo",
"rid": "#18:90"
},
{
"@type": "d",
"@version": 0,
"key": "abatedou",
"rid": "#18:90"
},
{
"@type": "d",
"@version": 0,
"key": "abatedour",
"rid": "#18:90"
},
{
"@type": "d",
"@version": 0,
"key": "abatedouro",
"rid": "#18:90"
},
{
"@type": "d",
"@version": 0,
"key": "abn",
"rid": "#18:75"
},
{
"@type": "d",
"@version": 0,
"key": "abn",
"rid": "#18:74"
}
],
"notification": "Query executed in 0.146 sec. Returned 10 record(s)"
}
The keys have a length of 3 at least.
We are using version 1.7.8.
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
