Re: How to do sorting instead of using bq

Hi Upayavira, Yes, I have create boost which is come from outside and I can't index them into the doc because it need to be realtime sort. How can i do? other solution for the sort in this case? Thank you very much, Chun. -- View this message in context:

How to do sorting instead of using bq

Hi all, I'm trying to sort some docs which is about 200 or more docs. by using bq like this.. *[bq] = product_id:L90094438^1 product_id:L90094438^3 product_id:L90094438^5 product_id:W27529923^123 product_id:W27529678^127 product_id:W27530909^133* *[sort] = score asc* The score that

Re: Customise score

Hi Jack, I just found out that the sort it doesn't work right for the next page. The response result show that numFound:23850. So I tried this .../select?q=MacBooksort=sum(base_score,query($q,0))+descwt=jsonindent=truestart=100 The summary of base_score and document sort at the next page should

Customise score

Dear all, Could anybody suggest me how to customize the score? So, I have data like this .. {ID : '0001', Title :'MacBookPro',Price: 400,Base_score:'121.2'} {ID : '0002', Title :'MacBook',Price: 350,Base_score:'100.2'} {ID : '0003', Title :'Laptop',Price: 300,Base_score:'155.7'} Notice that I

Re: Customise score

Gora, firstly I would like thank you for your quick response. .../select?q=MacBooksort=SUM(base_score, score)+descwt=jsonindent=true I tried that but it didn't work and I got this error message error:{ msg:Can't determine a Sort Order (asc or desc) in sort spec 'SUM(base_score, score)

Re: Customise score

Hi Ahmet, I also tried this .../select?q=MacBooksort=sum(base_score, score)+descwt=jsonindent=true I got the same error error:{ msg:Can't determine a Sort Order (asc or desc) in sort spec 'sum(base_score, score) desc', pos=15, code:400}} Best regards, Chun -- View this message in

Re: Customise score

Hi Jack, I tried as you suggest .../select?q=MacBooksort=sum(base_score,score)+descwt=jsonindent=true but it didn't work and I got this error message error:{ msg:sort param could not be parsed as a query, and is not a field that exists in the index: sum(base_score,score), code:400}}

Re: Customise score

Hi, Jack, Thank you very much for you solution its works! I'm sorry that I didn't make it clear at the beginning for 'score' which i mean document score (solr produce it at query time). Thank you very much for all of you, Chun. -- View this message in context:

How to sort value that numeric mix alpha

Dear all, Could anybody suggest me how to sort the field that has numeric mix with alpha. In my case I have field name 'product_id' which contain value like C1,C2,C3,C4,C9,C12,C23,C50 when I try to sort (DESC) it return wrong result something like this C9,C50,C4,C3,C23,C2,C12,C1 As you see I

Re: How to sort value that numeric mix alpha

Thank you for both of you I finally re-index data and remove 'C' and index only numeric. So, that the way I fix my problem. Best, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/How-to-sort-value-that-numeric-mix-alpha-tp4144615p4144693.html Sent from the Solr -

Re: Solr shut down by itself

HI Alex, Thank you very much for your suggestion. I found some OOM problem before it shut down. Now I will try to fix that problem. Best, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-shut-down-by-itself-tp4138233p4138378.html Sent from the Solr - User mailing

about analyzer and tokenizer

Dear all, How can I do this... I index the document = Macbook then when I query mac book I should get the result. This is my schema setting... fieldType name=text_th class=solr.TextField positionIncrementGap=100 analyzer tokenizer class=solr.StandardTokenizerFactory/

Re: about analyzer and tokenizer

Thank you very much for your suggestion both of you. I will try more to figure out which way will be match with my case. Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/about-analyzer-and-tokenizer-tp4138129p4138227.html Sent from the Solr - User mailing list

Solr shut down by itself

Dear all, Could anyone tell me what wrong with this? How can I fix this problem? INFO - 2014-05-27 03:08:00.252; org.eclipse.jetty.server.Server; Graceful shutdown SocketConnector@0.0.0.0:8983 INFO - 2014-05-27 03:08:00.254; org.eclipse.jetty.server.Server; Graceful shutdown

Re: numFound is not correct while using Result Grouping

I'm still having the same problem which is can not get ngroups when set group.main=true. Is this problem fix? I'm usgin Solr 4.6.0 than you very much, Chun. -- View this message in context:

Re: group.ngroups behavior in response

Hi Amit, could you tell me is this problem fix in Solr 4.6.0? because i still having this problem or any suggestion? please help. thank you very much, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/group-ngroups-behavior-in-response-tp4033924p4132473.html Sent from

Re: PHP Solr Client - spellchecker

Thank you very much Shawn, Now i'm trying to use prefix for my suggestion instead. Best regards, Chun -- View this message in context: http://lucene.472066.n3.nabble.com/PHP-Solr-Client-spellchecker-tp4122780p4123054.html Sent from the Solr - User mailing list archive at Nabble.com.

PHP Solr Client - spellchecker

see that it goes through my requestHandler named spell Did I do something wrong? I really need help. Thank you very much, Rachun -- View this message in context: http://lucene.472066.n3.nabble.com/PHP-Solr-Client-spellchecker-tp4122780.html

Can not index document in solar

Dear all, Could you guys please help me? I just try to index document into solar it doesn't give me any error but it doesn't index document too but it used to work but not now please see.. #Solr Log WARN - 2014-02-25 11:30:35.675; org.apache.solr.handler.loader.XMLLoader; Unknown attribute

Re: Can not index document in solar

Thank you Eric, I figured out something that actually the document is indexed but it doesn't show on my api result because it missed some field. So I would like to delete this post how can I? Thank you very much, Chun. -- View this message in context:

Re: Limit amount of search result

hi Samee, Thank you very much for your suggestion. Now I got it worked now;) Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Limit-amount-of-search-result-tp4117062p4117952.html Sent from the Solr - User mailing list archive at Nabble.com.

