Apache Solr & schema.xml

Question

I have just began with Apache Solr 4.1 yesterday and though I have managed to get our MySQL data imported successfully in Solr, I am unable to view any data using queries. I suspect the problem is in schema.xml changes (data-config.xml is correct). Here are my questions -

• Do I need to add all DB fields in the schema.xml? My table has 275+ fields, and configuring all of them would be a task. I am hoping there is a way to auto-configure these fields.
• Is there a way to use separate schema.xml for my requirement? Where and how do I configure this? I don't want to modify the example-DIH's sample schema.xml

Any pointers here would be highly appreciated! I have already gone through this document - http://wiki.apache.org/solr/DataImportHandler

and I have also read few question posted here, but couldn't find answer to my queries.

Answer 1

1) All the fields that you are mentioning in data-config.xml as field column must add them to schema.xml. No auto-configure is available.
2) No we cannot use separate schema.xml.

Could you please show some of your indexed field that you have mentioned in schema.xml