Questions tagged [fulltext-index]
123 questions
1
vote
1 answer
mongodb text search: invalid operator: $search
Closely related to this, but I'm using mongod version 3.2 which means its a different problem.
I created a text index:
> db.mycollection.createIndex({body:'text'})
Then I try to search it:
> db.mycollection.find({$text:{$search:'foo'}})
Error:…
Edward Newell
- 17,203
- 7
- 34
- 36
1
vote
1 answer
mySQL fulltext search problems
I need to implement FULL-TEXT search in a mySQL InnoDB v5.6.20.
I added on two varchar(256) columns one after the other a full-text index after the table was created via
ALTER TABLE 'client' ADD FULLTEXT('company') and
ALTER TABLE 'client' ADD…
Ben
- 677
- 5
- 19
1
vote
1 answer
Weird results with cypher query in Neo4j and node_auto_index
I have a graph database (Neo4j) in which I configured a property to be auto indexed with full-text. Everything is working great except that I have 1 row that is not returned when I execute a particular cypher query.
My property in the graph equals…
Martin Larivière
- 264
- 1
- 10
1
vote
1 answer
How to use text-search in mongo-spring aggregate
How do I translate a simple mongo shell $match phrase, to it's equivelent
in mongo-spring in Java - using aggregation?
$match: { $text: { $search: "read" } }
shemerk
- 257
- 5
- 16
1
vote
1 answer
What will happen in SQL Server if a fulltext search is done using fulltext index defined for other language
I am new to SQL Server full text search.
I have a table in which a column titled description has type ntext and it can contain data in any language.
Now I was going to implement fulltext search and on googling a bit I found currently it is not an…
Zia Ul Rehman Mughal
- 2,119
- 24
- 44
1
vote
1 answer
Why Solr for Windows needs so much memory?
Why Solr for Windows needs so much memory?
My data for Solr is SEO keywords (1-10 words, up to 120 symbols length, 800 million rows) and some other data. Schema is:
devspec
- 49
- 10
1
vote
1 answer
MySQL Inserting data from one table to another - error FULLTEXT index
Hey guys i'm trying to create a stored procedure where I enter in the Loan_ID from my loan_table and it moves it into another table called loan_history. I'm unsure on what I'm doing wrong. The error I'm getting is 'Can't Find FULLTEXT index matching…
Muzza92
- 25
- 3
1
vote
2 answers
SQL Server Full-Text Search against Document (multiple related tables and field)
I have a document (in this case Invoice) structure which contains multiple tables:
Invoice Header (No. (PK), Customer Name, Customer Address, ...)
Invoice Lines (Invoice No. (PK), Line No. (PK), Description, Qty., ...)
Invoice Header Comments…
Ignas Skukauskas
- 11
- 1
1
vote
1 answer
Covering / Composite Indexes with MySQL FULLTEXT
Consider the following table:
CREATE TABLE `item` (
`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
`category` smallint(11) unsigned NOT NULL,
`description` TEXT(500) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `category` (`category`),
FULLTEXT…
Ray
- 40,256
- 21
- 101
- 138
1
vote
1 answer
Full Text Search always returns empty result set
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 fact (id, title) VALUES ('1', 'red blue yellow ok green…
YoungDev
- 13
- 3
1
vote
2 answers
How to do multiple text search using "$text query and $or" in mongodb / mongoose?
Here is the model 'Class' model for which I have created the "text" index for 'keywords','lifeArea',''type'.
Structure of the model:
{
"_id" : ObjectId("558cf6e3387419850d892712"),
"keywords" : "rama,seetha",
"lifeArea" : [
…
Sachin Kalsi
- 135
- 1
- 2
- 12
1
vote
1 answer
Results missing from a mysql FULLTEXT boolean mode search
I'm trying to use a FULLTEXT index in order to facilitate searching for forum posts. It's not working in the way I expect, and I'm trying to understand why not.
For example, I know there is exactly one post which contains the phrase "haha and i got…
Mala
- 14,178
- 25
- 88
- 119
1
vote
1 answer
SQL Server 2008 Bug with Fulltext Creation
I have SQL Server 2008 (Version 10.0.2531).
The following annoying bug? happens, and maybe someone has a workaround: When I create a computed column which also combines values from a scalar valued function, and then add it to the fulltext index via…
Alex
- 75,813
- 86
- 255
- 348
1
vote
1 answer
How does the SQL Server Fulltext Index grow?
I'm trying to get an idea of fulltext index growth and gauge its long-term memory needs.
Does it keep a cache of each search? (Knowing that the first search for a new keywords always takes slightly longer, and is subsequently faster) Will it grow…
Alex
- 75,813
- 86
- 255
- 348
1
vote
1 answer
Speed up SQL Server Fulltext Index through Text Duplication of Non-Indexed Columns
1) I have the text fields FirstName, LastName, and City. They are fulltext indexed.
2) I also have the FK int fields AuthorId and EditorId, not fulltext indexed.
A search on FirstName = 'abc' AND AuthorId = 1 will first search the entire fulltext…
Alex
- 75,813
- 86
- 255
- 348