You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Noble Paul (JIRA)" <ji...@apache.org> on 2014/09/01 22:56:21 UTC
[jira] [Resolved] (SOLR-6094) DIH deletedPkQuery doesn't allows
placeholders in query
[ https://issues.apache.org/jira/browse/SOLR-6094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Noble Paul resolved SOLR-6094.
------------------------------
Resolution: Won't Fix
We never supported a variable called ${schema} in DIH . If you want it to be available open a separate icket saying "schema should be exposed via DIH VariableResolver"
> 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: Minor
> Labels: DIH, dataimportHandler, dih
> 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.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org