On 17 May 2013 00:02, geeky2 <gee...@hotmail.com> wrote: [...] > i have tried setting them up as clob fields - but this is not working (see > details below) > > i have also tried treating them as plain string fields (removing the > references to clob in the DIH) - but this does not work either. > > > DIH configuration: > > > <entity transformer="TemplateTransformer,ClobTransformer" > name="core1-parts" query="select > summ.*, > 1 as item_type, > 1 as part_cnt, > '' as brand, > ... > > <field column="attr_val" name="attributes" > clob="true" /> > <field column="rsr_val" name="restrictions" clob="true" > /> [...]
This should work, provided that the SELECT statement is getting the correct columns from the database. Are you sure that the entity is enclosing the field in question? Could you share the entire DIH data configuration file? You should also try setting sourceColName for the ClobTransformer field. Have never tried ClobTransformer where the field name differs from the database column name. Please see: http://wiki.apache.org/solr/DataImportHandler#ClobTransformer I am not familiar with Informix, and the final possibility is that there is some bug with ClobTransformer in translating blobs from Informix. It should be possible to cajole the database to convert a blob into a VARCHAR, e.g., something like SELECT SUBSTR( attr_val, 0 ) Not sure if the syntax is database dependent. Regards, Gora
