Please note that: Hortonworks HDP
Sandbox comes with out-of-the-box Solr service that can be easily provisioned
or enabled and used as well for this exercise through Ambari UI, instead of
installing Solr service on a standalone node.
- Create a dummy table with the
Create a new
collection by invoking the “solr create –c” command from the path
“/opt/solr/bin” as following:
portal (URL: http://[Solr-IP-Address]:8983/solr/#/), make sure that the new
collection is appeared
from the left panel of Solr home page, and
after selecting the “Oracle_table” core, select “Schema”, add the schema for
the new table created in Oracle DB.
on the right side, press “Add Field” button and make sure not to delete one
of the main “Fields”.
creating the schema fields, they should appear in the “Fields” list.
“data-config.xml” file under “/var/solr/data/Oracle_table/conf/”.
make sure of the column/field mapping between the Oracle DB table and Solr’s
Schema fields are properly configured properly.