Questions tagged [full-text-indexing]

indexing for full-text search

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…
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…
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…
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…
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…
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…