Hi, Solr gurus: I am totally new to solr and hope somebody can help me on this.
I have multivalue field "channel" in my schema: <field name="channel" type="string" indexed="true" stored="true" multivalue="true"/> and the DIH config: <entity name="autocomplete" query="select * from view_autocomplete" transformer="RegexTransformer"> <field column="channel" sourceColcolumn="channels" splitBy=","/> </entity> the DIH full-import is Ok with other fields, but channel has nothing (solr query: q=*:*). If i remove <field column="channel" sourceColcolumn="channels" splitBy=","/> or make my db returns "channel" column, channel would have the correct data, i.e. "a,b,c" but problem is "a,b,c" is no more multivalue but single value. I am using postgresql 9 and the sql is pretty simple: select ..., 'a,b,c'::text AS channels from table-xxx; I did try out solr 1.4.1 and 3.1 snapshot from svn, both having the same problem. Thanks.