Questions tagged [full-text-search]

1

votes
2

answer
2.5k

Views

function ts_rank_cd(text, tsquery) does not exist

I'm using full text search supported by postgres, I installed acts_as_tsearch plugin and it works successfully, but when I tried it later I found an error runtimeError: ERROR C42883 Mfunction ts_rank_cd(text, tsquery) does not exist HNo function matches the given name and argument types. You might n...
Ahmad Bakr
1

votes
1

answer
483

Views

Searching 13 million records using full text search with additional conditions

Performance issue while doing SQL Server full text search with additional conditions. (SQL Server 2012) I am trying to filter the data based on search filters list (table value parameter), which will return all the records for match filters and single record for the filter doesn't have any record fr...
K.Engineer
0

votes
0

answer
12

Views

Full Text Search Using Multiple Partial Words

I have a sql server database that has medical descriptions in it. I've created a full text index on it, but I'm still figuring out how this works. The easiest example to give is if there is a description of Hypertensive heart disease Now they would like to be able to type hyp hea as a search term a...
Jhorra
1

votes
0

answer
155

Views

how to paginate in Elastic Search Autocomplete (search as you type in index time)

I am facing a road-block in elastic search autocomplete feature. I am using custom analyser to a autocomplete field & it is working like a charm as expected . Now I want to paginate the result so that my client (angular app) does not need to deal with high volume of data . Precisely , user types 'MA...
spondon majumdar
1

votes
0

answer
46

Views

Searching using SQL Server Full Text Index support 'or not' operation

Is there a way to support Boolean expression like (x and y) or (not z) in full text index search? I am using SQL Server 2016. I have read this article: CONTAINS (Transact-SQL) I see that 'or not' is not supported. Any help?
Ali Alnader
1

votes
0

answer
76

Views

Google App Engine Java - Temporary Search Error (FTS)

