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.

Reply via email to