How to Join more than two(2) cores in solr query
Hi,
I am using solr6.2.1 in my project. I want to join more than 2 cores as per
the requirement.
core1 : empid
core2 : empid,sid,pid
core3 : sid,pid
i want to join core2 and core3 on [core2.sid = core3.sid and core2.pid =
core3.pid] and the resultant records of core2.empid should be joined with
core1.empid.
Below is my solr query to join core2.sid = core3.sid, but do not know how to
write the query to join
core1.empid = core2.empid and core2.pid = core3.pid.
http://localhost:8983/solr/core2/select?q={!join from=sid to=sid
fromIndex=core3 v='*:*'}
currently i am not able to write solr query for above requirement.
Could you please help me out of this.
Thanks in advance,
AnilJayanti
--
View this message in context:
http://lucene.472066.n3.nabble.com/How-to-Join-more-than-two-2-cores-in-solr-query-tp4348067.html
Sent from the Solr - User mailing list archive at Nabble.com.
Nested documents using solr 6.2.1
hi ,
i am trying to work on nested documents in solr 6.2.1. I am trying to
generate employee info from database.
parent node consists of empid,cid,sid,pid.
child node consists of price,empid,cid,sid,pid.[multiple prices will be
exists, remaining values are same as parent]
data-config.xml
---
managed-schema
--
empid
Did full-import, completed successfully. when i used select query, below
resonse got.
http://localhost:9119/solr/employee/select?q=*:*
{
"responseHeader": {
"status": 0,
"QTime": 0,
"params": {
"q": "*:*",
"indent": "on",
"rows": "100",
"wt": "json",
"_": "1496057171982"
}
},
"response": {
"numFound": 3,
"start": 0,
"docs": [{
"empid": "E1",
"cid": "c1",
"sid": "s1",
"pid": "p1",
"price": "123"
},
{
"empid": "E1",
"cid": "c1",
"sid": "s1",
"pid": "p1",
"price": "567"
},
{
"empid": "E1",
"cid": "c1",
"sid": "s1",
"pid": "p1",
"price": "0"
}
]
}
}
when i query above, got the childs along with parent.[parent node that is
which is having price 'zero'].
I don't know how to write the solr query to get the below response.
{
"responseHeader": {
"status": 0,
"QTime": 0,
"params": {
"q": "*:*",
"indent": "on",
"rows": "100",
"wt": "json",
"_": "1496057171982"
}
},
"response": {
"numFound": 3,
"start": 0,
"docs": [{
"empid": "E1",
"cid": "c1",
"sid": "s1",
"pid": "p1",
"price": "0",
"_childDocuments_": [{
"empid": "E1",
"cid": "c1",
"sid": "s1",
"pid": "p1",
"price": "123"
},
{
"empid": "E1",
"cid": "c1",
"sid": "s1",
"pid": "p1",
"price": "567"
}
]
}]
}
}
Please help me in this.
Many thanks in advance.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Nested-documents-using-solr-6-2-1-tp4338024.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Filter first-components result in solr.SearchHandler
Hi Erik, thanks for your response, let me explain briefly. i wanted to make 5 employee id's as a priority id's. so every time when i am searching with specific keyword, then i want to append these 5 employee id's as first 5 results to the search results. example : let's take 3,5,6,8,9 are priority employee id's. when i am searching with specific keyword then got 4 docs (employee id's are 1,2,4,7) as results. then i want to display the final result as below. final result : 3,5,6,8,9,1,2,4,7 Please suggest me. Thanks. AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Filter-first-components-result-in-solr-SearchHandler-tp4232892p4232926.html Sent from the Solr - User mailing list archive at Nabble.com.
Filter first-components result in solr.SearchHandler
Hi All, I am workng on solr 5.2.1. I wrote my own component to get employee id's from first-component. I am trying to pass these id's to normal solr.SearchHandler () to filter the employee id's. relevant request handler in solrconfig.xml file : explicit 100 text custom-priority How I can pass employee id's in qf param correctly in query so that solr can use this while searching ? Suggestions are appreciated.. thanks in advance AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Filter-first-components-result-in-solr-SearchHandler-tp4232892.html Sent from the Solr - User mailing list archive at Nabble.com.
Combine multiple SOLR Query Results
Hi, I am trying to work on combine multiple SOLR query results into single result. Below is my case. 1. Look up search term against ‘track name’, log results 2. Look up search term against ‘artist name’, log results of tracks by those artists 3. Combine results 4. results by score descending order. Using "text_general" fieldType for both track name and artist name. copy fields are trackname and artistname Plase suggest me how to write solr Query to combine two solr results into single result. Thanks in advance. AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Combine-multiple-SOLR-Query-Results-tp4191816.html Sent from the Solr - User mailing list archive at Nabble.com.
passing SYS_REFCURSOR as out parameter for Oracle stored procedure
Hi, I am using solr 3.3 for index generation with sql server, generating index successfully, now I am trying to generate with Oracle DB. I am using "*UDP_Getdetails*" procedure to generate the required indexes. In this procedure its taking 2 inputs and 1 output parameters. *input params : id name output params : cv_1 IN OUT SYS_REFCURSOR* In solr, data-config.xml below is my configuration. ** I donot know how to pass "*SYS_REFCURSOR*" to procedure in solr. Please help me out of this. Thanks in Advance, Aniljayanti -- View this message in context: http://lucene.472066.n3.nabble.com/passing-SYS-REFCURSOR-as-out-parameter-for-Oracle-stored-procedure-tp4105307.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Indexing Multiple Languages with solr (Arabic & English)
Hi, Thanks for ur post, I donot know how to use "text_ar" fieldtype for Arabic language. What are the configurations need to add in schema.xml file ? Please guide me. AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Indexing-Multiple-Languages-with-solr-Arabic-English-tp4104580p4104613.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Best approach to multiple languages
Hi thanks for you post. I am searching for this type of multiple language indexing and searching in solr. Below is my post in lecene. Can you please help me out of this. http://lucene.472066.n3.nabble.com/Indexing-Multiple-Languages-with-solr-Arabic-amp-English-td4104580.html thanks in advance, aniljayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Best-approach-to-multiple-languages-tp498198p4104593.html Sent from the Solr - User mailing list archive at Nabble.com.
Indexing Multiple Languages with solr (Arabic & English)
Hi, I am working on solr for using searching by indexing with "text_general" for "ENGLISH" language. Search is working fine. Now I have a Arabic text, which needs to indexing and searching. Below is my basic config for English.* Same field contains "ENGLISH" and "ARABIC" text in database*. Please guide me in this. I saw below configs in schema.xml file for Arabic language. Please suggest me to configure Arabic indexing and searching. Thanks in Advance, AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Indexing-Multiple-Languages-with-solr-Arabic-English-tp4104580.html Sent from the Solr - User mailing list archive at Nabble.com.
RE: "Caused by: java.net.SocketException: Connection reset by peer: socket write error" solr querying
) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:368) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:942) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1004) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:640) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72) at org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(SocketConnector.java:264) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:662) Caused by: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at org.eclipse.jetty.io.ByteArrayBuffer.writeTo(ByteArrayBuffer.java:375) at org.eclipse.jetty.io.bio.StreamEndPoint.flush(StreamEndPoint.java:164) at org.eclipse.jetty.io.bio.StreamEndPoint.flush(StreamEndPoint.java:194) at org.eclipse.jetty.http.HttpGenerator.flushBuffer(HttpGenerator.java:841) ... 50 more Thanks, AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Caused-by-java-net-SocketException-Connection-reset-by-peer-socket-write-error-solr-querying-tp4086234p4086565.html Sent from the Solr - User mailing list archive at Nabble.com.
"Caused by: java.net.SocketException: Connection reset by peer: socket write error" solr querying
at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:158) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1419) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:368) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:942) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1004) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:640) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72) at org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(SocketConnector.java:264) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:662) Please help me out of this. Thanks in advance. AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Caused-by-java-net-SocketException-Connection-reset-by-peer-socket-write-error-solr-querying-tp4086234.html Sent from the Solr - User mailing list archive at Nabble.com.
“ClientAbortException: java.io.IOException” in solr query
Hi, I am generating solr indexing using apache-tomcat-7.0.19 and solr 3.3. Indexing generated successfully with count of "3350128" records. Now i am testing my solr index search performance continuously by hitting with different search queries. while testing some search queries are getting failed, and getting below error in tomcat error logs. org.apache.solr.common.SolrException log SEVERE: ClientAbortException: java.io.IOException at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:333) at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:299) at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:103) at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:278) at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:122) at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:212) at org.apache.solr.common.util.FastWriter.flush(FastWriter.java:115) at org.apache.solr.servlet.SolrDispatchFilter.writeResponse(SolrDispatchFilter.java:344) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:265) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:851) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:257) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1764) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: java.io.IOException at org.apache.coyote.http11.InternalAprOutputBuffer.flushBuffer(InternalAprOutputBuffer.java:208) at org.apache.coyote.http11.InternalAprOutputBuffer.flush(InternalAprOutputBuffer.java:111) at org.apache.coyote.http11.AbstractHttp11Processor.action(AbstractHttp11Processor.java:721) at org.apache.coyote.Response.action(Response.java:170) at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:328) ... 24 more Can you please help me out of this.. thanks in advance, Aniljayanti -- View this message in context: http://lucene.472066.n3.nabble.com/ClientAbortException-java-io-IOException-in-solr-query-tp4082321.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Restrict/change "numFound" solr result
Hi Erick, thanks for reply, I am doing the same thing already. But for paging calculation i am depending on "numFound="120" value. That result i want .() thanks aniljayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Restrict-change-numFound-solr-result-tp4075882p4076485.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Restrict/change "numFound" solr result
Hi Ralf, thanks for reply, I have 540 records as a solr result. In that i want only 120 records (), based on the "numFound" node value i am calculating paging concept. i want to show 12 records per page then (120/12 = 10 pages) i would have 10 pages. Right. So i want that scenario. . i do not want total 540 records as (http://lucene.472066.n3.nabble.com/Restrict-change-numFound-solr-result-tp4075882p4076149.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Restrict/change "numFound" solr result
Hi Erick, thanks for reply, after querying using solr getting 540 records, but i had a requirement to get only 120 records even though it may have greater than 120. After getting results i am calculating the paging on the basis of *"numFound=120"*.That is why i am checking this. if i take 12 record count per page then i'll get 10 pages. (120/12 =10 pages). Please help. thanks, Aniljayanti. -- View this message in context: http://lucene.472066.n3.nabble.com/Restrict-change-numFound-solr-result-tp4075882p4076101.html Sent from the Solr - User mailing list archive at Nabble.com.
Restrict/change "numFound" solr result
Hi, I am working on solr 3.3. i am getting total 120 records with below query, in response xml "numFound" is showing 540 records. http://localhost:8080/test/select?q=*:*&rows=*120* 0 1 *:* 120 green blue red .. (120 records) i want to restrict the result records to 120. How can i get *"numFound=120"* like below, even though existing records are 540. 0 1 *:* *120* green blue red .. (120 records) Please suggest me how to query to get desired numFound records. thanks in advance. aniljayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Restrict-change-numFound-solr-result-tp4075882.html Sent from the Solr - User mailing list archive at Nabble.com.
undefined field http:// while searchi query
Hi, I am using solr 3.3 version. After indexing I am querying below command. http://localhost:8080/solr/select/?q=*(http://www.google.co.in)* getting below error. SEVERE: org.apache.solr.common.SolrException: *undefined field http://* at org.apache.solr.schema.IndexSchema.getDynamicFieldType(IndexSchema.java:1254) at org.apache.solr.schema.IndexSchema$SolrQueryAnalyzer.getAnalyzer(IndexSchema.java:410) at org.apache.solr.schema.IndexSchema$SolrIndexAnalyzer.reusableTokenStream(IndexSchema.java:385) at org.apache.lucene.queryParser.QueryParser.getFieldQuery(QueryParser.java:574) at org.apache.solr.search.SolrQueryParser.getFieldQuery(SolrQueryParser.java:158) at org.apache.lucene.queryParser.QueryParser.Term(QueryParser.java:1421) at org.apache.lucene.queryParser.QueryParser.Clause(QueryParser.java:1309) at org.apache.lucene.queryParser.QueryParser.Query(QueryParser.java:1237) at org.apache.lucene.queryParser.QueryParser.Clause(QueryParser.java:1313) at org.apache.lucene.queryParser.QueryParser.Query(QueryParser.java:1237) at org.apache.lucene.queryParser.QueryParser.Clause(QueryParser.java:1313) at org.apache.lucene.queryParser.QueryParser.Query(QueryParser.java:1237) at org.apache.lucene.queryParser.QueryParser.TopLevelQuery(QueryParser.java:1226) at org.apache.lucene.queryParser.QueryParser.parse(QueryParser.java:206) at org.apache.solr.search.LuceneQParser.parse(LuceneQParserPlugin.java:80) at org.apache.solr.search.QParser.getQuery(QParser.java:142) at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:81) at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:173) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) at org.apache.solr.core.SolrCore.execute(SolrCore.java:1368) at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:257) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1764) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) can you please assist me in this. thanks in advance. Aniljayanti. -- View this message in context: http://lucene.472066.n3.nabble.com/undefined-field-http-while-searchi-query-tp4074601.html Sent from the Solr - User mailing list archive at Nabble.com.
Index generation using SOLR 4.2 configurations
Hi, Presently i am generating employee details index using solr 3.3 & apache-tomcat-7.0.19 setup. Now i want to try this with solr 4.2 new version. created new setup for this. d:\apache-tomcat-7.0.19\solr_4_2\collection1\ in this below directories are there. 1) bin 2) conf >> solrconfig.xml,schema.xml,data-config.xml,scripts.conf & zoo.cfg files are there. 3) lib >> hsqldb-1.8.0.10.jar , solr-4.2.0.war,solr-dataimporthandler-4.2.0.jar,solr-dataimporthandler-extras-4.2.0.jar files are there. in data-config.xml below tags are there. when im using dataimport command http://localhost:8080/solr_4_2/dataimport?command=full-import getting index failed. below are the errors. SEVERE: Exception while processing: EMPLOYEE document : SolrInputDocument[]:org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select type,title,name,empid from employee Processing Document # 1 at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:253) at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210) at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:38) at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59) at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73) at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:465) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:319) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:227) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:422) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:487) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:468) Caused by: java.sql.SQLException: *File input/output error //127.0.0.1.properties java.io.FileNotFoundException: \\127.0.0.1.properties.new* (The filename, directory name, or volume label syntax is incorrect) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:127) at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:366) at org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:38) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.(JdbcDataSource.java:240) ... 12 more Please help me in this... Thanks in Advance. AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Index-generation-using-SOLR-4-2-configurations-tp4049618.html Sent from the Solr - User mailing list archive at Nabble.com.
want to get Alert while “java.lang.OutOfMemoryError: PermGen space” error coming in SOLR Generation
Hi, Im generating SOLR using SOLR 3.3, Apache Tomcat 7.0.19. Some times my Tomcat get hanged giving below error in log. SEVERE: Full Import failed:org.apache.solr.handler.dataimport.DataImportHandlerException: java.lang.OutOfMemoryError: PermGen space at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:664) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:267) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:186) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:359) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:427) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408) Caused by: java.lang.OutOfMemoryError: PermGen space at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(ClassLoader.java:632) i have given below memory size. --JvmMs 2048 --JvmMx 3096 -XX:MaxPermSize=1024m So i want to get ALERT when ever SOLR strucked or gives OutOfMemory. Thanks in Advance. AnilJayanti. -- View this message in context: http://lucene.472066.n3.nabble.com/want-to-get-Alert-while-java-lang-OutOfMemoryError-PermGen-space-error-coming-in-SOLR-Generation-tp4025011.html Sent from the Solr - User mailing list archive at Nabble.com.
Encryption of dataConfig section fields in SOLR
Hi, Im generating SOLR from DB with below dataConfig section in data-config.xml file, and it's working fine. url="jdbc:sqlserver://127.0.0.1;databaseName=emp" user="user" password="user"*/> I want to ENCRYPT the *url, databaseName, user and password* fields in above configuration. Please Help, Thanks in Advance. AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Encryption-of-dataConfig-section-fields-in-SOLR-tp4012005.html Sent from the Solr - User mailing list archive at Nabble.com.
same results for select and More Like This(MLT) search
Hi, My application is working fine with normal search (*/select?q=*) using SOLR. Normal Query URL: solr/select?q=title:lovely Now want to implement More Like This (MLT) in my application. Configured MLT in SOLr below like this. solrconfig.xml -- title 1 2 true URL : solr/mlt?q=title:lovely&mlt.fl=title im getting results and count with MLT same like normal select query. Can you please guide me if i did any wrong configurations for MLT ??? Thanks in Advance, AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/same-results-for-select-and-More-Like-This-MLT-search-tp4011563.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Problem with Special Characters in SOLR Query
Hi, thanks, I tried with below query getting result. q=Cheat \- Album Version But getting error with below. q=Oot \& Aboot Error message : -- message org.apache.lucene.queryParser.ParseException: Cannot parse 'Oot \': Lexical error at line 1, column 6. Encountered: after : "" description The request sent by the client was syntactically incorrect (org.apache.lucene.queryParser.ParseException: Cannot parse 'Oot \': Lexical error at line 1, column 6. Encountered: after : ""). anilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/Problem-with-Special-Characters-in-SOLR-Query-tp4010712p4010720.html Sent from the Solr - User mailing list archive at Nabble.com.
Problem with Special Characters in SOLR Query
Hi ,
Im using "text_general" fieldType for searching in SOLR. while searching
keywords along with special characters not getting proper results and
getting errors. used special characters like below.
1) -
2) &
3) +
QUERY ::
*solr?q=Healing - Live*
*solr?q=Healing & Live*
*solr?q=Healing ? Live*
Error message:
The request sent by the client was syntactically incorrect
(org.apache.lucene.queryParser.ParseException: Cannot parse '("Healing \':
Lexical error at line 1, column 8. Encountered: after : "\"Healing
\\").
schema.xml
---
text
Please suggest me in this, and thanks in advance.
AnilJayanti
--
View this message in context:
http://lucene.472066.n3.nabble.com/Problem-with-Special-Characters-in-SOLR-Query-tp4010712.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi, Finally got Solved using TermComponents. schema.xml -- URL : http://localhost:8080/solr/terms?*terms.fl=autocomplete_text&omitHeader=true&terms.sort=index&terms.prefix=mad* Response : *1 1 2 1 1 1 * -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4010125.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Certain form of autocomplete (like Google Suggest)
Hi, Have you got any solution for this ??? I worked out in SOLR check this.. http://stackoverflow.com/questions/12174672/suggesterauto-completion-search-in-solr-using-ngrams-one-collation-for-sugges -- View this message in context: http://lucene.472066.n3.nabble.com/Certain-form-of-autocomplete-like-Google-Suggest-tp486567p4007411.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: suggester issues
Hi, I m also facing same issue while using suggester (working in c#.net). Below is my configurations. suggest/?q="michael ja" --- Response : - - 0 1 - - - 10 1 8 - michael "bully" herbig michael bolton michael bolton: arias michael falch michael holm michael jackson michael neale michael penn michael salgado michael w. smith - 10 9 11 - ja me tanssimme jacob andersen jacob haugaard jagged edge jaguares jamiroquai jamppa tuominen jane olivor janis joplin janne tulkki "michael "bully" herbig ja me tanssimme" Please Help, AnilHayanti -- View this message in context: http://lucene.472066.n3.nabble.com/suggester-issues-tp3262718p4007205.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi, Thanks, Iam getting the results with below url. *suggest/?q="michael b"&df=title&defType=lucene&fl=title* But, i want the results in spellcheck section. i want to search with title or empname or both. Aniljayanti -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4005812.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
HI, Thanks, i want to search with title and empname both. for example when we use any search engine like google,yahoo... we donot specify any type that is (name or title or song...). Here (*suggest/?q="michael b"&df=title&defType=lucene*) we are specifying the title type search. I removed said configurations in solrconfig.xml file, got result like below. 10 1 8 michael michael michael " michael j michael ja michael jac michael jack michael jacks michael jackso michael jackson 10 9 10 b b ba bab bar barb be ben bi bl "michael b" I sent my schema and solrconfig xml file configurations. Please check. Aniljayanti -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4005545.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi, thanks, I m sending my whole configurations in schema and solrconfig.xml files. schema.xml --- * solrconfig.xml - suggest org.apache.solr.spelling.suggest.Suggester org.apache.solr.spelling.suggest.fst.FSTLookup suggest autocomplete_text true 0.005 true true jarowinkler lowerfilt org.apache.lucene.search.spell.JaroWinklerDistance spellchecker edgytext true suggest true 5 false 5 1000 true suggest query URL : suggest/?q="michael b" - Response : 0 3 10 1 8 michael bully herbig michael bolton michael bolton: arias michael falch michael holm michael jackson michael neale michael penn michael salgado michael w. smith 10 9 10 b in the mix - the remixes b2k backstreet boys backyard babies banda maguey barbra streisand barry manilow benny goodman beny more beyonce "michael bully herbig b in the mix - the remixes" -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4005490.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi, thanks, Im not able to attach asked xml files here. Can u give me ur Email id, so that i can send schema and solrconfig.xmls. Regards, AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4005141.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi, Thanks, As i already used "KeywordTokenizerFactory" in my earlier posts. * * * * getting same results. AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4004871.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi, thanks, I checked with given changes, getting below error saying that SOLR is not allowing without tokenizer. org.apache.solr.common.SolrException: analyzer without class or tokenizer & filter list at org.apache.solr.schema.IndexSchema.readAnalyzer(IndexSchema.java:914) at org.apache.solr.schema.IndexSchema.access$100(IndexSchema.java:62) at ... can u tell me wht to do? AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4004605.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi, thanks, I added "PatternReplaceFilterFactory" like below.Getting results differently(not like suggester). You suggested to remove "KeywordTokenizerFactory" , "PatternReplace" is a FilterFactory, then which "TokenizerFactory" need to use ? Result : - - 0 2 - - - 10 0 7 - *michael michael michael " michael j michael ja michael jac michael jack michael jacks michael jackso michael jackson* - 10 8 10 - *ja ja jag jam jami jamp jampp jamppa jamppa jamppa t* michael ja Please suggest me if anything missing? Regards, AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4004231.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi thanks, I tried with below said changes, but getting same result as earlier. suggest/?q="michael ja" --- Response : - - 0 1 - - - 10 1 8 - *michael "bully" herbig michael bolton michael bolton: arias michael falch michael holm michael jackson michael neale michael penn michael salgado michael w. smith* - 10 9 11 - * ja me tanssimme jacob andersen jacob haugaard jagged edge jaguares jamiroquai jamppa tuominen jane olivor janis joplin janne tulkki* "michael "bully" herbig ja me tanssimme" Please Help, AnilHayanti -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4004230.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi, thanks for ur reply, I donot know how to remove multiple white spaces using regax in the search text. Can u share me that one. Thanks, AnilJayanti -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p4003991.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: AW: auto completion search with solr using NGrams in SOLR
Hi thanks, which doing searching i will search either with empname or title only. And also not using any asterics in the query. ex : if i search with "mic" result should come like michale jackson michale border michale smith want the result just like google search. can us suggest me wht are the configuration need to add/change to get the result like google search ?. for my required result which tokenizers need to use. ? can u tell me how to call a query for this?? thanks, -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p3999171.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Solr TermsComponent: space in term
Hi Im working on autocompelte functionality in solr. can u suggest me the required configurations in schema.xml and solrconfig.xml for doing autocomplete in solr ?? thanks in advance, Anil -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-TermsComponent-space-in-term-tp1898889p3998755.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: AW: auto completion search with solr using NGrams in SOLR
Hi, thanks, im searching with empname filed. want to search with both "empname" and "title". below is my changed code. SOLR Query : http://localhost:8080/AC/select/?q=(*am*)&rows=500 1) want to search with "title" and "empname" both. 2) am i quering correctly with above url ?? but getting result like . p*am* s*am* ra*am*a but i want the result like aman amar amal please help me in this... -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559p3998721.html Sent from the Solr - User mailing list archive at Nabble.com.
auto completion search with solr using NGrams in SOLR
I want to implement an auto completion search with solr using NGrams. If the user is searching for names of employees, then auto completion should be applied. ie., if types "j" then need to show the names starts with "j" if types "ja" then need to show the names starts with "ja" if types "jac" then need to show the names starts with "jak" if types "jack" then need to show the names starts with "jack" Below is my configuration settings in schema.xml, Please suggest me if anything wrong. below is my code in schema.xml when im searching with name "mado" or "madonna" getting employees names.But when searching with "madon" not getting any data. Please help me on this. Thanks in Advance, Anil. -- View this message in context: http://lucene.472066.n3.nabble.com/auto-completion-search-with-solr-using-NGrams-in-SOLR-tp3998559.html Sent from the Solr - User mailing list archive at Nabble.com.
