Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
0 answers

Postgres: optimize query where column is in string

Lets say I have a table like so: webpages id | url ------------------------ 1 | http://example.com/path 2 | example2.biz/another/path 3 | https://www.example3.net/another/path And I want to search which webpages' url column is a…
osdiab
  • 1,972
  • 3
  • 26
  • 37
0
votes
2 answers

MariaDB FULLTEXT index on more than 16 columns?

The MariaDB documentation for InnoDB Limitations states that: A multicolumn index on InnoDB can use a maximum of 16 columns. If you attempt to create a multicolumn index that uses more than 16 columns, MariaDB returns an Error 1070. Is there…
Liam
  • 19,819
  • 24
  • 83
  • 123
0
votes
2 answers

Hibernate Search manual indexing throw a "org.hibernate.TransientObjectException: The instance was not associated with this session"

I use Hibernate Search 5.11 on my Spring Boot 2 application, allowing to make full text research. This librairy require to index documents. When my app is launched, I try to re-index manually data of an indexed entity (MyEntity.class) each five…
j.2bb
  • 881
  • 3
  • 10
  • 17
0
votes
2 answers

indexing algorithm to use for free form text

I am tasked with working on an app to index free form text, for fast look-up. I am sure this is an area that has been researched to death. However I am not sure where to start, any help is greatly appreciated.
treefrog
  • 1,027
  • 1
  • 15
  • 30
0
votes
0 answers

Need a way to find a string across entire access database

I installed an access add-incalled "Search Wizard" by Dev Ashish and Terry Kreft. But it doesn't work right. It is supposed to search across the entire access database, including forms, code, queries, reports, etc. for a given string. However it…
itguy2015
  • 3
  • 3
0
votes
0 answers

MySQL FullText Index is not managing Index for recent insert

I am using MYSQL Engine InnoDB. I created fulltext index on my exisitng table but when I insert new record it couldn't pickup my new insert data. Below query is working when I drop my index and regenerate it. But when I creat index and Insert new…
Humaira Faheem
  • 1
  • 3
0
votes
1 answer

how to index associated models using thinkingtank and indextank

We are using thinkingtank gem and having trouble indexing model associations, even simple ones. For example, a profile belongs to an institution, which has a name – we would like to do something like: class Profile < ActiveRecord::Base #model…
Cory Schires
  • 2,146
  • 2
  • 14
  • 26
0
votes
1 answer

Elastic Search List all Keys for a Matching Condition with time range

I have to search through the ES to print out the fields when it match's a condition for a time period. Tried the below query to match one Number in last 24hours and it didnt give me an output { "query": { "bool": { "must": { …
Sajeesh Krishnan
  • 75
  • 6
0
votes
0 answers

How to FULLTEXT index a table in a different database, same server

I am allowed to create/manipulate objects in one database but not in another. The Table I am interested in - let's call it DBNoModify.dbo.SourceTable has 2 fields Name & Description. I would like a fulltext index on the concatenation (Name + ' ' +…
Hugh Jones
  • 2,706
  • 19
  • 30
0
votes
1 answer

Error when searching for MySQL FT index with special character and '*'

I am trying to search in MySQL FT index for strings that start with 'Ford' to be able to find string like 'Ford', 'Ford1', 'Ford3', 'FordFord' etc... (this is why I am using '*'): SELECT DISTINCT CARS.car FROM CARS_FT_INDEX CARS_IDX WHERE ( MATCH (…
Mike
  • 1,007
  • 2
  • 16
  • 33
0
votes
1 answer

How to use Sphinx search in java

I'm set up Sphinx and indexed my table. It works correctly in the console, but how i can execute this query in java? Is it possible? I guess Intellij Idea doesn't understand SphinxQL.
Dmitry Goncharuk
  • 1
0
votes
1 answer

Unable to create FULLTEXT INDEX in MYSQL for Arabic Text

I have have a large MySQL database. One table 'news' has over 6million entries. Two columns are Arabic language text. I am able to create an index for the two columns using: mysql> CREATE FULLTEXT INDEX news_index ON news(news_title,…
Boerjie
  • 43
  • 6
0
votes
0 answers

Mysql Full Text Match Returns Bool Match but 0 Relevance

I'm having some behavior I've not experienced before with Mysql's full text indexing. The relevance for a search with cell comes back as 0 for all records. The in boolean result though verifies the term is present (and the where clause also). select…
user3783243
  • 5,368
  • 5
  • 22
  • 41
0
votes
1 answer

SQL Server Full Text Search - contains

I have a really long filename stored in the database (the file name) with the full path: C:\folder\folder\my_supper_file_name_right_here.docx If I use traditional SELECT * FROM MYTABLE WHERE Name LIKE '%file%' I will get all the results where the…
user2818430
  • 5,853
  • 21
  • 82
  • 148
0
votes
2 answers

MS SQL Contains with blank spaces between words

I have the following ms sql syntax to find all rows, which have these words: select * from Expat_MA where CONTAINS (zusammen,'"*hans*" AND "*Level 4*"'); so this is my DB column, where the search is going through: I just want the yellow marked…
user3541032
  • 127
  • 1
  • 1
  • 11
1 2 3
…
37 38