FAQ Database Discussion Community


How to run a sql query in solr

php,sql,search,solr5
Ok now I have successfully install solr and index by database with following structure : DB_NAME - solr, Table - users my db-data-config.xml file : <dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/solr" user="root" password="" /> <document> <entity name="users" query="select id,name from users;" /> <field column="ID" name="id" /> <field column="NAME" name="name" /> </document>...

Handle multiple tables of MySQL in with Solr 5.1.0?

java,php,schema,solrcloud,solr5
I have more than 30 tables in my MySQL database. Recently I have import data from my 1 table to Solr 5.1.0 using DataImporthandler and in my data-config.xml file, fire query of, select * from table-name But in my search I have to integrate more than 10 tables to give...

Solr: Retrieve non-stored fields from external data source

solr,solr5,banana
I'm currently working on a project on which I would like to index several data sources (Oracle and HBase) into Solr for full text search. Additionally, I want to be able to visualize the data I index into Solr. I'm still evaluating on whether to use Banana or Hue for...

Subentity SolrEntityProcessor stops working since SolR 5.x

solr,dataimporthandler,solr5
I use a data import like this <dataConfig> <document name="products"> <entity name="outer" dataSource="my_datasource" pk="id" query="..." deltaQuery="..." deltaImportQuery="..." > <entity name="solr" processor="SolrEntityProcessor" url="http://127.0.0.1:8983/solr/${solr.core.name}" query="Xid:${outer.Xid}" rows="1" fl="Id,FieldA,FieldB" wt="javabin" /> </entity> </document> </dataConfig> The interesting part is the sub entity, which uses SolrEntityProcessor. Until (including) SoLR 4.10 everything...