Questions tagged [fulltext-index]
123 questions
1
vote
1 answer
SQL Server Full-Text Search not working on PDF File
My full text search works with doc and docx but not working with pdf. The filters have pdf fullpath: C:\WINDOWS\system32\Windows.Data.Pdf.dll
version: 6.2.19041.1023
Tell me what could be the matter?
CREATE TABLE [dbo].[FilesSearch](
[id]…
zig8953
- 47
- 1
- 9
1
vote
2 answers
MySQL how to index a query that searches for a substring in column while filtering integer columns
I have a table with a billion+ rows. I have have the below query which I frequently execute:
SELECT SUM(price) FROM mytable WHERE domain IN ('com') AND url LIKE '%/shop%' AND date BETWEEN '2001-01-01' AND '2007-01-01';
Where domain is varchar(10)…
bcsta
- 1,963
- 3
- 22
- 61
1
vote
0 answers
MySQL - N-Gram Parser Causes High CPU Usage
We have a website and its database is running on the AWS RDS.
There is only one FULLTEXT index on a innodb table for the site search feature.
Most of our data contains CJK characters, due to the behavior of default parser is not suitable for CJK…
CryMasK
- 295
- 5
- 14
1
vote
1 answer
Does using FULLTEXT in MySQL require for me to use a different syntax in PHP to retrieve the results?
Here's my code:
$terminosBuscados = 'Vender la porteria'
$x = $conectarDB->prepare("
SELECT DISTINCT
titulo,
FROM_UNIXTIME(fecha, '%d-%m-%Y') AS fecha,
cuerpo,
tipoContenido,
autor
FROM searchIndex
WHERE…
Rosamunda
- 14,620
- 10
- 40
- 70
1
vote
4 answers
SQL Server 2008 full-text index issue
I have a TableA as specified below in which a full-text index is specified for column Name
TableA
Id (PK)
Name (TXI)
The table has the following records:
ingrid
neville
ned
audry
inga
I then run the following query against the table:
SELECT * FROM…
Luis
- 11
- 1
1
vote
1 answer
How to create text index with default language using Pymongo
I can't figure out how i set default language from Python/Pymongo.
From the mongo console I can create the Index that I want like this:
>> db.collection.createIndex({"column1": "text", "column2": "text"}, {"default_language": "none"})
From…
Jonas Melin
- 33
- 6
1
vote
1 answer
SphinxSearch: Cannot get result from (remote) agent
I build 2 searchd instance on different server(namely A and B) and build a distributed index on A. However, when I query A from client, I only got result from A's index. My problem is I cannot get result from B' index, I am pretty sure I configure…
Tianxu
- 61
- 5
1
vote
1 answer
mongoDB: Full text query for strings containing single letters in PyMongo
I have a collection in MongoDB where-in each document contains title and color. I want to perform a full text search with the title key. For this, I am using the following piece of code :
mycol.create_index([('title', 'text')])
mycol.find({"colors"…
Aniruddh Chandratre
- 464
- 2
- 10
1
vote
1 answer
Fulltext search not yielding results
I've started working with Fulltext indexing, and I've ran into a problem that I can't find a solution for.
Ive created a catalog with
create FULLTEXT CATALOG [ClaimDbCatalog] AS DEFAULT
Then my table looks like ...
create table Claim(
Id int…
WynDiesel
- 1,104
- 7
- 38
1
vote
0 answers
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.…
Dgame
- 26
- 3
1
vote
0 answers
SQL Full Text Search - Position of word in field
I have a table of keywords in a SQL Server box that are currently stored with a full text index. I have been asked to add a facility to our searches that prioritise results where the result is closer to the start of the column.
CREATE TABLE…
Matthew Baker
- 2,637
- 4
- 24
- 49
1
vote
2 answers
Find frequency of each similar word in a large text c#/sql
I need to group words as similar and then find the frequence.
So text like "moron and morons sat on moronic bench with mormons" will yield result
Moron 3
Sat 1
Mormon 1
I need to be able to push a text or list of exact words in one query and…
Boppity Bop
- 9,613
- 13
- 72
- 151
1
vote
1 answer
Optimizing SQL CONTAINS while using OR
In SQL Server 2014 I'm attempting to use contains for several different terms. The query is taking an exceptionally long time and I'm curious if it is faster to separate the contains commands or to use them in the same statement.
For example, is…
Linguisize
- 11
- 1
- 3
1
vote
1 answer
Name searching in ElasticSearch
I have a index created in ElasticSearch with the field name where I store the whole name of a person: Name and Surname. I want to perform full text search over that field so I have indexed it using the analyzer.
My issue now is that if I…
sayfra85
- 11
- 4
1
vote
2 answers
FULLTEXT index takes longer to execute
The following query takes 1.1s to execute, the EXPLAIN shows the use of a FULLTEXT index:
SELECT SQL_NO_CACHE COUNT(*)
FROM e_entity
WHERE meta_oid=336799 AND MATCH(sIndex07) AGAINST ("#UPR-1393#" IN NATURAL LANGUAGE MODE)
EXPLAIN:
id:…
Rafael
- 1,099
- 5
- 23
- 47