Re: indexing unrelated tables in single core

2013-05-21 Thread Rohan Thakur
thanks gora I got that...have to change in the DB itself... On Fri, May 17, 2013 at 6:27 PM, Gora Mohanty wrote: > On 16 May 2013 19:11, Rohan Thakur wrote: > > hi Mohanty > > > > I tried what you suggested of using id as common field and changing the > SQL > > query to point to id > > and us

Re: indexing unrelated tables in single core

2013-05-17 Thread Gora Mohanty
On 16 May 2013 19:11, Rohan Thakur wrote: > hi Mohanty > > I tried what you suggested of using id as common field and changing the SQL > query to point to id > and using id as uniqueKey > it is working but now what it is doing is just keeping the id's that are > not same in both the tables and dis

Re: indexing unrelated tables in single core

2013-05-16 Thread Rohan Thakur
hi Mohanty I tried what you suggested of using id as common field and changing the SQL query to point to id and using id as uniqueKey it is working but now what it is doing is just keeping the id's that are not same in both the tables and discarding the id's that are same in both the tablesbut

Re: indexing unrelated tables in single core

2013-05-16 Thread Rohan Thakur
hi mohanty I appreciate it but dint get that can you please elaborate? my dataconfig is like: my schema is like: value_id title thanks regards Rohan On

Re: indexing unrelated tables in single core

2013-05-16 Thread Gora Mohanty
On 16 May 2013 16:24, Rohan Thakur 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 pro

Re: indexing unrelated tables in single core

2013-05-16 Thread Rohan Thakur
I mean to say that I want to index 2 tables that is using 2 root entity in data-config.xml one is product table and other is user search table these both have no foreign key and I want to index both of them as document in my solr index what should I do...its taking either one of them and rejecting

Re: indexing unrelated tables in single core

2013-05-16 Thread Rohan Thakur
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 uni

Re: indexing unrelated tables in single core

2013-05-16 Thread Michael Della Bitta
True, it's complaining that your Solr schema has a required field 'title' and your query and data import config aren't providing it. On May 16, 2013 5:51 AM, "Rohan Thakur" wrote: > its saying in the logs that missing required field title which is no where > in the database... > > > On Thu, May 1

Re: indexing unrelated tables in single core

2013-05-16 Thread Rohan Thakur
its saying in the logs that missing required field title which is no where in the database... On Thu, May 16, 2013 at 3:08 PM, Rohan Thakur wrote: > I am not able to index the fields from data base its getting failed... > > data-config.xml > > url="jdbc:mysql://localhost/t

Re: indexing unrelated tables in single core

2013-05-16 Thread Rohan Thakur
I am not able to index the fields from data base its getting failed... data-config.xml its showing all failed and 0 indexed On Wed, May 15, 2013 at 8:31 PM, Alexandre Rafalovitch wrote: > 1. Create a schema that accomodates both types of fields either using > opt

Re: indexing unrelated tables in single core

2013-05-15 Thread Alexandre Rafalovitch
1. Create a schema that accomodates both types of fields either using optional fields or dynamic fields. 2. Create some sort of differentiator key (e.g. schema), separately from id (which needs to be globally unique, so possibly schema+id) 3. Use that schema in filter queries (fq) to look only at s