Where did cachePrimaryKey comes from? The documentation has cacheKey :
https://cwiki.apache.org/confluence/display/solr/Uploading+Structured+Data+Store+Data+with+the+Data+Import+Handler
Regards,
Alex.
----
Newsletter and resources for Solr beginners and intermediates:
http://www.solr-start.com/
On 5 February 2016 at 02:53, Kevin Colgan <kcol...@yahoo.com.invalid> wrote:
> Hi everyone,
>
> Is it possible to use SqlEntityProcessor in cached mode to repeat a query for
> a nested child element? I'd like to use the entity query once to consolidate
> information from the children to the parent, then another to actually index
> the entities as children.
>
> Here's an example of what I'm trying to do in the db-config file. The
> EventsTransformer consolidates information from child events and adds fields
> to the parent row. I had to add the two entities as the EventsTransformer
> will only add fields to the parent if child=false:
>
> This is NOT working - the child event entities aren't being created
> <entity autoCommit="false" rootEntity="true" encoding="UTF-8" name="houses"
> query="select <parent fields> from houses">
> <entity
> transformer="EventsTransformer"
> name="events"
> query="select '${houses.uid}_events_' || e_id::text AS uuid,<event
> fields> from events">
> <entity
> child=true
> processor="SqlEntityProcessor" cachePrimaryKey="events_e_id"
> cacheLookup="events_parsed.events_e_id" cacheImpl="SortedMapBackedCache"
> name="events"
> query="select <event fields> from events">
> </entity>
>
> This is IS working but the events query is being run twice so indexing is
> twice as slow
>
> <entity autoCommit="false" rootEntity="true" encoding="UTF-8" name="houses"
> query="select <parent fields> from houses">
> <entity
> transformer="EventsTransformer"
> name="events_parsed"
> query="select '${houses.uid}_events_' || e_id::text AS uuid,
> e_id::text AS events_e_id,<event fields> from events">
> <entity
> child=true
> processor="SqlEntityProcessor" cachePrimaryKey="events_e_id"
> cacheLookup="events_parsed.events_e_id" cacheImpl="SortedMapBackedCache"
> transformer="EventsTransformer"
> name="events_child"
> query="select <event fields> from events">
> </entity>
>
> Anyone got any idea how to do this? I've already tried nesting the second
> child entity inside the other but this didn't work.
> Thanks,Kevin
