SOLR DIH importing MySQL "text" column as a BLOB

[Kaushik Chakraborty]

I've a column for posts in MySQL of type `text`, I've tried corresponding
`field-type` for it in Solr `schema.xml` e.g. `string, text, text-ws`. But
whenever I'm importing it using the DIH, it's getting imported as a BLOB
object. I checked, this thing is happening only for columns of type `text`
and not for `varchar`(they are getting indexed as string). Hence, the posts
field is not becoming searchable.

I found about this issue, after repeated search failures, when I did a `*:*`
query search on Solr. A sample response:

        <result name="response" numFound="223" start="0" maxScore="1.0">
        <doc>
        <float name="score">1.0</float>
        <str name="solr_post_bio">[B@10a33ce2</str>
        <date name="solr_post_created_at">2011-02-21T07:02:55Z</date>
        <str name="solr_post_email">test.acco...@gmail.com</str>
        <str name="solr_post_first_name">Test</str>
        <str name="solr_post_last_name">Account</str>
        <str name="solr_post_message">[B@2c93c4f1</str>
        <str name="solr_post_status_message_id">1</str>
        </doc>

The `data-config.xml` :

        <document>
     <entity name="posts" dataSource="jdbc"  query="select
     p.person_id as solr_post_person_id,
     pr.first_name as solr_post_first_name,
     pr.last_name as solr_post_last_name,
     u.email as solr_post_email,
     p.message as solr_post_message,
     p.id as solr_post_status_message_id,
     p.created_at as solr_post_created_at,
     pr.bio as solr_post_bio
     from posts p,users u,profiles pr where p.person_id = u.id and
p.person_id = pr.person_id and p.type='StatusMessage'">
             <field column="solr_post_person_id" />
     <field column="solr_post_first_name"/>
     <field column="solr_post_last_name" />
     <field column="solr_post_email" />
     <field column="solr_post_message" />
     <field column="solr_post_status_message_id" />
     <field column="solr_post_created_at" />
     <field column="solr_post_bio"/>
           </entity>
      </document>

The `schema.xml` :

    <fields>
        <field name="solr_post_status_message_id" type="string"
indexed="true" stored="true" required="true" />
     <field name="solr_post_message" type="text_ws" indexed="true"
stored="true" required="true" />
     <field name="solr_post_bio" type="text" indexed="false" stored="true"
/>
     <field name="solr_post_first_name" type="string" indexed="false"
stored="true" />
     <field name="solr_post_last_name" type="string" indexed="false"
stored="true" />
     <field name="solr_post_email" type="string" indexed="false"
stored="true" />
     <field name="solr_post_created_at" type="date" indexed="false"
stored="true" />
    </fields>
    <uniqueKey>solr_post_status_message_id</uniqueKey>
    <defaultSearchField>solr_post_message</defaultSearchField>


Thanks,
Kaushik