That is exactly what my problem is.:handshake:
Thanks for you reply.
But I tried your suggestion:
Updated the data-config.xml as;
<entity name="user" query="select 'user' as rowtype, * from USER"></entity>
<entity name="manager" query="select 'manager' as rowtype, * from
MANAGERS"></entity>
But when I perform the full import itself, it is throwing exception,
SEVERE: Exception while processing: user document : SolrInputDocumnt[{}]
org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute
query: select 'user' as rowtype,* from USER Processing Document # 1
.......
So, as expected, when I go to search it is giving- undefined field rowtype-
error.!!!
Do I need to update any other files or fields?
I am happy that it worked for you...:jumping::jumping:
Looking forward for your reply
Thanks
con
Neville Burnell wrote:
>
> Hi,
>
>> But while performing a search, if I want to search only the data from
>> USER table, how can I acheive it.
>
> In my app+solr index, we solved this problem by "tagging" entities with a
> "rowtype" attribute, something like this:
>
> <entity name="user" query="select 'user' as rowtype, * from
> USER"></entity>
> <entity name="manager" query="select 'manager' as rowtype, * from
> MANAGERS"></entity>
>
> Then your 'users' only query becomes something like:
>
> http://localhost:8983/solr/select/?q=(bob AND
> rowtype:user)&version=2.2&start=0&rows=10&indent=on&wt=json
>
> Hope this helps
>
>
>
>> -----Original Message-----
>> From: con [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, 1 October 2008 4:54 PM
>> To: solr-user@lucene.apache.org
>> Subject: Re: How to select one entity at a time?
>>
>>
>> Of course I agree.
>> But while performing a search, if I want to search only the data from
>> USER
>> table, how can I acheive it.
>>
>> Suppose I have a user name bob in both USER and MANAGER tables. So when
>> I
>> perform http://localhost:8983/solr/dataimport?command=full-import , all
>> the
>> USER and MANAGER values will get indexed.
>> And when i do a search like,
>> http://localhost:8983/solr/select/?q=bob&version=2.2&start=0&rows=10&in
>> dent=on&wt=json
>> it will return all the values indexed from both USER and MANAGER table.
>> But I want only the data indexed from either USER table or MANAGER
>> table at
>> a time based on the end user's choice. How can I achieve it.
>>
>> Thanks for your reply
>> con
>>
>>
>> Noble Paul നോബിള് नोब्ळ् wrote:
>> >
>> > The entity and the select query has no relationship
>> > The entity comes into picture when you do a dataimport
>> >
>> > eg:
>> > http://localhost:8983/solr/dataimport?command=full-import&enity=user
>> >
>> > This is an indexing operation
>> >
>> > On Wed, Oct 1, 2008 at 11:26 AM, con <[EMAIL PROTECTED]> wrote:
>> >>
>> >> Hi guys,
>> >> In the URL, http://localhost:8983/solr/select/?q=
>> >> XXXX:bob&version=2.2&start=0&rows=10&indent=on&wt=json
>> >>
>> >> q=XXXX: applies to a field and not to an entity. So If I have 3
>> entities
>> >> like:
>> >>
>> >> <dataConfig>
>> >> <dataSource **********/>
>> >> <document>
>> >> <entity name="user" query="select * from
>> USER">
>> >> </entity>
>> >>
>> >> <entity name="manager" query="select * from
>> >> MANAGERS">
>> >> </entity>
>> >>
>> >> <entity name="both" query="select * from
>> >> MANAGERS,USER where MANAGERS.userID= USER .userID">
>> >> </entity>
>> >> </document>
>> >> </dataConfig>
>> >>
>> >> I cannot invoke the entity, 'user', just like the above url. i went
>> >> through
>> >> the possible arguments but didnt found a way to invoke an entity. Is
>> >> there a
>> >> way for this purpose.
>> >> ragards
>> >> con
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> con wrote:
>> >>>
>> >>> Thanks Everybody.
>> >>> I have went through the wiki and some other docs. Actually I have a
>> >>> tight
>> >>> schedule and I have to look into various other things along with
>> this.
>> >>> Currently I am looking into rebuilding solr by writing a wrapper
>> class.
>> >>> I will update you with more meaningful questions soon..
>> >>> thanks and regards.
>> >>> con
>> >>>
>> >>>
>> >>> Norberto Meijome-6 wrote:
>> >>>>
>> >>>> On Fri, 26 Sep 2008 02:35:18 -0700 (PDT)
>> >>>> con <[EMAIL PROTECTED]> wrote:
>> >>>>
>> >>>>> What you meant is correct only. Please excuse for that I am new
>> to
>> >>>>> solr.
>> >>>>> :-(
>> >>>>
>> >>>> Con, have a read here :
>> >>>>
>> >>>> http://www.ibm.com/developerworks/java/library/j-solr1/
>> >>>>
>> >>>> it helped me pick up the basics a while back. it refers to 1.2,
>> but the
>> >>>> core concepts are relevant to 1.3 too.
>> >>>>
>> >>>> b
>> >>>> _________________________
>> >>>> {Beto|Norberto|Numard} Meijome
>> >>>>
>> >>>> Hildebrant's Principle:
>> >>>> If you don't know where you are going,
>> >>>> any road will get you there.
>> >>>>
>> >>>> I speak for myself, not my employer. Contents may be hot. Slippery
>> when
>> >>>> wet. Reading disclaimers makes you go blind. Writing them is
>> worse. You
>> >>>> have been Warned.
>> >>>>
>> >>>>
>> >>>
>> >>>
>> >>
>> >> --
>> >> View this message in context:
>> >> http://www.nabble.com/How-to-select-one-entity-at-a-time--
>> tp19668759p19754869.html
>> >> Sent from the Solr - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >
>> >
>> >
>> > --
>> > --Noble Paul
>> >
>> >
>>
>> --
>> View this message in context: http://www.nabble.com/How-to-select-one-
>> entity-at-a-time--tp19668759p19755437.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
>
--
View this message in context:
http://www.nabble.com/How-to-select-one-entity-at-a-time--tp19668759p19755987.html
Sent from the Solr - User mailing list archive at Nabble.com.
