> 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. >