full-text-indexing Questions

2

Solved

I want to penalize some terms in query, not to ignore them at all so "MUST NOT" operator will not work? Is it possible to use negative query boost with SHOULD in boolean query in lucene, how does i...
Intemerate asked 9/12, 2010 at 13:9

3

I want to do general substring search among billions of strings. The requirement is a little different from general fulltext search because I want a query "ubst" also can hit "substr". Is Lu...
Ballarat asked 27/7, 2011 at 2:1

3

Solved

I see that Neo4j have Indexes to support full-text search. But I can't find examples in the documentation on how to use this ability with regular relations query. For example, I have the following...
Anticlimax asked 14/4, 2019 at 11:20

6

I am looking for a function like strpos() with two significant differences: To be able to accept multiple needles. I mean thousands of needles at ones. To search for all occurrences of the ...
Graphemics asked 1/8, 2011 at 9:38

11

Solved

Env: MongoDB (3.2.0) with Mongoose Collection: users Text Index creation: BasicDBObject keys = new BasicDBObject(); keys.put("name","text"); BasicDBObject options = ne...

2

Solved

I am writing a newsletter script and I need to implement searching in the addresses. I indexed the table with FULLTEXT but when I do a query such as: SELECT * FROM addresses WHERE MATCH(email) AGA...
Justinejustinian asked 22/1, 2012 at 12:45

3

We're developing a search as a part of a bigger system. We have Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Standard Edition (64-bit) with this setup: CREATE TABLE NewCompanies( [Id] [uniquei...

3

Solved

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?
Dissociate asked 23/3, 2016 at 9:35

4

Wondering what are the best practice or experiences used for multilingual indexing and search in elasticsearch. I read through a number of resources, and as best as I can distill it the available o...
Toffey asked 3/3, 2014 at 17:43

3

Solved

Got a requirement to rebuild mssql full-text index. Problem is - I need to know exactly when job is done. Therefore - just calling: ALTER FULLTEXT CATALOG fooCatalog REBUILD WITH ACCENT_SENSITIVI...
Pythagoreanism asked 7/7, 2009 at 11:27

2

Solved

For the past 4 days I have had massive problems with my nightly updates, except for 1 night were it all went fine in between these 4 days. During these updates i update a couple of fulltext indexe...
Bibliopole asked 21/7, 2014 at 7:52

3

I am trying to crawl a website, more specifically a Google Site using ManifoldCF that has SAML authentication and index the crawled data into Apache Solr. But as I crawl the URL, it gives me 302 re...
Congregation asked 8/8, 2016 at 14:7

2

We've a node.js + mongoose app running on Ubuntu linux servers spun on DigitalOcean VPS. One of our mongoose queries have a text index with the following operators: less than / equal to limit or...
Deafening asked 1/1, 2018 at 10:51

3

Solved

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 c...
Encarnalize asked 14/10, 2015 at 14:22

1

I am trying to figure out the concept of elastic search index and quite don't understand it. I want to make a couple of points in advance. I understand how inverse document index works (mapping ter...
Outnumber asked 29/10, 2017 at 17:46

4

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 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> &...

1

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 Statistic...

6

Solved

I am using Lucene.Net for indexing and searching documents, and I am using the following code to create or open an index if one exists: IndexWriter writer = new IndexWriter(@"C:\index", new Standa...

4

Solved

I understand that a fundamental aspect of full-text search is the use of inverted indexes. So, with an inverted index a one-word query becomes trivial to answer. Assuming the index is structured li...

1

Solved

It is possible to search words in one sentence with Sphinx. For example, we have next text: Вася молодец, съел огурец, т.к. проголодался. Такие дела. If I search молодец SENTENCE огурец i f...
Clericals asked 12/9, 2016 at 8:57

3

Solved

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!!!). ...
Adopt asked 18/4, 2013 at 14:58

1

Solved

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: CR...

1

Solved

I have a table named 'fact' with title column, that should be full text index. Firstly, I add a full text index: ALTER TABLE fact ADD FULLTEXT title_fts (title) So, I insert row: INSERT INTO f...

1

Solved

I've set ft_min_word_len = 1 and running show variables like 'ft%'; also shows the same. Also have already updated the Fulltext indexes by dropping and re-creating them. But when I run SELECT Orig...
Fuller asked 2/2, 2015 at 12:58

2

I am trying to create FULL TEXT index using Entity Framework Migration by executing custom Sql. My migration class looks like this: public partial class DocumentContentFullTextIndex : DbMigration...

© 2022 - 2025 — McMap. All rights reserved.