The XML comments were not taken. This is the data-import.xml that does not work. In bold is the line uncommented.
<dataConfig> <dataSource driver="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://10.150.200.69:60000/livedb" user="property" password="property" /> <document name="articlePosting"> <entity name="articleDetails" query="select 'A' concat cast(MBFARTRFNUM as char(8)) as MBFARTUNIQUEKEY, MBFARTRFNUM, MBFARTUBIRFNUM, MBFARTCNDCATE, MBFARTCNDCITY, MBFARTLMTRFNUM, MBFARTDESC, char(date(CREATEDATE)) as CREATEDATE, time(CREATEDATE) as CREATETIME, char(date(LASTMODIDATE)) as MODIDATE, time(LASTMODIDATE) as MODITIME, MBFARTVIEWED, MBFARTSNIPPET, 2 as POPULARITYSORTCODE, 4 as RECENCYSORT, 1 as EXPERTADVICE, MBFARTTOPIC concat ' ' concat MBFARTSNIPPET concat ' ' concat MBFARTDESC concat ' ' concat ' ' concat cast(MBFARTCNDCATE as char(8)) as ADTEXT, 'Y' as EXPERTQUES, 'Y' as EXPERTANS, MBFARTTOPIC, 'A' as CONTENTTYPE from MBFARTICLE where upper(MBFARTISACTIVE) = 'Y'" deltaQuery="select 'A' concat cast(MBFARTRFNUM as char(8)) as MBFARTUNIQUEKEY, MBFARTRFNUM, MBFARTUBIRFNUM, MBFARTCNDCATE, MBFARTCNDCITY, MBFARTLMTRFNUM, MBFARTDESC, char(date(CREATEDATE)) as CREATEDATE, time(CREATEDATE) as CREATETIME, char(date(LASTMODIDATE)) as MODIDATE, time(LASTMODIDATE) as MODITIME, MBFARTVIEWED, MBFARTSNIPPET, 2 as POPULARITYSORTCODE, 4 as RECENCYSORT, 1 as EXPERTADVICE, MBFARTTOPIC concat ' ' concat MBFARTSNIPPET concat ' ' concat MBFARTDESC concat ' ' concat ' ' concat cast(MBFARTCNDCATE as char(8)) as ADTEXT, 'Y' as EXPERTQUES, 'Y' as EXPERTANS, MBFARTTOPIC, 'A' as CONTENTTYPE from MBFARTICLE where upper(MBFARTISACTIVE) = 'Y' and (CREATEDATE>='${dataimporter.last_index_time}' or LASTMODIDATE>='${dataimporter.last_index_time}')"> <field column="MBFARTUNIQUEKEY" name="ukey" /> <field column="MBFARTRFNUM" name="id" /> <field column="MBFARTUBIRFNUM" name="oid" /> <field column="MBFARTCNDCATE" name="cg" /> <field column="MBFARTCNDCITY" name="ct" /> <field column="MBFARTLMTRFNUM" name="lt" /> <field column="MBFARTDESC" name="dtldesc" /> <field column="CREATEDATE" name="ppd" /> <field column="CREATETIME" name="ppt" /> <field column="MODIDATE" name="ecd" /> <field column="MODITIME" name="tmsrt" /> <field column="MBFARTVIEWED" name="viewcount" /> <field column="MBFARTSNIPPET" name="ansdesc" /> <field column="POPULARITYSORTCODE" name="popularsort" /> <field column="RECENCYSORT" name="recencysort" /> <field column="EXPERTADVICE" name="expadvice" /> <field column="EXPERTQUES" name="expertQues" /> <field column="EXPERTANS" name="expertAns" /> <field column="MBFARTTOPIC" name="topic" /> <field column="CONTENTTYPE" name="contentType" /> <field column="ADTEXT" name="ad_text" /> <entity name="setOwnerName" query="select UBILOGIN from TPUBI where UBIRFNUM=${articleDetails.MBFARTUBIRFNUM}"> <field column="UBILOGIN" name="oname" /> </entity> <*<entity name="setCityName" query="select ${articleDetails.ADTEXT} concat ' ' concat CITYNAME as AD_TEXT from TPCITY where CITY_CNDCITY=${articleDetails.MBFARTCNDCITY} fetch first row only"> <field column="AD_TEXT" name="ad_text" /> </entity> * </entity> </document> </dataConfig> -- View this message in context: http://lucene.472066.n3.nabble.com/Not-getting-data-using-concat-in-DIH-tp3144006p3144014.html Sent from the Solr - User mailing list archive at Nabble.com.