Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
1 answer

Two Applications using the same index file with Hibernate Search

I want to know if it is possible to use the same index file for an entity in two applications. Let me be more specific: We have an online Application with a frondend for the users and an application for the backend tasks (= administrator interface).…
Dominik Obermaier
  • 5,610
  • 4
  • 34
  • 45
0
votes
1 answer

Containstable query acting up when searching for values with ' n '

I'm fairly new to full text indexing, my query works as expected, until I search using a phrase containing ' n '. Example: SELECT C.name FROM dbo.Clients AS C INNER JOIN CONTAINSTABLE (dbo.Clients, name, '"Brick n Clay*"') AS…
Matthys Du Toit
  • 2,168
  • 3
  • 21
  • 34
0
votes
0 answers

Find same products named differently in different tables that do not have a common unique property

I have two tables with products. Each table has same products but named a little different or completely different, eg. ("Broadband Services" vs "High Speed Internet"). As you can see the product is the same, but names are different. Ideally I…
Data Engineer
  • 795
  • 16
  • 41
0
votes
1 answer

Migrating a core from Solr 4.6 to Solr 4.10, without reindexing

I have Solr 4.6 installed on my machines, and have multiple cores each of size more than 500G's. The problem with solr 4.6 is that the sharding is very unstable. So I want to migrate my cores from solr 4.6 to solr 4.10 without providing any downtime…
Satyam
  • 1
  • 1
0
votes
1 answer

Determine if full text index population is paused

I am looking for a way to call the following only if the fulltext index status is paused but I can't seem to find the query I need to get the population status of a specific table ALTER FULLTEXT INDEX ON dbo.my_table RESUME POPULATION I have…
Seph
  • 8,472
  • 10
  • 63
  • 94
0
votes
1 answer

Lucene.Net manual query not returning expected results

I am creating a booleanquery in Lucene.net in order to search multiple fields for multiple values. Running the below constructed query (returns +CustomerId:5) will bring back results. var booleanQuery = new BooleanQuery(); Query query =…
Adamon
  • 484
  • 9
  • 21
0
votes
1 answer

How to search a particular string in table without mentioning the column name in which that string belong in mysql

I want to search a string 'Trevor DSouza' in table without mentioning the column name which this string belongs. This string might me stored in different different column.so for search this string I wrote my query like:- SELECT * FROM claim_master…
shyarry g
  • 345
  • 1
  • 3
  • 8
0
votes
0 answers

Lucene Error Due to increase in field size with the following code

Hello I am working on Lucene to index my database records but I am unable to solve this error. Error: java.lang.IllegalArgumentException: Document contains at least one immense term in field="contentSum_DES" (whose UTF8 encoding is longer than…
gupta k
  • 23
  • 1
  • 9
0
votes
1 answer

How to properly warm a MySQL FULLTEXT index?

I've got MySQL V5.6.23 running on Amazon RDS. In it is an InnoDB table called product_details that contains about 10 columns that are all indexed for exact matches (dates, numbers, text, etc.). I then have a single product_name field that I've put a…
T. Brian Jones
  • 13,002
  • 25
  • 78
  • 117
0
votes
2 answers

Getting Count(*) vs Actual Data has performance implications

I can't make sense of the following two queries. First one only gets the count of the entire resultset. Second one gets the actual data , but limit the resultset to 10 rows. Somehow the first one can't use index. I have tried to use USE INDEX…
Scalable
  • 1,550
  • 4
  • 16
  • 29
0
votes
1 answer

How can I get count of occurrence of a word by Hibernate Search?

For example, there is a word "apple", I want to know no of times it has occurred in different rows. Thanks! EDIT I have a database that contains textual data of what people are talking about. For example: People1 : I like apple. People2 : I like…
Amit Kumar
  • 2,685
  • 2
  • 37
  • 72
0
votes
1 answer

Optimizing fulltext search across multiple tables

I want to search the requested term ($q) in my content table on the title & the keywords but also for the models, which are in another table and linked by a table in between. Also, I need to get the number of views in another table. This is the…
Dacramash
  • 111
  • 1
  • 11
0
votes
1 answer

Fulltext Indexing on MyISAM, single column vs multiple column indexing

I have an extremely large table (4M+ rows) with disk space of more than 40Gb (14Gb data and 28Gb index). I needed fulltext search on multiple fields both combined and separated, meaning that I needed to make it possible to fulltext search on both…
SAVAFA
  • 818
  • 8
  • 23
0
votes
1 answer

oracle, MULTI_COLUMN_DATASTORE, doesn't use index for consecutive columns

i have a table with 2 columns, Name and UniqueName. I created Multi_column_datastore: SQL> begin 2 ctx_ddl.create_preference('my_multi', 'MULTI_COLUMN_DATASTORE'); 3 ctx_ddl.set_attribute('my_multi', 'columns', 'Name,UniqueName'); 4 end; …
Bhaskar Na
  • 1
  • 6
0
votes
0 answers

SetSortMode(SPH_SORT_ATTR_DESC,"score") in Sphinx does not work

I try to sort the results of Sphinx Search by using SetSortMode(SPH_SORT_ATTR_DESC,"score") but it does not work (results are not sorted in descending order by "score" attribute). My PHP code: $sphinx = new…
ghani
  • 1
  • 1
1 2 3
…
37 38