Thanks. I will give this a shot. Alexey-34 wrote: > >> 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. >> >> > >
-- View this message in context: http://old.nabble.com/Indexing-an-oracle-warehouse-table-tp27414263p27439611.html Sent from the Solr - User mailing list archive at Nabble.com.
