indexing for full-text search
Questions tagged [full-text-indexing]
569 questions
0
votes
1 answer
Number of PhraseQuery matches in a document
This is my code to perform a PhraseQuery using Lucene. While it is clear how to get score matches for each document inside the index, i am not understanding how to extract the total number of matches for a single document.
The following is my code…
Alex Torrisi
- 97
- 1
- 8
0
votes
0 answers
Create Index Collection on MongoDB
suppose I have a database in mongodb called "test"
inside this db "test", I have 3 collections, which is "test-subone", "test-subtwo", "test-subthree".
let's assume that those 3 collections have an attribute in common, which is "testattr". And what…
xemjas
- 115
- 4
- 16
0
votes
2 answers
mySQL full text index slows query
I have a table with two columns: "users" has a full text index, "x" is a simple int column. The table contains just under 2 million entries. Using match...against to select rows containing a certain user returns quickly.
Searching by the value of x…
ReallyMadeMeThink
- 1,061
- 7
- 11
0
votes
1 answer
efficient mySQL fulltext index
I'm looking to store the results of a game in a table. Each round will be played by 2-10 players. Each player will score between 1-5 points. I need an efficient way to retrieve all rounds for a given player/score range. For example:
select all…
ReallyMadeMeThink
- 1,061
- 7
- 11
0
votes
0 answers
MySQL - Can't find FULLTEXT index matching the column list
I saw so many similar question with this same error and the solution is altering the table by adding FULLTEXT to the columns.
But now the problem is I'm writing the query to a VIEW instead of an table. So I can't alter the columns as mentioned in…
Shihas
- 814
- 15
- 44
0
votes
1 answer
Elasticsearch Handling of Deleted Documents
We are using Elasticsearch (6.1) for indexing. We used to update our documents on daily basis. We are facing problems with count API. Basically we are getting the incorrect count.
My analysis came out that it's because of how Lucene handles the doc…
Prashant
- 35
- 5
0
votes
0 answers
Why function zdb(unknown, tid) does not exist in my zombodb extension?
I am indexing in zombodb extension in postgres. I want to index like this .
CREATE INDEX idx_zdb_masterview
ON masterview
USING zombodb(zdb('masterview', masterview.ctid), zdb(masterview))
but it has error :
[Err] ERROR: function…
Fatemeh Moh
- 129
- 1
- 5
- 13
0
votes
0 answers
Error creating Oracle text index
I'm trying to create a text index and running into issues.
EXEC ctx_ddl.create_preference('DRG_INDX_DST','multi_column_datastore');
EXEC ctx_ddl.set_attribute('DRG_INDX_DST', 'columns', 'DRG, DESCRIPTION');
EXEC…
JKint
- 11
- 1
- 3
0
votes
1 answer
How do websites do fulltext search and sort?
How do websites implement search and sort? (example: ecommerce search for a product and sort by price)
I've been wrestling with this for a while. I'm using MySQL and after long discussions here it seems that MySQL can't handle this. I've also asked…
user1950164
0
votes
1 answer
MYSQL GROUP BY returns no results with FULLTEXT SEARCH
I have the following MYSQL schema:
CREATE TABLE IF NOT EXISTS `tag` (
`id` SMALLINT UNSIGNED NOT NULL,
`tag` VARCHAR(15) NOT NULL,
FULLTEXT INDEX(`tag`),
PRIMARY KEY (`id`,`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO…
Michael Samuel
- 3,820
- 12
- 45
- 85
0
votes
1 answer
MySql - Error Code: 1215. Cannot add foreign key constraint if fulltext index added
I have a database and i took up a dump using --no-data.
I am trying to import that DB structure in an empty DB.
I am ignoring other queries, following the queries I am trying to execute,
set foreign_key_checks=0;
DROP TABLE IF EXISTS…
Akshay
- 3,558
- 4
- 43
- 77
0
votes
2 answers
FullText search by FullName when FullName is not a column, but has firstName and LastName
I have a below query, i do not have a fullName field , but queryText input can have fullname.
my search by firstName or lastName works, but user provides both first and last name it does not work.
@queryText of
John Works
Doe Works
John Doe Does…
Justin Homes
- 3,739
- 9
- 49
- 78
0
votes
1 answer
Full Text Index on SQL Server 2008
We can index the table by right-clicking on the table name in SQL management studio and clicking on Full-Text index.
This option is present but is 'disabled' (appears in light gray) in my management studio.
Also MSDN blogs points out regarding…
Tom
- 208
- 1
- 4
- 11
0
votes
2 answers
SQL Full Text Indexer, exact matches and escaping
I'm trying to replace a Keyword Analyser based Lucene.NET index with an SQL Server 2008 R2 based one.
I have a table that contains custom indexed fields that I need to query upon. The value of the index column (see below) is a combination of name/…
Kieron
- 26,748
- 16
- 78
- 122
0
votes
1 answer
full text search implementation with Golang and MongoDB using mgo
I am trying to print the 6 objects I know contain my search term. I am able to see the query array of the right length/size/capacity. But when I iterate the array and print, they do not contain any information.
My initial reaction is that maybe I…
Cit5
- 400
- 5
- 19