mysql - Apache SOLR indexing not working after data import successfull -
i implementing solr our ecommerce search functionality , running solr.war in jboss, solr home in different directory path. have configured db-data-config.xml map mysql database
<dataconfig> <datasource type="jdbcdatasource" driver="com.mysql.jdbc.driver" url="jdbc:mysql://localhost:3306/employees" user="root" password="admin" /> <document name="ecomm"> <entity name="employees" query="select emp_no, first_name, last_name employees limit 2000"> <field name="emp_no" column="emp_no" /> <field name="first_name" column="first_name" /> <field name="last_name" column="last_name" /> </entity> </document> </dataconfig>
when full-import , 2000 records getting imported , not getting indexed. when query
requests: 1 (1/s), fetched: 2,000 (2,000/s), skipped: 0, processed: 0 (0/s) http://localhost:8080/solr/employees/select?q=*%3a*&wt=json&indent=true { "responseheader":{ "status":0, "qtime":1, "params":{ "indent":"true", "q":"*:*", "wt":"json"}}, "response":{"numfound":0,"start":0,"docs":[] }}
where when tweak query , , add alias "id", id getting processed
, ie indexed
requests: 1, fetched: 2,000, skipped: 0, processed: 2,000 query="select emp_no 'id', first_name , last_name employees limit 2000"
and getting 'id' data while quering.
"response": { "numfound": 2000, "start": 0, "docs": [ { "id": "10001", "_version_": 1501167564520161300 },
edit :- adding database schema screenshot
Comments
Post a Comment