Limit amount of search result

Dear all gurus, I would like to limit amount of search result, let's say I have many shop which is selling shirt. So when I search white shirt I want to give a maximum number per shop (ex. 5). The result should be like this... - Shop A - Shop A - Shop B - Shop B - Shop B - Shop B - Shop B -

Re: Import data from mysql to sold

Hi gurus, after I got Solr DIH work with mysql now I need to make figure out how to make it work with MongoDB. I have been searching for all day but I don't have luck with it. So could anyone please suggest me any site for my solution? Thank you very much, Chun. -- View this message in

Re: Import data from mysql to sold

Hi Jack, Thank you very much for your reply. I've read that article already but it seem not what i am looking for. I'm not sure if it's possible to do what i want or not. Now I can import all data from mysql to Solr but my boss just want me to find the way to import from MongoDB into solr.

Re: Import data from mysql to sold

I agree with you. I finally have another solution for this problem we will import all data directly from mysql instead. Thank you for all comments, keep sharing keep learning :) _/|\_ Chun. -- View this message in context:

Re: Import data from mysql to sold

please see below code.. dataConfig dataSource type=JdbcDataSource driver=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/mydb01 user=root password=/ document entity name=users query=select id,firstname,username from users

Re: Import data from mysql to sold

I just would like to thank you for all guru's comments ;) Now i got it work Thank you for sharing and helps. _/|\_ Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Import-data-from-mysql-to-sold-tp4114982p4115431.html Sent from the Solr - User mailing list archive

Import data from mysql to sold

Dear all gurus, I would like to import my data (mysql) about 4 Million rows into solar 4.6. What is the best way to do it? Please suggest me. Million thanks, Chun. -- View this message in context: http://lucene.472066.n3.nabble.com/Import-data-from-mysql-to-sold-tp4114982.html Sent from

Re: Query by range of price

Hi Raymond, I keep trying to encode the '' but when I look at the solar log it show me that '%26' I'm using urlencode it didn't work what should i do? Please suggest me. Thank you very much, Rachun -- View this message in context: http://lucene.472066.n3.nabble.com/Query-by-range-of-price

Re: Query by range of price

Hi Raymond, I keep trying to encode the '' but when I look at the solar log it show me that '%26' I'm using urlencode it didn't work what should i do? Im using PHPSolrClient. Please suggest me. Thank you very much, Rachun -- View this message in context: http://lucene.472066.n3

Re: Query by range of price

Hi Raymond, I keep trying to encode the '' but when I look at the solar log it show me that '%26' I'm using urlencode it didn't work what should i do? Im using SolrPHPClient. Please suggest me. Thank you very much, Rachun -- View this message in context: http://lucene.472066.n3

Re: Query by range of price

Thank you very much Mr. Raymond You just saved my world ;) It's worked and *sort by conditions * but facet.query=price_min:[* TO 1300] not working yet but I will try to google for the right solution. Million thanks _/|\_ Rachun. -- View this message in context: http://lucene.472066.n3

Re: Query by range of price

Thank you very much Raymond, I will try -- View this message in context: http://lucene.472066.n3.nabble.com/Query-by-range-of-price-tp4111655p4112229.html Sent from the Solr - User mailing list archive at Nabble.com.

Query by range of price

Hi Gurus, Please help... I just want to query the document with price_min range and I do like this q=...sort=price_min asc,update_date descfacet.query=price_min:[*+TO+1300] I got error '400' Status: Bad Request what's wrong with this? Thank you very much. -- View this message in context:

Re: Query by range of price

this is the log says: INFO - 2014-01-17 09:50:14.448; org.apache.solr.core.SolrCore; [collection1] webapp=/solr path=/select params={start=0q=???%26sort%3Dprice_min+asc,update_date+desc%26facet.query%3Dprice_min:[*%2BTO%2B1300]json.nl=mapwt=jsonrows=100} status=400 QTime=2 could you please

Re: Query by range of price

I have no idea Mr. Eric :( thanks, Rachun -- View this message in context: http://lucene.472066.n3.nabble.com/Query-by-range-of-price-tp4111655p4111853.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Can I define the copy field like title_*

thank you very much Mr. Sumit -- View this message in context: http://lucene.472066.n3.nabble.com/Can-I-define-the-copy-field-like-title-tp468p471.html Sent from the Solr - User mailing list archive at Nabble.com.

Can I define the copy field like title_*

I just wonder can I define copy field like this copyField source=title_* dest=text/ instead of copyField source=title_th dest=text/ copyField source=title_en dest=text/ millions thank you Rachun -- View this message in context: http://lucene.472066.n3.nabble.com/Can-I-define-the-copy

Re: How to index data in muliValue field with key

thank you Mr. Steve. Now I understood and i figured out to separate field to title_th and title_en and it worked ;) -- View this message in context: http://lucene.472066.n3.nabble.com/How-to-index-data-in-muliValue-field-with-key-tp4110653p4110981.html Sent from the Solr - User mailing list

How to index data in muliValue field with key

*This might be very simple question but I can't figure out after i tried to google all day. I just want the data to show like this* /record: [ { id: product001 name: iPhone case, title: { th: เคส ไอโฟน5 iphone5 Case วิบวับ ลายผสมมุกสีชมพู back case,