indexing for full-text search
Questions tagged [full-text-indexing]
569 questions
8
votes
3 answers
create indexes for search using MongoTemplate?
how we can create Indexes for the following query using MongoTemplate? I am referring to site http://docs.mongodb.org/v2.4/tutorial/search-for-text/ they've not given any details about how we can create Indexes using…
user5268786
7
votes
2 answers
How should I do full-text searching on App Engine?
What should I do for fast, full-text searching on App Engine with as little work as possible (and as little Java — I’m doing Python.)?

Alan H.
- 16,219
- 17
- 80
- 113
7
votes
3 answers
Using query builder for adding fulltext index in Laravel
This is the query for adding fulltext index in MySQL:
ALTER TABLE `TableName`
ADD FULLTEXT INDEX `IndexName` (`ColumnName`);
But How can I use Laravel query builder to add fulltext index?

Gatti Srinivas
- 103
- 1
- 10
7
votes
5 answers
What is the best Java text indexing library for Google App Engine?
To the moment I know that compass may handle this work. But indexing with compass looks pretty expensive. Is there any lighter alternatives?

user242726
- 268
- 3
- 7
7
votes
4 answers
How can I do indexing .html files in SOLR
The files I want to do indexing is stored on the server(I don't need to crawl). /path/to/files/
the sample HTML file is

Anand Khatri
- 366
- 1
- 6
- 16
7
votes
1 answer
mysql - any way to help fulltext search with another index?
Let's say i have an "articles" table which has the columns:
article_text: fulltext indexed
author_id: indexed
now i want to search for a term that appears in an article that a particular arthor has written.
so something like:
select * from…

ggez44
- 895
- 8
- 17
6
votes
3 answers
SQL Server Full Text not taking Leading Zeros into account
I have an SQL Server 2008 Database with a Full Text Index set to one table column used for search.
When trying to perform a query against the table using the CONTAINS clause with the following criteria: "003", it ignores the leading zeros and…

luisporras
- 61
- 3
6
votes
1 answer
Is that possible to use full text index to find closest match strings? What does Statistical Semantics do in Full Text Indexing
I am looking for SQL Server 2016 full text indexes and they are awesome to make searches for finding multiple words containing strings
When i try to compose the full text index, it shows Statistical Semantics as a tickbox. What does statistical…

Furkan Gözükara
- 22,964
- 77
- 205
- 342
6
votes
1 answer
How to create a fulltext catalog in an entity framework database migration?
I'm trying to create a fulltext catalog on a entity framework migration but if I do a migration with:
migrationBuilder.Sql("CREATE FULLTEXT CATALOG[CatalogName]");
I get the following:
CREATE FULLTEXT CATALOG statement cannot be used inside a user…

RicardoSBA
- 785
- 1
- 6
- 18
6
votes
3 answers
PostgreSQL Full Text Search: why search is sooo slow?
I have a small PostgreSQL database (~~3,000 rows).
I'm trying to set up a full text search on one of it's text fields ('body').
The problem is that any query is extremely slow (35+ seconds!!!).
I suppose the problem comes from the fact that the DB…

MarcoS
- 17,323
- 24
- 96
- 174
6
votes
3 answers
Postgresql ILIKE versus TSEARCH
I have a query with a number of test fields something like this:
SELECT * FROM some-table
WHERE field1 ILIKE "%thing%"
OR field2 ILIKE "%thing"
OR field3 ILIKE "%thing";
The columns are pretty much all varchar(50) or thereabouts. Now I…

singingfish
- 3,136
- 22
- 25
5
votes
1 answer
NoSQL: indexing and keyword-based searching
I have an application that stores items (e.g. web documents). Each item can feature a arbitrary large set of tags. And typical a common query is to retrieve all documents with given set of tags. Well, a pretty common Web application.
Now I'm…

Christian
- 3,239
- 5
- 38
- 79
5
votes
3 answers
Alternative to Tika/PDFBox for parsing PDF in Solr (any version later than 1.4)
Seems like Solr is not parsing my PDF files correctly. I was wondering if there is any other alternative to using Apache Tika (which I believe uses PDFBox internally) for parsing PDF files? I seem to be getting random spaces in between my content…

Ravish Bhagdev
- 955
- 1
- 13
- 27
5
votes
2 answers
How to create Full-text search index in MySQL AWS Aurora DB InnoDB engine
While trying to add full-text index on the table I am getting below error.
Error Code: 1214. The used table type doesn't support FULLTEXT indexes
And while trying to create a table with MyTSAM engine I am getting below warning message.
0 row(s)…

kushagra
- 131
- 3
- 10
5
votes
1 answer
Postgresql create a search configuration with custom stop word list
For a particular full text search I need to modify the standard stopword file and exclude some words. What I did so far:
Copied german.stop to german_modified.stop and then
removed the words from german_modified.stop. Then:
CREATE TEXT SEARCH…

Alexander
- 93
- 1
- 6