> What would be the right way to point out which field contains the term > searched for. I would use highlighting for all of these fields and then post process Solr response in order to check highlighting tags. But I don't have so many fields usually and don't know if it's possible to configure Solr to highlight fields using '*' as dynamic fields.
On Wed, Feb 3, 2010 at 2:43 AM, caman <aboxfortheotherst...@gmail.com> wrote: > > Thanks all. I am on track. > Another question: > What would be the right way to point out which field contains the term > searched for. > e.g. If I search for SOLR and if the term exist in field788 for a document, > how do I pinpoint that which field has the term. > I copied all the fields in field called 'body' which makes searching easier > but would be nice to show the field which has that exact term. > > thanks > > caman wrote: >> >> Hello all, >> >> hope someone can point me to right direction. I am trying to index an >> oracle warehouse table(TableA) with 850 columns. Out of the structure >> about 800 fields are CLOBs and are good candidate to enable full-text >> searching. Also have few columns which has relational link to other >> tables. I am clean on how to create a root entity and then pull data from >> other relational link as child entities. Most columns in TableA are named >> as field1,field2...field800. >> Now my question is how to organize the schema efficiently: >> First option: >> if my query is 'select * from TableA', Do I define <field name="attr1" >> column="FIELD1" /> for each of those 800 columns? Seems cumbersome. May >> be can write a script to generate XML instead of handwriting both in >> data-config.xml and schema.xml. >> OR >> Dont define any <field name="attr1" column="FIELD1" /> so that column in >> SOLR will be same as in the database table. But questions are 1)How do I >> define unique field in this scenario? 2) How to copy all the text fields >> to a common field for easy searching? >> >> Any helpful is appreciated. Please feel free to suggest any alternative >> way. >> >> Thanks >> >> >> >> >> >> > > -- > View this message in context: > http://old.nabble.com/Indexing-an-oracle-warehouse-table-tp27414263p27429352.html > Sent from the Solr - User mailing list archive at Nabble.com. > >