Thanks for your thoughts Shawn. I did notice 3.x tightened up alot and I did
account for it by making sure I had pk defined and columns explicitly
aliased with the same name (and I will make sure the bug text reflects
that).
To help others that are having the same problem, I just found a thread
describing a workaround using group_concat() in mysql and then transformer
on solr. So far this appears to work and also seems to delta around 10x
faster. The only disadvantage is that the delta index process doesn't tell
you how many rows have changed. It just says 1 row because you are hacking
deltaQuery to return a single dummy row and making deltaImportQuery take in
last_index_time and return all rows that have changed.
Quote:
The following (MySql) query concatenates 3 lang_code fields from the main
table into one field and multiple emails from a secondary table into
another field:
SELECT u.id,
u.name,
IF((u.lang_code1 IS NULL AND u.lang_code2 IS NULL AND
u.lang_code3 IS NULL), NULL,
CONVERT(CONCAT_WS('|', u.lang_code1, u.lang_code2,
u.lang_code3) USING ascii)) AS multi_lang_codes,
GROUP_CONCAT(e.email SEPARATOR '|') AS multiple_emails
FROM users_tb u
LEFT JOIN emails_tb e ON u.id = e.id
GROUP BY u.id
The entity in data-config.xml looks something like:
<entity name="my_entity"
query="call get_solr_full();"
transformer="RegexTransformer">
<field name="email" column="multiple_emails" splitBy="\|" />
<field name="lang_code" column="multiple_lang_codes"
splitBy="\|" />
</entity>
Full Thread:
https://mail-archives.apache.org/mod_mbox/lucene-solr-user/201008.mbox/%3c9f8b39cb3b7c6d4594293ea29ccf438b01702...@icq-mail.icq.il.office.aol.com%3E
So until the bug is fixed or docs are changed I hope this helps someone else
searching for this same error message.
Adam
--
View this message in context:
http://lucene.472066.n3.nabble.com/how-to-delta-index-linked-entities-in-3-5-0-tp3752455p3755453.html
Sent from the Solr - User mailing list archive at Nabble.com.
