Ananda Verma created SOLR-6094: ---------------------------------- Summary: DIH deletedPkQuery doesn't allows placeholders in query Key: SOLR-6094 URL: https://issues.apache.org/jira/browse/SOLR-6094 Project: Solr Issue Type: Bug Components: contrib - DataImportHandler Affects Versions: 4.3.1 Reporter: Ananda Verma Priority: Blocker Fix For: 4.7.3
When using following deletedPkQuery in data-config.xml {code}deletedPkQuery="SELECT id from ${schema.SCHEMA_NAME}.deleted_users where status = 'ACTIVE'"{code} It throws following error {code}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) {code} whereas running {code}deletedPkQuery="SELECT id from schema2.deleted_users where status = 'ACTIVE'"{code} works well -- This message was sent by Atlassian JIRA (v6.2#6252) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org