Questions tagged [full-text-indexing]

indexing for full-text search

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?
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
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…
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…
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…
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…
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)…
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
1 2
3
37 38