how to build multi index relation??

2014-03-28 Thread Nick Chang
Hello All I have multi index from different input. Ex: One of MongoDB : One of MySQL ; One of Accesslog. User information in the MySQL. User Behavior in ther Mongodb. IP in the accesslog. User information include User account, book name, book id User Behavior include book id, what is user's

About script fields document??

2014-03-06 Thread Nick Chang
Hello Where can found a lot of script fields document?? I saw values.length or values.size . But, I don't found a lot of function with elasticsearch.org. Thanks -- You received this message because you are subscribed to the Google Groups elasticsearch group. To unsubscribe from this group

Problem with terms facet multi fields?

2014-03-03 Thread Nick Chang
Hello Why does not like Mysql count(DISTINCT userId, prdId) ?? { facets: { book: { terms: { fields: [ userId,prdId ], size: 10, order: count } } }, size: 0 } result : facets: {

Re: Problem with terms facet multi fields?

2014-03-03 Thread Nick Chang
Thanks Binh But, In elasticsearch, How to count the number of terms returned in the facet array? I found the doc. Not include facet array length function. Do you have any suggest?? Thanks again. Binh Ly於 2014年3月4日星期二UTC+8上午4時16分42秒寫道: The terms facet will use a combo of term values from

Problem with kibana3-m5 ?

2014-03-02 Thread Nick Chang
Hello I used kibana for report. In Chrome plugin - sense POST /readinglog/_search { query: { filtered: { query: { match: { userId: (Goolge)b...@gmail.com } } } }, facets: { user: {

Re: How to count??

2014-02-27 Thread Nick Chang
I mean like mysql query select count( distinct id ) from tablename; Thanks Nick Chang於 2014年2月27日星期四UTC+8下午2時51分39秒寫道: Hello I want to analysis who read the how many books? When bookid is duplicate, I don't want to count. POST /bookdatas/_search { size: 0, facets

Re: How to count??

2014-02-27 Thread Nick Chang
Hello Binh Thanks. It's my query { query : { bool: { must: [ {query_string: { query: \(Google)b...@gmail.com\ }} ], must: [ {query_string: { query:

Include special Symbol

2014-02-26 Thread Nick Chang
Hello I have column include special symbol. Ex: user : (Google)a...@gmail.com I want to count. POST /datas/_search { facets: { terms: { terms: { field: user, size: 10 } } } } But, result is not right. term: gmail.com, count:

Re: Include special Symbol

2014-02-26 Thread Nick Chang
Hello Binh I used elasticsearch-river-mongo plugin. How to modify this index?? Thanks for your reply Binh Ly於 2014年2月26日星期三UTC+8下午11時03分29秒寫道: You'll likely need that field to be unanalyzed (i.e. tell ES not to cut it up in the index). One way is to predefine that field in your mapping

Re: Include special Symbol

2014-02-26 Thread Nick Chang
Hello I already solve this problem. Your suggest is right. Thanks Nick Binh Ly於 2014年2月26日星期三UTC+8下午11時03分29秒寫道: You'll likely need that field to be unanalyzed (i.e. tell ES not to cut it up in the index). One way is to predefine that field in your mapping as: user: { type: string,

Re: How to change name?

2014-02-12 Thread Nick Chang
-- David ;-) Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 11 févr. 2014 à 05:02, Nick Chang nick@kland.com.tw javascript: a écrit : Hello From Mongodb and MySQL. It's a different input data. So, I can't add ProductName to first documents. Thanks David Pilato於 2014年2月10日星期一

How to change name?

2014-02-10 Thread Nick Chang
Hello All I have two index. index1 : GET /_all/_search?pretty { facets: { terms: { terms: { field: prdId, size: 9, order: count, exclude: [] }, facet_filter: { fquery: { query: { filtered: {

Re: How to change name?

2014-02-10 Thread Nick Chang
* | *Technical Advocate* | *Elasticsearch.com* @dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr Le 10 février 2014 at 11:03:27, Nick Chang (nick@kland.com.twjavascript:) a écrit: Hello All I have two index. index1 : GET /_all/_search