indexing for full-text search
Questions tagged [full-text-indexing]
569 questions
0
votes
1 answer
how to optimize mysql's full text search to match strings like 'C++'
we use mysql's full-text search IN NATURAL LANGUAGE MODE, but the search does not match on terms like 'c++'. How can we optimize mysql to match correctly in a full text search and not to remove special characters? Characters like comma , should of…
0
votes
0 answers
MySQL full-text search returning relevance score incorrectly
I am doing full-text search in MySQLI. my MySQL query is like:
$query="(Select col1,col2,MATCH (Srch_String) AGAINST ('".$search."' IN NATURAL LANGUAGE MODE) AS relevance FROM table_name WHERE MATCH (Srch_String) AGAINST ('".$search."' IN NATURAL…

Grvito
- 13
- 3
0
votes
1 answer
Read content from PDF file and return response to Dialogflow
I have made a chatbot on Dialogflow. There are multiple options for a user to filter out their query, but at last they have a option of 'other_question' which is selected if and only if all the other options are not able to categorise the users…

Aakash
- 47
- 1
- 1
- 10
0
votes
1 answer
Neo4j - How to give more weightage to recent timestamp in Fulltext-indexing?
I have created a fulltext index named messageText on property text of node Message.
CALL db.index.fulltext.createNodeIndex('messageText', ['Message'], ['text'])
In the same node(Message), I have another property named created, that contains the…

Kavya Puranik
- 29
- 5
0
votes
0 answers
FREETEXT search on nvarchar column
My table is as follows:
CREATE TABLE [dbo].[Hers] (
[Material] [int] NOT NULL,
[Material_Description] [nvarchar](255) NULL,
[Material_Type] [nvarchar](255) NULL,
[Manufacturer] [nvarchar](255) NULL,
[MPN] [nvarchar](max) NULL,
…
0
votes
1 answer
Can I use InnoDB full text search to tokenize documents?
I used to think that SQL cannot process unstructured data (like text) unless we write some user-defined functions in C. However, InnoDB's FullText Search feature seems did much of such work already.
According to…

cxwangyi
- 653
- 1
- 8
- 15
0
votes
1 answer
Neo4j combine or union results from two Full text index
I tried below with full text index as below
CALL db.index.fulltext.queryNodes("index1", "x") YIELD node as node1, score as score1
With collect({id: node1.id, score: score1}) as rows1
CALL db.index.fulltext.queryNodes("index2", "name:Y") YIELD node…

Selva
- 5
- 1
0
votes
2 answers
flask_whooshalchemyplus index_all() doesn't work
I want to use flask_whooshalchemyplus to manually index two tables named "Traduzioni" and "TraduzioniDlg" for full indexing. I created a simple endpoint on Flask, triggered by JQuery ajax request. The process stops apparentely without raising any…

Fabio Quintilii
- 39
- 7
0
votes
0 answers
PostgreSQL Full Text Search: Documents composed of multiple rows
I'm using PostgreSQL's Full Text Search in Django.
My data is stored in a tree structure, like so:
- note 100 #This is a tree
- note 341
- note 422
- note 101 #This is another tree
- note 218
- note…

gatlanticus
- 1,158
- 2
- 14
- 28
0
votes
1 answer
How can I use lucene's shingleanalyzerwrapper + standardanalyzer + indexreader?
I hope you can help me with this problem.
What I intend to do:
Given a right text, I want to count the frequencies for every stemmized token ngrams without the stopwords(in other words, the stopwords are already removed).
This is the situation:
I am…

ncode
- 15
- 2
- 7
0
votes
1 answer
Oracle Db: Querying out Ctx_Ddl Preferences
In trying to manipulate the storage parameters of context indexes, I've specified a new CTX Preference called mystore, as follows:
DECLARE
prefs_ VARCHAR2(20) := 'mystore';
BEGIN
Ctx_Ddl.Drop_Preference (prefs_);
Ctx_Ddl.Create_preference…

cartbeforehorse
- 3,045
- 1
- 34
- 49
0
votes
1 answer
Mysql Fulltext deny similar column resul
I have a set Fulltext to some columns like:
car normal | car super | car extra
And then values like
car normal | car super | car extra
normal car super car extra car
how i get only 1 column result, becouse when i run the query, bring all…

MagicHat
- 379
- 1
- 6
- 28
0
votes
1 answer
Postgres fulltext ignores xml tags
I'm working on web app which enables the user to search within a source repository.
The program parses the diffs.
I can't find a way to inject all parts of the diff into the Postgres' fulltext vector.
Example:
select alias, description, token from…

Steffen Roller
- 3,464
- 25
- 43
0
votes
1 answer
Documents are not found in Lucene
I am indexing documents over lucene, the indexes ares created, but when do realize a search, get 0 hits.
I don't know where are the error is in indexing or searching.
Indexing
Directory directory =…

Zé Henriques
- 323
- 1
- 3
- 15
0
votes
2 answers
Select Match Against in Boolean mode is not working fine
i have a BD with 3 millions of rows. With id_table, and other field type text (id_songs, name_song).
I have a full text index in 'name_song'.
My select is
SELECT * FROM songs
WHERE MATCH(name_song) AGAINST ('love' in boolean mode)
this is ok. But…

Nicols Esteban Morales Morales
- 121
- 1
- 10