What is your <uniqueKey> set to? Could it be you have duplicates in
your uniqueKey setup (thus producing only 10 rows in index)?
- Jon
On Oct 12, 2008, at 1:30 PM, con wrote:
I wrote a jdbc program to implement the same query. But it is
returning all
the responses, 25 nos.
But the solr is still indexing only 10 rows.
Is there any optimization settings by default in the solrconfig.xml
that
restricts the responses to 10 ?
thanks
con.
Noble Paul നോബിള് नोब्ळ् wrote:
template transformer does not eat up rows.
I am almost sure that the query returns only 10 rows in that case.
could you write a quick jdbc program and verify that (not the oralce
client)
everything else looks fine
On Sat, Oct 11, 2008 at 4:52 PM, con <[EMAIL PROTECTED]> wrote:
Hi Noble
Thanks for your reply
In my data-config.xml I have;
<entity name="employees" transformer="TemplateTransformer"
query="Select
EMP_ID , EMP_NAME , NVL (COMMENT ,'-Nil-') as COMMENT from
EMPLOYEES">
<field column="rowtype" template="employees" />
<field column="EMP_ID" name="EMP_ID" />
<field column="EMP_NAME" name="EMP_NAME" />
<field column="COMMENT" name="COMMENT" />
</entity>
<entity name="customers" transformer="TemplateTransformer"
query="Select
CUST_ID , CUST_NAME , NVL (COMMENT ,'-Nil-') as COMMENT from
CUSTOMERS">
<field column="rowtype" template="customers" />
<field column="CUST_ID" name="CUST_ID />
<field column="CUST_NAME" name="CUST_NAME" />
<field column="COMMENT" name="COMMENT" />
</entity>
Whether this, TemplateTransformer, is the one that is restricting
the
resultset count to 10?
Where can I find it out?
I need this TemplateTransformer because I want to query the
responses of
either one of these at a time using the URL like,
http://localhost:8983/solr/select/?q=(Bob%20AND%20rowtype:customers)&version=2.2&start=0&rows=10&indent=on&wt=json
I tried in the debug mode:
(http://localhost:8983/solr/dataimport?command=full-import&debug=on&verbose=on
)
, But it is not all mentioning anything after the 10th document.
Thanks and regards
con
Noble Paul നോബിള് नोब्ळ् wrote:
The DIH status says 10 rows which means only 10 rows got fetched
for
that query. Do you have any custom transformers which eats up rows?
Try the debug page of DIH and see what is happening to the rest
of the
rows.
On Fri, Oct 10, 2008 at 5:32 PM, con <[EMAIL PROTECTED]> wrote:
A simple question:
I performed the following steps to index data from a oracle db
to solr
index
and then search:
a) I have the configurations for indexing data from a oracle db
b) started the server.
c) Done a full-import:
http://localhost:8983/solr/dataimport?command=full-import
But when I do a search using http://localhost:8983/solr/select/?
q=....
Not all the result sets that matches the search string are
displayed.
1) Is the above steps enough for getting db values to solr index?
My configurations (data-config.xml and schema.xml )are quite
correct
because
I am getting SOME of the result sets as search result(not all).
2) Is there some value in sorconfig.xml, or some other files that
limits
the
number of items being indexed? [For the time being I have only a
few
hundreds of records in my db. ]
The query that I am specifying in data-config yields around 25
results
if
i
execute it in a oracle client, where as the status of full-
import is
something like:
<str name="status">idle</str>
<str name="importResponse">Configuration Re-loaded sucessfully</
str>
<lst name="statusMessages">
<str name="Total Requests made to DataSource">1</str>
<str name="Total Rows Fetched">10</str>
<str name="Total Documents Skipped">0</str>
<str name="Full Dump Started">2008-10-10 17:29:03</str>
<str name="Time taken ">0:0:0.513</str>
</lst>
--
View this message in context:
http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19916938.html
Sent from the Solr - User mailing list archive at Nabble.com.
--
--Noble Paul
--
View this message in context:
http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19931736.html
Sent from the Solr - User mailing list archive at Nabble.com.
--
--Noble Paul
--
View this message in context:
http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19943817.html
Sent from the Solr - User mailing list archive at Nabble.com.