You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by radha c <ra...@gmail.com> on 2009/03/22 16:46:24 UTC
could not search the indexed table data
Hi,
I am just in learning face. I indexed a sql test table using dataimport.
But I want to search those index by keyword. I tried to search like
http://localhost:8080/solr/select/?q=Peter. But I got zero respone.
Can anyone help me please why is this?
Thanks in advance.
Re: could not search the indexed table data
Posted by radha c <ra...@gmail.com>.
Oops.. Thanks a lot. I got a bit tired :-)
Thanks
2009/3/22 Noble Paul നോബിള് नोब्ळ् <no...@gmail.com>
> there is a typo in the column value
>
> <field column="fisrtname" name="fname" />
>
> the schema does not say whether fname goes into a default search field
>
>
> On Sun, Mar 22, 2009 at 11:10 PM, radha c <ra...@gmail.com> wrote:
> > Thanks for your reply,
> > Yes, I have tabel persons and "Peter" value in column firstname . and
> here
> > is my data-config.xml
> > <dataConfig>
> > <dataSource ....>
> > <entity name="persons" pk="person_id" query="select
> > personid,firstname from persons" >
> > <field column="personid" name="person_id" />
> > <field column="fisrtname" name="fname" />
> > </entity>
> > </document>
> > </dataConfig>
> >
> > and my schema.xml
> > <schema name="example">
> > <types>
> > <fieldType name="text" class="solr.TextField"
> > positionIncrementGap="100"/>
> > <fieldType name="integer" class="solr.IntField" omitNorms="true"/>
> > </types>
> > <fields>
> > <field name="person_id" type="integer" indexed="true" stored="true"
> > multivalued="false" required="true"/>
> > <field name="fname" type="text" indexed="true" stored="true"
> > multivalued="false"/>
> > </fields>
> > <uniqueKey>person_id</uniqueKey>
> > <solrQueryParser defaultOperator="OR"/>
> > </schema>
> > It is indexed properly. But I am not getting any result. Do I need to do
> > explicit commit?
> > Or Am I quering correctly http://localhost:8080/solr/select/?q=Peter ?
> >
> >
> >
> > 2009/3/22 Noble Paul നോബിള് नोब्ळ् <no...@gmail.com>
> >
> >> it is hard to say the reason.
> >> do you have the field containing "Peter" in the default search field?
> >> what is the type of the field?
> >>
> >> On Sun, Mar 22, 2009 at 9:16 PM, radha c <ra...@gmail.com> wrote:
> >> > Hi,
> >> > I am just in learning face. I indexed a sql test table using
> dataimport.
> >> > But I want to search those index by keyword. I tried to search like
> >> > http://localhost:8080/solr/select/?q=Peter. But I got zero respone.
> >> > Can anyone help me please why is this?
> >> > Thanks in advance.
> >> >
> >>
> >>
> >>
> >> --
> >> --Noble Paul
> >>
> >
>
>
>
> --
> --Noble Paul
>
Re: could not search the indexed table data
Posted by Noble Paul നോബിള് नोब्ळ् <no...@gmail.com>.
there is a typo in the column value
<field column="fisrtname" name="fname" />
the schema does not say whether fname goes into a default search field
On Sun, Mar 22, 2009 at 11:10 PM, radha c <ra...@gmail.com> wrote:
> Thanks for your reply,
> Yes, I have tabel persons and "Peter" value in column firstname . and here
> is my data-config.xml
> <dataConfig>
> <dataSource ....>
> <entity name="persons" pk="person_id" query="select
> personid,firstname from persons" >
> <field column="personid" name="person_id" />
> <field column="fisrtname" name="fname" />
> </entity>
> </document>
> </dataConfig>
>
> and my schema.xml
> <schema name="example">
> <types>
> <fieldType name="text" class="solr.TextField"
> positionIncrementGap="100"/>
> <fieldType name="integer" class="solr.IntField" omitNorms="true"/>
> </types>
> <fields>
> <field name="person_id" type="integer" indexed="true" stored="true"
> multivalued="false" required="true"/>
> <field name="fname" type="text" indexed="true" stored="true"
> multivalued="false"/>
> </fields>
> <uniqueKey>person_id</uniqueKey>
> <solrQueryParser defaultOperator="OR"/>
> </schema>
> It is indexed properly. But I am not getting any result. Do I need to do
> explicit commit?
> Or Am I quering correctly http://localhost:8080/solr/select/?q=Peter ?
>
>
>
> 2009/3/22 Noble Paul നോബിള് नोब्ळ् <no...@gmail.com>
>
>> it is hard to say the reason.
>> do you have the field containing "Peter" in the default search field?
>> what is the type of the field?
>>
>> On Sun, Mar 22, 2009 at 9:16 PM, radha c <ra...@gmail.com> wrote:
>> > Hi,
>> > I am just in learning face. I indexed a sql test table using dataimport.
>> > But I want to search those index by keyword. I tried to search like
>> > http://localhost:8080/solr/select/?q=Peter. But I got zero respone.
>> > Can anyone help me please why is this?
>> > Thanks in advance.
>> >
>>
>>
>>
>> --
>> --Noble Paul
>>
>
--
--Noble Paul
Re: could not search the indexed table data
Posted by radha c <ra...@gmail.com>.
Thanks for your reply,
Yes, I have tabel persons and "Peter" value in column firstname . and here
is my data-config.xml
<dataConfig>
<dataSource ....>
<entity name="persons" pk="person_id" query="select
personid,firstname from persons" >
<field column="personid" name="person_id" />
<field column="fisrtname" name="fname" />
</entity>
</document>
</dataConfig>
and my schema.xml
<schema name="example">
<types>
<fieldType name="text" class="solr.TextField"
positionIncrementGap="100"/>
<fieldType name="integer" class="solr.IntField" omitNorms="true"/>
</types>
<fields>
<field name="person_id" type="integer" indexed="true" stored="true"
multivalued="false" required="true"/>
<field name="fname" type="text" indexed="true" stored="true"
multivalued="false"/>
</fields>
<uniqueKey>person_id</uniqueKey>
<solrQueryParser defaultOperator="OR"/>
</schema>
It is indexed properly. But I am not getting any result. Do I need to do
explicit commit?
Or Am I quering correctly http://localhost:8080/solr/select/?q=Peter ?
2009/3/22 Noble Paul നോബിള് नोब्ळ् <no...@gmail.com>
> it is hard to say the reason.
> do you have the field containing "Peter" in the default search field?
> what is the type of the field?
>
> On Sun, Mar 22, 2009 at 9:16 PM, radha c <ra...@gmail.com> wrote:
> > Hi,
> > I am just in learning face. I indexed a sql test table using dataimport.
> > But I want to search those index by keyword. I tried to search like
> > http://localhost:8080/solr/select/?q=Peter. But I got zero respone.
> > Can anyone help me please why is this?
> > Thanks in advance.
> >
>
>
>
> --
> --Noble Paul
>
Re: could not search the indexed table data
Posted by Noble Paul നോബിള് नोब्ळ् <no...@gmail.com>.
it is hard to say the reason.
do you have the field containing "Peter" in the default search field?
what is the type of the field?
On Sun, Mar 22, 2009 at 9:16 PM, radha c <ra...@gmail.com> wrote:
> Hi,
> I am just in learning face. I indexed a sql test table using dataimport.
> But I want to search those index by keyword. I tried to search like
> http://localhost:8080/solr/select/?q=Peter. But I got zero respone.
> Can anyone help me please why is this?
> Thanks in advance.
>
--
--Noble Paul