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 rajalapati <ra...@gmail.com> on 2012/01/12 13:21:51 UTC
Not able to see output in XML output
Hi,
In my SOLR, I have a query based data-config written and was able to manage
below steps but i was not able to see the output
1) Register Data Import Request handler in Solr-config.xml
2) Modify Data-Config.xml for the appropriate query to get data imported
from which includes making use of Jtds Driver for Sql server
3) Modify SolrConfig.xml file for registering db-data-config.xml in Request
Handler item
4) Modify schema.xml for the output result. Right now we are facing issues
here.please let me attach 2 files 1) schema.xml 2) db-data-config.xml.
Schema.xml
<?xml version="1.0" encoding="UTF-8" ?>
<schema name="example" version="1.2">
<types>
<fieldType name="string" class="solr.StrField" sortMissingLast="true"
omitNorms="true" />
<fieldType name="int" class="solr.TrieIntField" precisionStep="0"
omitNorms="true" positionIncrementGap="0" />
<fieldType name="date" class="solr.TrieDateField" omitNorms="true"
precisionStep="0" positionIncrementGap="0" />
<fieldType name="text" class="solr.TextField"
positionIncrementGap="100">
<analyzer type="index">
<tokenizer class="solr.WhitespaceTokenizerFactory" />
<filter class="solr.StopFilterFactory" ignoreCase="true"
words="stopwords.txt" enablePositionIncrements="true" />
<filter class="solr.WordDelimiterFilterFactory"
generateWordParts="1" generateNumberParts="1" catenateWords="1"
catenateNumbers="1" catenateAll="0" splitOnCaseChange="1" />
<filter class="solr.LowerCaseFilterFactory" />
<filter class="solr.SnowballPorterFilterFactory"
language="English" protected="protwords.txt" />
</analyzer>
<analyzer type="query">
<tokenizer class="solr.WhitespaceTokenizerFactory" />
<filter class="solr.SynonymFilterFactory" synonyms="synonyms.txt"
ignoreCase="true" expand="true" />
<filter class="solr.StopFilterFactory" ignoreCase="true"
words="stopwords.txt" enablePositionIncrements="true" />
<filter class="solr.WordDelimiterFilterFactory"
generateWordParts="1" generateNumberParts="1" catenateWords="0"
catenateNumbers="0" catenateAll="0" splitOnCaseChange="1" />
<filter class="solr.LowerCaseFilterFactory" />
<filter class="solr.SnowballPorterFilterFactory"
language="English" protected="protwords.txt" />
</analyzer>
</fieldType>
</types>
<fields>
<field name="FileId" type="string" indexed="true" stored="true"
required="true" />
<field name="Title" type="string" indexed="true" stored="true"
required="true" />
</fields>
<uniqueKey>FileId</uniqueKey>
<defaultSearchField>FileId</defaultSearchField>
<solrQueryParser defaultOperator="AND" />
</schema>
db-data-config.xml
<dataConfig>
<dataSource type="JdbcDataSource"
driver="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://17.30.199.667:1433;databaseName=XXXX" user="XXXX"
password="XXX" />
<document>
<entity name="Files" query="Select FileID,Title from files">
<field column="FileID" name="FileID" />
<field column="Title" name="Title" />
</entity>
</document>
</dataConfig>
5) Make full import http request for data to get indexed into solr server.
Even though i see that all the rows are indexed but not able to find results
when search is clicked on the admin page
6) Am i missing any step to configure the output,I have changed
db-data-config,schema.xml and solrconfig.xml files ,Do i need to change any
other files for the output
Thanks
Raj Deep
--
View this message in context: http://lucene.472066.n3.nabble.com/Not-able-to-see-output-in-XML-output-tp3653445p3653445.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Not able to see output in XML output
Posted by Erick Erickson <er...@gmail.com>.
Let's back up a bit here. First, what do your Solr logs show? Anything
unusual?
Second, is there anything in your index at all? What does the admin/stats
page show for numDocs and maxDocs?
People often forget to commit after a DIH import, did you make sure you
commited when the run was done?
Best
Erick
On Thu, Jan 12, 2012 at 7:21 AM, rajalapati <ra...@gmail.com> wrote:
> Hi,
>
> In my SOLR, I have a query based data-config written and was able to manage
> below steps but i was not able to see the output
>
>
>
> 1) Register Data Import Request handler in Solr-config.xml
> 2) Modify Data-Config.xml for the appropriate query to get data imported
> from which includes making use of Jtds Driver for Sql server
> 3) Modify SolrConfig.xml file for registering db-data-config.xml in Request
> Handler item
> 4) Modify schema.xml for the output result. Right now we are facing issues
> here.please let me attach 2 files 1) schema.xml 2) db-data-config.xml.
>
> Schema.xml
>
> <?xml version="1.0" encoding="UTF-8" ?>
> <schema name="example" version="1.2">
> <types>
> <fieldType name="string" class="solr.StrField" sortMissingLast="true"
> omitNorms="true" />
> <fieldType name="int" class="solr.TrieIntField" precisionStep="0"
> omitNorms="true" positionIncrementGap="0" />
> <fieldType name="date" class="solr.TrieDateField" omitNorms="true"
> precisionStep="0" positionIncrementGap="0" />
> <fieldType name="text" class="solr.TextField"
> positionIncrementGap="100">
> <analyzer type="index">
> <tokenizer class="solr.WhitespaceTokenizerFactory" />
> <filter class="solr.StopFilterFactory" ignoreCase="true"
> words="stopwords.txt" enablePositionIncrements="true" />
> <filter class="solr.WordDelimiterFilterFactory"
> generateWordParts="1" generateNumberParts="1" catenateWords="1"
> catenateNumbers="1" catenateAll="0" splitOnCaseChange="1" />
> <filter class="solr.LowerCaseFilterFactory" />
> <filter class="solr.SnowballPorterFilterFactory"
> language="English" protected="protwords.txt" />
> </analyzer>
> <analyzer type="query">
> <tokenizer class="solr.WhitespaceTokenizerFactory" />
> <filter class="solr.SynonymFilterFactory" synonyms="synonyms.txt"
> ignoreCase="true" expand="true" />
> <filter class="solr.StopFilterFactory" ignoreCase="true"
> words="stopwords.txt" enablePositionIncrements="true" />
> <filter class="solr.WordDelimiterFilterFactory"
> generateWordParts="1" generateNumberParts="1" catenateWords="0"
> catenateNumbers="0" catenateAll="0" splitOnCaseChange="1" />
> <filter class="solr.LowerCaseFilterFactory" />
> <filter class="solr.SnowballPorterFilterFactory"
> language="English" protected="protwords.txt" />
> </analyzer>
> </fieldType>
> </types>
> <fields>
> <field name="FileId" type="string" indexed="true" stored="true"
> required="true" />
> <field name="Title" type="string" indexed="true" stored="true"
> required="true" />
>
> </fields>
>
> <uniqueKey>FileId</uniqueKey>
> <defaultSearchField>FileId</defaultSearchField>
> <solrQueryParser defaultOperator="AND" />
> </schema>
>
>
> db-data-config.xml
>
> <dataConfig>
> <dataSource type="JdbcDataSource"
> driver="net.sourceforge.jtds.jdbc.Driver"
> url="jdbc:jtds:sqlserver://17.30.199.667:1433;databaseName=XXXX" user="XXXX"
> password="XXX" />
> <document>
> <entity name="Files" query="Select FileID,Title from files">
>
> <field column="FileID" name="FileID" />
> <field column="Title" name="Title" />
>
> </entity>
>
>
>
> </document>
> </dataConfig>
>
>
>
>
>
> 5) Make full import http request for data to get indexed into solr server.
> Even though i see that all the rows are indexed but not able to find results
> when search is clicked on the admin page
>
> 6) Am i missing any step to configure the output,I have changed
> db-data-config,schema.xml and solrconfig.xml files ,Do i need to change any
> other files for the output
>
>
> Thanks
> Raj Deep
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/Not-able-to-see-output-in-XML-output-tp3653445p3653445.html
> Sent from the Solr - User mailing list archive at Nabble.com.