I have a multivalued integer field and a multivalued string field defined
in my schema as
<field name="community_tag_ids"
type="integer"
indexed="true"
stored="true"
multiValued="true"
omitNorms="true" />
<field name="community_tags"
type="text"
indexed="true"
termVectors="true"
stored="true"
multiValued="true"
omitNorms="true" />
The DIH entity and field defn for the same goes as
<entity name="document"
dataSource="app"
onError="skip"
transformer="RegexTransformer"
query="...">
<entity name="community_tags"
transformer="RegexTransformer"
query="SELECT
group_concat(a.id SEPARATOR ',') AS community_tag_ids,
group_concat(a.title SEPARATOR ',') AS community_tags
FROM tags a JOIN tag_dets b ON a.id = b.tag_id
WHERE b.doc_id = ${document.id}" >
<field column="community_tag_ids" name="community_tag_ids"/>
<field column="community_tags" splitBy="," />
</entity>
</entity>
The value for field community_tags comes correctly as an array of strings.
However the value of field community_tag_ids is not proper
<arr name="community_tag_ids">
<int>[B@390c0a18</int>
</arr>
I tried chaining NumberFormatTransformer with formatStyle="number" but that
throws DataImportHandlerException: Failed to apply NumberFormat on column.
Could it be due to NULL values from database or because the value is not
proper? How do we handle NULL in this case?
*Pranav Prakash*
"temet nosce"
