indexing for full-text search
Questions tagged [full-text-indexing]
569 questions
2
votes
1 answer
MySQL Full Text Search Not Matching
My MySQL table is not returning results with a MATCH (col) AGAINST ('') query.
The table is simple:
id | url | fullTextIndex
And my query is
SELECT *, Match(fullTextIndex) AGAINST…
LoveAndCoding
- 7,857
- 2
- 31
- 55
2
votes
2 answers
What is the leanest way to store a full-text index to support lookup of incomplete words?
What is the leanest way to store a (big) full-text index that supports lookup of incomplete words? For example, an index lookup for colo should return Colorado (among other things). For context, I am indexing about 60,000 geographical entities…
Chris Calo
- 7,518
- 7
- 48
- 64
2
votes
1 answer
FullText INDEXING on MyISAM is really slow
I have a table
CREATE TABLE `dataFullText` (
`id` int(11) NOT NULL,
`title` char(255) NOT NULL,
`description` text NOT NULL,
`name` char(100) NOT NULL,
`ref` char(50) NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `fulltext`…
Ant
- 1,812
- 5
- 22
- 39
2
votes
2 answers
Full text search solutions for Java?
There's a large set of entities of different kinds:
interface Entity {
}
interface Entity1 extends Entity {
String field1();
String field2();
}
interface Entity2 extends Entity {
String field1();
String field2();
String…
Andrey Agibalov
- 7,624
- 8
- 66
- 111
2
votes
1 answer
SQL Server oddity with full-text indexing and case sensitivity and numbers
This problem may be unique to our server, but I can't tell from the symptoms where the issue may lie.
I have a field (searchtitle) in a table (fsItems) that has a full-text index turned ON. For the record with primary key (IDItem) 704629 the content…
user1693404
- 173
- 1
- 12
2
votes
0 answers
How to get desired result with full-text search in SQL Server through thesaurus?
I am using SQL Server 2019. I define thesaurus in language XML in SQL Server full text search.
0
…
Samir Allahverdi
- 71
- 8
2
votes
0 answers
Text search is not using text index that is created
Main problem I am facing is that I have created $text index with two fields with weights and not able to text search using that index. The result of the query is taking so long even after the text index is created.
As you can see in the Explain…
Prathyusha Prathyu
- 21
- 4
2
votes
1 answer
Spring Data MongoDB: @TextIndexed Index Already Exists With Different Options
Imagine, you have a MongoDB collection that maps to a simple entity in Spring Boot app:
@Document
data class Question(
@Id val id: String,
@TextIndexed
val topic: String
)
Now you want to add a new field and include it in the full-text…
naXa stands with Ukraine
- 35,493
- 19
- 190
- 259
2
votes
0 answers
Postgresql Full text search for numbers preceeded by hashsign
The documents that I want to run full text search on contains sequences of a hash sign followed by a series of digits e.g. #12345 #9999. None of the parsers seem to recognize the sequence as a single token.
The blank parser does recognize '#' as a…
Chronocide
- 191
- 2
- 7
2
votes
1 answer
How to do an efficient search for dynamically defined regexes in Elasticsearch?
I am working in a file system project (like dropbox). For the file system, I have an indexed data for full text search in elastic search. I have lots of large documents and searching works really well. But now my requirement is to use this data to…
Thorux
- 197
- 1
- 1
- 11
2
votes
0 answers
How to combine my python nlp solution for document ranking with solr for indexing?
I'm new to NLP and Solr. I'm trying to build an application to rank past court case documents based on a newly given case document. I confused about how to use Solr for document indexing to speed up my processing time.
I have built a python solution…
2
votes
1 answer
Adding a word breaking character (underscore) to full text search
I'm using full-text search to search through a database of usernames (these are mostly email addresses, but not all). However, since the '_' is not considered a word breaking character, it is difficult to search for certain users.
e.g. Searching…
Jacob Soderlund
- 345
- 1
- 9
2
votes
1 answer
django-haystack: choosing a large SearchIndex over an Indexed DB
I have a UserProfile Model with 35 fields (Char,Int,Bool,Dec,M2M,FK). As part of the search view functionality, one of the fields requires full-text searching while the remaining 34 fields will be used to provide 'advanced search filtering' (using:…
SteveJ
- 706
- 1
- 8
- 9
2
votes
3 answers
What does the term "Stopword" mean in MySQL?
I'm currently studying about MySQL command and got stuck at using the "MATCH...AGAINST" command on FULLTEXT index. It returns an "empty set" when it's against a "stopword"(which is "and" in my case).
Here's what I did. The database I'm working on…
Siraphob K.
- 57
- 2
- 6
2
votes
0 answers
SQL Server Full Text Search within CTE
I have a query which is fairly complex and refers to a joined table-pair a number of times. To simplify the query and improve performance, I've pulled that table pair out into a sub query.
However, now my full text index doesn't work, stating that…
Jon Story
- 2,881
- 2
- 25
- 41