On 2/9/2014 11:09 AM, PeriS wrote:
> I have a simple join query;
>
> <entity name=“person" query="SELECT person_id, details, last_modified FROM
> person WHERE '${dataimporter.request.clean}' != 'false' OR last_modified >
> '${dataimporter.last_index_time}'">
> <entity name="address" query="SELECT address_info FROM address
> WHERE person_id = '${person.person_id}'" />
> </entity>
>
> This doesn’t bring back the child address records. Am I missing something?
If you want to see the actual SQL that Solr sends, change the logging
level of org.apache.solr.handler.dataimport.JdbcDataSource to DEBUG,
then look in your Solr log file.
This is probably easiest to do with the Logging tab in the admin UI,
assuming you're on 4.x. Click on "Level" and look search for jdbc. You
can also find the logging config in use by your system and adjust it
there. If you are using another logging framework besides log4j, you
may need to actually set the level to FINE rather than DEBUG. If you're
on a 3.x or 1.x version of Solr, you can probably still use the admin UI
to adjust the logging level, but it won't be as easy to find as it is on
4.x.
Note that the SQL logs will NOT show up in the admin UI, you will have
to find the actual Solr log file.
Once you can see the actual SQL, you can use that information to track
down where the problem is.
Thanks,
Shawn
