full-text-search Questions
7
Solved
I am getting following error in my SQL server 2008 R2 database:
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblArmy' because it is not full-text indexed.
Georgenegeorges asked 14/5, 2011 at 16:39
3
Solved
This seems like a really basic question, but how do I change the default limit for the pg_trgm extension? Which is currently 0.3. I have done:
select set_limit(0.5)
select show_limit() => 0.5
...
Broadleaved asked 30/1, 2013 at 15:50
1
Solved
I asked this question yesterday on dba.stackexchange.com and didn't get any responses, so I'm trying here.
I'm getting MySQL 1032 "Can't find record in 'person'" errors for some queries in my data...
Hazel asked 28/3, 2019 at 17:21
2
How to set a weight for tsquery? I need to set a weight for tsquery obtained from plainto_tsquery.
Is it possible? Something like setweight(plainto_tsquery(''), 'A'), but it works only for tsvecto...
Ramble asked 13/3, 2017 at 15:37
1
Solved
I'm trying to utilize the full text search feature of PostgreSQL, particularly when user types in some search text, I would like to display him results with an assumption that the last word is inco...
Haber asked 7/2, 2019 at 14:28
1
Solved
I have a table with a text field and a tsvector containing the search index for that field:
CREATE TABLE test (pk bigint, value text, tsv tsvector);
How do I create a single tsvector that is the...
Valediction asked 21/1, 2019 at 14:49
1
I have been very unhappy with full text search performance in MongoDB so I have been looking for outside-the-box solutions. With a relatively small collection of 25 million documents sharded across...
Anacoluthia asked 31/8, 2018 at 17:58
2
Solved
I am trying to create a Full Text Search for an address autocomplete feature, leveraging Django (v2.1) and Postgres (9.5), but the performance is not suitable for an auto-complete at the moment and...
Ecclesia asked 16/12, 2018 at 4:59
4
Solved
I have an index on an array "keys" that I am using to provide full text functionality to my applicaiton.
With the release of 2.4.3, I'd like to utilize the "text" index type. I insured a "text" in...
Pyro asked 3/6, 2013 at 17:44
2
Solved
I'm performing weighted search on a series of items in an e-commerce platform. The problem I have is ts_rank is giving me the exact same value for different combinations of words, even if the ts_ve...
Appointive asked 20/4, 2016 at 9:19
3
Solved
Recently I changed a bunch of columns to utf8_general_ci (the default UTF-8 collation) but when attempting to change a particular column, I received the MySQL error:
Column 'node_content' cannot b...
Historian asked 17/3, 2009 at 5:14
2
I am using Azure for hosting my project and chosen blob to store all by files (as they are in megabyte and count is huge). I have a requirement to search within all my files in blob (kind of like f...
Lagasse asked 16/2, 2015 at 11:8
2
Solved
Let's say we have 1 million of rows like this:
import sqlite3
db = sqlite3.connect(':memory:')
c = db.cursor()
c.execute('CREATE TABLE mytable (id integer, description text)')
c.execute('INSERT IN...
Galingale asked 14/10, 2018 at 13:12
0
My client has a project based on Firebase. They want me to add some functionalities to its core, and make necessary changes on client applications. One of the new functionalities requested is...
Cowry asked 21/10, 2018 at 14:3
2
I have a set of 4 tables that I want to search across. Each has a full text index. Can a query make use of every index?
CREATE TABLE `categories` (
`id` int(5) unsigned NOT NULL auto_increment,
...
Mariejeanne asked 6/8, 2009 at 21:28
2
Solved
Recently I have been messing around with Android Architecture Components (more specifically Room) but I have hit a bit of a roadblock.
I have successfully built a Room database that stores a list o...
Mousetail asked 4/4, 2018 at 16:29
1
Solved
I'm trying to perform a filter by pattern over a Firestore collection. For exemple, in my Firestore database I have a brand called adidas. The user would have an search input, where typing "adi", "...
Enucleate asked 3/10, 2018 at 12:36
0
I had thought Unicode61 Tokenizer can support CJK -- Chinese Japanese Korean
I verify my sqlite supports fts5
sqlite> pragma compile_options;
BUG_COMPATIBLE_20160819
COMPILER=clang-9.0.0
DEFAUL...
Hedvig asked 20/9, 2018 at 9:59
2
I was looking how to migrate an existing application to Room, from plain Sqlite, and I haven't been able to find how could I migrate a part that uses FTS.
Right now, I have a virtual table that's ...
Mica asked 29/11, 2017 at 8:29
6
Solved
I have huge text data. My entire database is text format in UTF-8
I need to have list of most repeated phrase on my whole text data.
For example my desire output something like this:
{
'a': 423...
Communist asked 20/4, 2015 at 16:41
6
Solved
Regular expressions are highly unreadable and difficult to debug. Does there exist any replacement for text processing which could be handled by mere mortals?
Criteria include
It's a library or ...
Obsolete asked 16/7, 2011 at 11:42
3
Google deprecated their Freebase Search API, and is transferring things over to Wikidata, however there appears to be no replacement for their Freebase Search API (https://developers.google.com/fre...
Graniela asked 11/9, 2015 at 19:58
1
Solved
I have a table with HTML data, that I want to search using the Full Text Index via an html-filter
So I created an index:
CREATE FULLTEXT CATALOG myCatalog AS DEFAULT
CREATE FULLTEXT INDEX ON myT...
Forbes asked 27/7, 2018 at 10:1
1
Solved
I am looking at using Full Text Search but not 100% clear on how to get it up with EF Core 2.1.
It seems that EF Core 2.1 might have implemented partial support for Full Text Search but I am not ...
Mezoff asked 25/6, 2018 at 16:53
3
Solved
Following on from this answer I want to know what the best way to use PostgreSQL's built-in full text search is if I want to sort by rank, and limit to only matching queries.
Let's assume a very s...
Caftan asked 17/10, 2012 at 11:58
© 2022 - 2024 — McMap. All rights reserved.