solrj - How to decide the dynamic filed in solr using data type and without any suffix or prefix

Question

I am indexing the RDBMS data into solr from my java application. For each row of a table I am creating a java bean and adding to solr server.(While creating a bean which is nothing but one solr document, I am using table's column name as field name of solr doc and corresponding value as solr field's value). But we support to index data from any number of tables , where each table will have different column names and data types. To, handle this we are using dynamic fields in schema.xml as below

<dynamicField name="*" type="string" indexed="true" stored="true" multiValued="true"/>

But the problem with this configuration is all the fields type is String , but I want to use numeric types for numeric data types in RDBMS and String for Varchar data type. Please suggest me how can I achieve this. I can't use suffix or prefix to field name while creating solr doc because I want to index and retrieve the docs using field name same as column name of table.

Any suggestions are appreciated.

question from:https://stackoverflow.com/questions/66059064/how-to-decide-the-dynamic-filed-in-solr-using-data-type-and-without-any-suffix-o

Answer 1

Waitting for answers