StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to use the Solr Data Import Handler to index a MySQL table?
primarykey
Id
10343756
data
AcceptedAnswerId
0
AnswerCount
5
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2012-04-27T01:49:32.183
FavoriteCount
2
LastActivityDate
2016-05-10T11:36:03.660
LastEditDate
2016-05-10T11:36:03.660
LastEditorUserId
437763
OwnerUserId
967451
ParentId
0
PostTypeId
1
Score
2
ViewCount
12738
LastEditorDisplayName
text
Body
When I try to import a mysql table by loading this in the browser: <pre><code>http://192.168.136.129:8983/solr/dataimport?command=full-import </code></pre> I get this error: <pre><code>HTTP ERROR 404 Problem accessing /solr/dataimport. Reason: NOT_FOUND Powered by Jetty:// </code></pre> I'm following this tutorial from the official Solr wiki to get started with the DIH: <a href="http://wiki.apache.org/solr/DIHQuickStart" rel="nofollow">http://wiki.apache.org/solr/DIHQuickStart</a> As per the tutorial I added this to my solrconfig.xml: <pre><code><requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"> <lst name="defaults"> <str name="config">data-config.xml</str> </lst> </requestHandler> </code></pre> in data-config.xml I have the following: <pre><code><dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/site" user="root" password="123"/> <document> <entity name="profiles" query="select user_id,about,music,movies,occupation from profiles"> </entity> </document> </dataConfig> </code></pre> And these are the fields defined in my schema.xml: <pre><code> <fields> <field name="user_id" type="string" indexed="true" stored="true" required="true" /> <field name="about" type="string" indexed="true" stored="true" /> <field name="music" type="string" indexed="true" stored="true" /> <field name="movies" type="string" indexed="true" stored="true" /> <field name="occupation" type="string" indexed="true" stored="true" /> <field name="text" type="text_general" indexed="true" stored="false" multiValued="true"/> </fields> <uniqueKey>user_id</uniqueKey> </code></pre> So what am I doing wrong? I imagine it may have something to do with the data-config.xml file. In it I don't know if a certain path to the MySQL driver is being assumed. I downloaded the MySQL JDBC driver from here: <a href="http://dev.mysql.com/downloads/connector/j/3.1.html" rel="nofollow">http://dev.mysql.com/downloads/connector/j/3.1.html</a> and put it in my <code>/solr/lib</code> directory. When I downloaded the driver and extracted it there was a bunch of folders inside one folder called "mysql-connector-java-3.0.17-ga". I do notice that inside that there is a dir called: <code>com</code> and inside that <code>mysql</code> and inside that <code>jbdc</code> and inside that there is a file called <code>Driver.class</code>. Is this what is being referenced from data-config.xml? If so why isn't the initial directory not mentioned. Basically I have no idea what the issue is, can someone help please.
Tags
<mysql><solr><lucene><dataimporthandler>
Title
How to use the Solr Data Import Handler to index a MySQL table?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USluchaninov
UserOwnerUserId
1. USTK123
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POHow to use the Solr Data Import Handler to index a MySQL table?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POHow to use the Solr Data Import Handler to index a MySQL table?
 UserUserId
 USiamsyt
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.