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

Reply via email to