On 16 May 2013 16:24, Rohan Thakur <rohan.i...@gmail.com> wrote: > hi > > I got the problem it is with the unique key defined in the schema.xml > if i difine it to be query_id then while indexing it says > missing mandatory key query_id which is not present in the root > entity(data-config.xml) which is indexing the product from the database > which has product_id as the unique key and when in schema I set product_id > as the unique key then it says missing mandatory key product_id which is > not present in the root entity(data-config.xml) which is indiexing the user > query from another table in the database which has user_id as the unique > key. > > how can I fix this thanks I want to index both the tables which are > basically unrelated that is does not have any *Common* fields.... [...]
Fix it in the SELECT statement: SELECT product_id as id,... for one entity, and SELECT query_id as id,... in the other and use id as the uniqueKey for Solr. Regards, Gora