I receive for a lot of queries on my FTS indexes this exception: com.google.appengine.api.search.SearchException >> Temporary search service error com.google.appengine.api.search.IndexImpl$4.convertException(IndexImpl.java:354) com.google.appengine.api.utils.FutureWrapper.get(FutureWrapper.java:97...
Andrei F
1

votes
1

answer
844

Views

Implementing MongoDB search engine API in Flask

I am new to MongoDB and I am trying to build a simple search page using MongoDB in Flask. I have a restaurants.json ingested into MongoDB: { '_id' : ObjectId('57506d62f57802807471dd42'), 'name' : '456 Cookies Shop', 'contact' : { 'phone' : '604-555-0149', 'email' : '[email protected]', 'l...
Feyzi Bagirov
1

votes
1

answer
151

Views

Full-text search stemming not returning consistent results in different languages

I have an Sql Server 2016 database with full text indexes defined on 4 columns, each configured for a different language: Dutch, English, German & French. I used the wizard to setup the full-text index. I am using CONTAINSTABLE with FORMSOF and for each language I would expect executing a query with...
redrobot
1

votes
0

answer
252

Views

Find a list of numbers, using a text file, in Notepad++

I am wanting to do a search in Notepad++ (or any other text editor), that will allow me to give a list of numbers; say: text1.txt: 00124573 00758392 00856375 04800372 73049002 etc. And then put it through the text editor, and then write out all the non-matches to a text file? So my original.txt woul...
Kevdog777
1

votes
0

answer
221

Views

mysql search name with full text index

I have been struggling with full-text search with MySQL but always have some issues, I have 2 columns first_name and last_name, my app is built on php codeigniter framework, at first i was searching name with mysql LIKE. $this->db->like('CONCAT(TRIM(co.first_name),' ',(co.last_name))', trim($search...
Wasif Khalil
1

votes
3

answer
232

Views

MongoDB excluding exact match from text search

I'm using MongoDB's full-text search functionality to search for specific strings in my database. However, when I use the $search operator (I'm using MongoDB's native Node.js driver), the result that I know would provide the best match does not appear at all. For example, I have a string 'CSCE-314...
Quontas
1

votes
1

answer
192

Views

Stored procedure fulltext search

Can I have some help with next: My c# app calls for sql stored procedure, and passes some search term (string containing multiple words). public List GetZapis_FullText(string Parametar) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(SQLConn.CnnVal(Program.db))) { var out...
leroy
1

votes
1

answer
124

Views

Best way to handle apostrophes when searching a MYSQL database

I am currently using MATCH column_name AGAINST ( 'search_term' IN NATURAL LANGUAGE MODE); where column_name is full text indexed. This works for the majority of cases but if the user searches for 'items' I would like it to return both 'short string items' AND 'short string item's' from the DB (assum...
quinlo
1

votes
1

answer
44

Views

Print line in which search item occurs in python

I'm trying to get my program to print the line in which a search item occurs in Python. This is my current attempt: search = input('Input your search term: ') found = 0 printline == False with open ('search.txt', 'r') as data: for line in data: if search.casefold() in line.casefold(): found += l...
Mountain Scott
1

votes
0

answer
118

Views

Search text in file stored as SQL varbinary column in Azure Database

We have a Database in Azure where we're storing files of different types(.docx, .doc, .pdf, .txt, .ppt, .pptx) in a varbinary column. I tried to configure the fulltext search like that: CREATE FULLTEXT CATALOG DbaAttachments; CREATE FULLTEXT INDEX ON dbo.Attachments( Attachment TYPE COLUMN FileExten...
Detelina
1

votes
0

answer
51

Views

SQL Server : full text search

I was trying to setup the full text search on a table. Below is Script to repro my issue: Creating table: create table dbo.articles ( id int identity(1, 1) not null, title varchar(255), content varchar(max) ); Adding the primary key constraint: alter table dbo.articles add constraint PK_articles...
Sourabh Tiwari
1

votes
1

answer
73

Views

MSSQL Full Text search on binary field yields no results

I have a MS SQL database with a table that holds binary images of various documents (Word, Excel, PDF, etc). I installed the Office Filters for FullTextSearch. I ran: EXEC sp_fulltext_service 'load_os_resources', 1 exec sp_fulltext_service 'update_languages'; EXEC sp_fulltext_service 'restart_all_f...
cristi71000
1

votes
0

answer
75

Views

Couchbase SearchQuery doesn't return rows when the matchPhrase value is “all”

I am using couchbase java-client version 2.5.4 and jdk 1.8. Couchbase SearchQuery doesn't return values when match phrase is 'all'. users: firstname lastname age gender Ani Mary 12 Female John William 16 Male Rohan all 12 M...
SST
1

votes
0

answer
50

Views

MongoDB: How is a Text-Index stored in the metadata?

I'm curious how MongoDB stores a Text-Index inside the metadata. I assume it's somehow an array of stopword-filtered and stemmed words, but I can't find any official hints. To be more clear: I want to know how they are stored inside the metadata. E.g. how a Text-Index would look like for a document...
Namespace
1

votes
1

answer
222

Views

Django 2 + PostgreSQL FullText search not matching what it should

I am experiencing a problem I hope someone can enlighten me about. I need to perform a full-text search on a table with multiple columns and sorting the results by rank, using Django 2 and PostgreSQL 10.1. So far this is my code: from django.contrib.postgres.search import SearchQuery, SearchRank, Se...
Biagio Distefano
1

votes
0

answer
185

Views

Tweaking MySQL's ngram fulltext index

If I index the terms Maya Angelou and May Angelou (using MySQL's ngram fulltext index parser) and then search for the term may, the two items get the exact same score. Is there a way to optimize it so that May Angelou comes up first? See: CREATE TABLE test( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY...
chintogtokh
1

votes
1

answer
476

Views

Django full text search using indexes with PostgreSQL

After solving the problem I asked about in this question, I am trying to optimize performance of the FTS using indexes. I issued on my db the command: CREATE INDEX my_table_idx ON my_table USING gin(to_tsvector('italian', very_important_field), to_tsvector('italian', also_important_field), to_tsvect...
Biagio Distefano
1

votes
0

answer
54

Views

ContainsTable: noise/stop word giving no results

Suppose you have the following queries (using PT language): declare @textoPesquisa as nvarchar(200) = 'haiti and florida and à' if(@textoPesquisa is null or @textoPesquisa='') set @textoPesquisa = '*' select * from Noticias n left join containstable(NoticiasParaEstatistica, (Titulo), @textoPesq...
Luis Abreu
1

votes
1

answer
34

Views

Create CouchBase FTS from application

Is there a way to create CouchBase FTS from an application? The only way I could find in official documentation, is to create it manually from the web ui, but I need to do it from my application code. Preferably from SDK (.net/C#), or at least by posting FTS definition to some url.
Merdan Gochmuradov
1

votes
0

answer
45

Views

How do I find the nth occurence of a substring from a specified offset within a text file?

Assume the existence of an unformatted raw text file having variable length lines, delimited by CR/LF-sequences. The FileStream object is named oFS. I want to extract some portion of it, as a String array, beginning at a position held in the Long named lCandidate. lCandidate is guaranteed to hold a...
Herb
1

votes
1

answer
38

Views

How to combine full_text_search with unaccent using Sequel gem?

How can I use the method Sequel.full_text_search combined with the function available in PostgreSQL unaccent in order to return records that match the search term regardless characters with accents? For example: # Given a user with first_name: Nícolas User.full_text_search(:first_name, 'nicolas').c...
Nícolas Iensen
1

votes
0

answer
42

Views

T-SQL CONTAINS having problems with fulltext index on computed column with a long number

I have a computed field with a full-text index on it. It's working properly except for just a few records out of thousands, and why remains a mystery: [fake name] JAMES J BRATWURST LTDJ LCHM LCDAA1 ACD 1215041803 111.223.3333 A select-query with ... where CONTAINS(searchname,'bratwurst') works fin...
Tim
1

votes
1

answer
33

Views

How to flush App Engine SearchServiceFactory async operation in JUnit?

I'm using App engine Standard env and my services use the Search API. So basically in my service I do something like: IndexSpec indexSpec = IndexSpec.newBuilder().setName(indexName).build(); Index index = SearchServiceFactory.getSearchService().getIndex(indexSpec); index.putAsync(document); I'd like...
Freddy Boucher
1

votes
0

answer
23

Views

SQL Fulltext index seems to ignore subscript/superscript numbers

I have a fulltext index on a binary field that stores superscript and subscript numbers. When searching the field, the same results are returned whether you add super/sub script numbers to your search or not. Some details on how this is structured: I have a table where I am storing HTML but the tex...
Jean-Luc Chapotot
1

votes
0

answer
97

Views

Solr faceting on multivalued field with grouping

I have schema, which looks something like this. objectID I want to group results on skuID where i want distinct skuID count of each category. I ran query like, group=true&group.field=skuID&group.facet=true&facet=true&facet.field=category&group.ngroups=true&facet.mincount=1 or { group: true, group....
Roshan
1

votes
1

answer
29

Views

Full text search order by text length

I have a search box which allow users to enter a partial string and show an auto complete for the whole name. Basically I want to do WHERE LIKE %partial%. But since the LIKE query can't make use of index when there is a leading wildcard, I ended up using full text index My full text query looks lik...
Steve
1

votes
1

answer
140

Views

Different Results on Full Text Search for same search on different cases on Spanish Language

I'm using Full Text CONTAINS on SQL Server 2016 to search on a table. But if I change the case on my query I get different results. For example: Doing this (with upper case L): select * FROM CONTAINSTABLE(OITM, (ItemCode), ''L-1326*'' ) returns this: L-1326 416 L-1326-COVER-SSS 208 L-1326-SSS...
Jonathan Queipo
1

votes
1

answer
268

Views

MySQL Fulltext search: Using distance with wildcards

My data looks like this: [column 'content'] The quick red horse jumps over the quick dog The quick brown horse The quick brown horse jumps over the lazy dog The quick brown horses jumps over the dog quick as a mouse was the spider. The horse is brown. I use MATCH and AGAINST to get all rows with hor...
Sarah Trees
1

votes
1

answer
29

Views

Irrelevant search results with lucene.net

I have been developing a search engine for a business directory application using Lucene.net. However when i search for Sports shop it returns the result of other shops including the sports shops because the key word shop matches with that. So how can i prioritize that it should return the results w...
Vishnu PS
1

votes
0

answer
78

Views

Update an array of text with itself to run a “trigger” function in PostgreSQL

Full-text search in PostgreSQL is new to me. So bear with me. I'm working on an existing PostgreSQL table that has a column of type text[] (named tags) that I'd like to implement full-text search on. I've added another column of type ts_vector (named tags_tsv) that will contain the indexable lexemes...
KA01
1

votes
0

answer
76

Views

T-SQL CONTAINS and CONTAINSTABLE and punctuation like the period / dot

Is there a way to make full-text search in SQL Server 2012 a little more 'naive', removing the 'intelligence' that causes it to treat the [.] character as a word separator? We have meaningful strings that contain dots and want to treat the entire string as a contiguous token, not as separate chunks....
Tim
1

votes
2

answer
51

Views

ElasticSearch Query Ignoring Additional Search Terms

I'm using ElasticSearch to build a free form search-as-you-type feature over multiple structured fields. The main fields people search on are first_name, last_name, and city. Problem: The following two searches David Salazar and David Salazar Denver are returning the same results in which 'Denver'...
dsal1951
1

votes
1

answer
52

Views

“Match.Error” message : “Match error: Expected particular constructor”

I am new to the Meteor and React Framework, and I am trying to incorporate 'search' in meteor, and using the package easysearch for it. I am getting an error. The exact wordings of the error are as follows: match.js:40 Uncaught errorClass {message: 'Match error: Expected particular constructor', p...
crazyy_photonn
1

votes
1

answer
139

Views

MySQL Fulltext search query matching ALL words still returns partial matches

I'm having the identical issue that this poster had, however the accepted answer didn't resolve my issue. Basically I'm trying to match my 'title' column with ALL of the words in a fulltext search query, yet it's still returning partial matches. I recently transferred my MySQL database tables to a n...
1

votes
3

answer
59

Views

Mysql - Search for a multi-word query

I'm trying to return results from a table of products when a user searches it by name. Currently I have this query (simplified): SELECT id, name FROM products WHERE status > 0 AND MATCH(name) AGAINST('test druzy%' IN BOOLEAN MODE) ORDER BY id desc LIMIT 0, 50 Where my search query was test druzy. T...
VeeK

View additional questions