1) If I change one field's type in my schema, will that cause problems with the index or searching? My data is pulled in chunks off of a mysql server so one field in the currently indexed data is simply an "int" type field in solr. I would like to change this to a string moving forward, but still expect to search across the int/string field. Will this be ok?
2) My motivation for #1 is that I have thousands of records that are exactly the same in mysql aside from a user_id column. Prior to inserting into mysql I am thinking that I can concatenate the user_ids together into a space separated string and let solr just parse the string. So the database and my data import handler would change a bit. 3) If #2 is an appropriate approach, will a solr.TextField with a solr.WhitespaceTokenizerFactory be an ok way to approach this? This does produce words where I would expect integers. I tried using a solr.TrieIntField with the solr.WhitespaceTokenizerFactory, but it throws an error. Finally I need to make sure that exact matches will be performed on user_ids in the string when searching. Much appreciated!
