Alexey, This is exactly what I was looking for. Thank you thank you thank you ...... Should have read the documentation a little better. Much appreciated.
Alexey-34 wrote: > >> Dont define any <field name="attr1" column="FIELD1" /> so that column in >> SOLR will be same as in the database table. > Correct > You can define dynamic field <dynamicField name="field*" type="text" > indexed="true" stored="true"/> ( see > http://wiki.apache.org/solr/SchemaXml#Dynamic_fields ) > >> 1)How do I define unique field in this scenario? > You can create primary key into database or generate it directly in > Solr ( see "UUID techniques" http://wiki.apache.org/solr/UniqueKey ) > >> 2) How to copy all the text fields to a common field for easy searching? > <copyField source="field*" dest="field"/> ( see > http://wiki.apache.org/solr/SchemaXml#Copy_Fields ) > > > On Tue, Feb 2, 2010 at 4:22 AM, caman <aboxfortheotherst...@gmail.com> > 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-a-oracle-warehouse-table-tp27414263p27414263.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-tp27414263p27426206.html Sent from the Solr - User mailing list archive at Nabble.com.