I have 8 tables in my solr data-config files and all are joined since i need data from all of them. But out of those 8 tables i have three tables that have common fields ,which i can use to link.But the issues is that the common fields in the three table that i have are such that they are repeating values. eg:-
Now i want to join the two tables and i do that on the basis of Business_id.But since iam joining on Business_id which is a non key in second table i just write that business_id is a key(because if i cant use Search_tag_id as its not common in both tables and if i take Search_tag_id as pk and join the tables on Business_id solr gives an error during delta import "deltaQuery has no column to resolve to declared primary key"). But when i say that Business_id is pk and join tables on the basis of that it works fine and delta import works. But the issue comes when i try to change the Business_id in second table eg i want to change the Business_id of Search_tag_id 3 to 1 and i run delta import.The update adds the search tag to Business_id 1 but also doesn't remove the search tag from Business_ID 2.The value of search tags in Business_id 2 remains there ,where as it should go away if iam changing Business_id from 2 to 1.Since now Business_id is not linked to any search tag. Iam not able to figure out how to resolve this issue.This is how i write it in data-config file.
Thanks in advance iam new to solr and iam stuck on this issue. asked 05 Jul '14, 09:13 mab |
You might consider posting your question on the official Solr mailing list or asking their IRC channel. Their user community would have more info about this level of configuration and schema management. answered 05 Jul '14, 21:24 johns |