The jdbc stream was removed from the standard expression library for security reasons. It is still in the jars though and can be included through a change in the solrconfig.xml.
This jira describes how to plugin an expression: https://issues.apache.org/jira/browse/SOLR-9103 The class is: org.apache.solr.client.solrj.io.stream.JDBCStream Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Sep 8, 2022 at 6:54 PM James Greene <ja...@jamesaustingreene.com> wrote: > I'm on solr 8.11.1 and trying to use the 'jdbc' streaming expression as > documented here: > https://solr.apache.org/guide/8_11/stream-source-reference.html#jdbc > > When I try to run a jdbc stream expression I get the error: > 'function 'jdbc' is unknown (not mapped to a valid TupleStream' > > Here is an example of the expression i'm trying to run: > jdbc(connection="jdbc:mysql://mariadb:3306/threatquotient2",sql="select id > from data order by id asc limit 1", sort="id asc" > driver="org.mariadb.jdbc.Driver") > > I use the mariadb jdbc driver to get data from our mariadb instance using > the data import handler so the jdbc driver should be property loaded. >
