Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
1 answer

How to join between separate lucene indexed files

Our application support the View model, as you know, each View has its own query to filter the data that should appear in this View from DB. And Our business require us to create a separate lucene index directory for each table in the DB. Now am…
Salah
  • 8,567
  • 3
  • 26
  • 43
0
votes
1 answer

SETPARENT FAILED FOR FULLTEXTINDEXCOLUMN

Using SQL Server 2005 Enterprise. I'm trying to add columns to a full-text index created on an indexed view with schemabinding. Here's the full error message: Cannot execute changes SetParent failed For FullTextIndexColumn 'geo'…
user1541301
  • 325
  • 1
  • 4
  • 14
0
votes
1 answer

Spring Data Neo4j - Fulltext Index in Cypher query

I access fulltext index by the findAllByQuery() repository method, it works fine, but i cannot pass pagination params, so i'm trying Cypher query which can use LIMIT, below are my testings: Case 1 - Works fine but hardcoding @Query( "START…
gozizibj
  • 285
  • 1
  • 5
  • 23
0
votes
2 answers

Word lists for a lot of articles - document-term matrix

I have nearly 150k articles in Turkish. I will use articles for natural language processing research. I want to store words and frequency of them per article after processing articles. I'm storing them in RDBS now. I have 3 tables: Articles ->…
mumino
  • 2,119
  • 1
  • 15
  • 8
0
votes
1 answer

Full Text search and Subqueries in the FROM Clause

When i try the following query: select co_id, Match(co_title,co_description,co_text) AGAINST ('word') from (select * from content limit 100)co the result is: #1191 -Can't find FULLTEXT index matching the column list FULLTEXT indexes are set…
john
  • 1,282
  • 1
  • 17
  • 30
0
votes
1 answer

Develop a distributed Full-Text search Index (AKA Inverted index)

I know how to develop a simple inverted index on a single machine. In short it is a standard hash table kept in-memory where: - key - a word - value - a List of word locations As an example, the code is here:…
Ivan Voroshilin
  • 5,233
  • 3
  • 32
  • 61
0
votes
0 answers

Generating logic terms on tokenization with elasticsearch

I would like to split the following record (the line of keywords is in one column of a database table) into logical terms for building a facet search: Ballett, Fernsehen, Film, Sachbücher/Musik, Film, Theater/Theater, Ballett/Allgemeines,…
Stefan
  • 359
  • 3
  • 17
0
votes
0 answers

MYSQL Routine with fulltext search on temp table. Performance Issues

I have a table Called "Item" that is INNODB and has the following layout: ID DESCRIPTION ->fulltext index. DATE The Fulltext Index is set to index words that are 1 character, unfortunately I can't get around this requirement. The following Routine…
mscard02
  • 315
  • 4
  • 15
0
votes
1 answer

How Can I view MySql Fulltext Indexes?

Does MySql Fulltext search use indexing? If so, how can I view the Index entries table? I can view the Index Statistics with VIEW query. But, I just wanted to view the index record entries table.
Ei Maung
  • 7,013
  • 5
  • 23
  • 23
0
votes
1 answer

MySQL Full Text Search Returning 0 Results

I have just set up a full text index on my MySQL database, but unfortunately it's not returning any results. This seems to be a common issue, and the typical answers are use the MyISAM engine, and the 'IN BOOLEAN MODE' function. Well neither of…
PizzaTheHut
  • 637
  • 2
  • 6
  • 20
0
votes
1 answer

Cannot find my search "iso" in a word "TESTISOTEST" by using FREETEXTTABLE

First, i'm starting to implement a fulltext search on a table of 12 millions of rows. So maybe I have not yet understood all of its intricacies. :) All those 12 millions of rows seem to indexed correctly and my index is correctly created with 1036…
Sébastien.B
  • 31
  • 3
0
votes
0 answers

Mysql key_buffer_size already 16GB but some fulltext searches are still slow

I have a query w/ full text search which takes 5 - 10 secs. key_buffer_size is already 16GB. Table has 15 million records and has a compound fulltext index on fields: categories and company. Table Size:Data Length - 0.9GBIndex Length - 1.1GB …
john
  • 93
  • 9
0
votes
1 answer

Using Full Text Indexing

I've a question about the best way to get product data searching by name. Which one is better way to do that? SELECT * FROM Products WHERE ProductName = 'Samsung Note 2' Creating a full text index for ProductName and get matching products that…
Saygın Karahan
  • 167
  • 1
  • 9
0
votes
2 answers

Where is the fulltext search data in sql server?

I create a fulltext index on a table,I want to have a look at the fulltext data after the population.Is there a file contains fulltext index information? Where is it? Anybody has an idea?
Jane Hsiun
  • 46
  • 6
0
votes
1 answer

Solr - Is there a way to speed up my import

I have a relational database model This is the basics of my data-config.xml
Bick
  • 17,833
  • 52
  • 146
  • 251
1 2 3
…
37 38