[SOLR-6094] DIH deletedPkQuery doesn't allows placeholders in query

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 4.3.1
• Fix Version/s: 4.7.3
• Component/s: contrib - DataImportHandler
• Labels: DIH dataimportHandler dih
• Assignee: Unassigned
• Reporter: Ananda Verma
• Created: 20/May/14 07:10
• Updated: 01/Sep/14 20:55
• Resolved: 01/Sep/14 20:55

Description

When using following deletedPkQuery in data-config.xml

deletedPkQuery="SELECT id from ${schema.SCHEMA_NAME}.deleted_users where status = 'ACTIVE'"

It throws following error

20-May-2014 12:35:52 ERROR [org.apache.solr.handler.dataimport.DataImporter.doDeltaImport : 455] :: http-bio-8380-exec-6 :: Delta Import Failed
java.lang.AssertionError: Non-leaf nodes should be of type java.util.Map
	at org.apache.solr.handler.dataimport.VariableResolver.currentLevelMap(VariableResolver.java:235)
	at org.apache.solr.handler.dataimport.VariableResolver.resolve(VariableResolver.java:94)
	at org.apache.solr.handler.dataimport.VariableResolver.replaceTokens(VariableResolver.java:155)
	at org.apache.solr.handler.dataimport.ContextImpl.replaceTokens(ContextImpl.java:254)
	at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextModifiedRowKey(SqlEntityProcessor.java:84)
	at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextModifiedRowKey(EntityProcessorWrapper.java:267)
	at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:776)
	at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:764)
	at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:334)
	at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:219)
	at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:451)
	at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:489)
	at org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:179)
	at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135)
	at org.apache.solr.core.SolrCore.execute(SolrCore.java:1820)
	at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:656)
	at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:359)
	at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:155)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:219)
	at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

whereas running

deletedPkQuery="SELECT id from schema2.deleted_users where status = 'ACTIVE'"

works well