Re: DIH - rdbms to index confusion
Hi, have a look at the mysql-query-log - it will tell you what queries are executed from the solr dih. so you'll see which variables are empty/not set as expected and therefore maybe missing in the result. otherwise (for the rest of the list) it would be easier to help you, when you're using real queries and not pseudo-queries :) Regards Stefan
Re: DIH - rdbms to index confusion
I have a table that contains the data values I'm wanting to return when someone makes a search. This table has, in addition to the data values, 3 id's (FKs) pointing to the data/info that I'm wanting the users to be able to search on (while also returning the data values). The general rdbms query would be something like: select f.value, g.gar_name, c.cat_name from foo f, gar g, cat c, dub d where g.id=f.gar_id and c.id=f.cat_id and d.id=f.dub_id You can put this general rdbms query as is into single DIH entity - no need to split it. You would probably want to split it if your main table has one to many relation with other tables, so you can't retrieve all the data and have single result set row per Solr document.
Re: DIH - rdbms to index confusion
I'm not understanding this response. My main table does have a one to many relationship with the other tables. What should I be anticipating/wanting for each document if I want to return to the user the values while allowing them to search on the other terms? Thanks. -- View this message in context: http://lucene.472066.n3.nabble.com/DIH-rdbms-to-index-confusion-tp2028543p2030456.html Sent from the Solr - User mailing list archive at Nabble.com.