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日星期一UTC+8下午7時27分07秒寫道:
>
> Can't you add productName in your first documents (first index) in 
> addition or in place of productId?
>
>
> -- 
> *David Pilato* | *Technical Advocate* | *Elasticsearch.com*
> @dadoonet <https://twitter.com/dadoonet> | 
> @elasticsearchfr<https://twitter.com/elasticsearchfr>
>
>
> Le 10 février 2014 at 11:03:27, Nick Chang 
> ([email protected]<javascript:>) 
> a écrit:
>
> Hello All 
>
> I have two index.
>
> index1 : 
>  GET /_all/_search?pretty
> {
>   "facets": {
>     "terms": {
>       "terms": {
>         "field": "prdId",
>         "size": 90000,
>         "order": "count",
>
>         "exclude": []
>       },
>       "facet_filter": {
>         "fquery": {
>           "query": {
>             "filtered": {
>               "query": {
>                 "bool": {
>                   "should": [
>                     {
>                       "query_string": {
>                         "query": "!springhouse.qa AND !springhouse111 AND 
> !bd4book001 AND !shejiajia705 AND !springhouse.qa001 AND !kollect AND 
> !bd1test001"
>                       }
>                     }
>                   ]
>                 }
>               },
>               "filter": {
>                 "bool": {
>                   "must": [
>                     {
>                       "match_all": {}
>                     },
>                     {
>                       "terms": {
>                         "dlFrom": [
>                           2
>                         ]
>                       }
>                     },
>                     {
>                       "range": {
>                         "timestamp": {
>                           "from": "2013-11-01T00:00:00.000Z",
>                           "to": "2014-01-31T15:59:59.999Z"
>                         }
>                       }
>                     },
>                     {
>                       "bool": {
>                         "must": [
>                           {
>                             "match_all": {}
>                           }
>                         ]
>                       }
>                     }
>                   ]
>                 }
>               }
>             }
>           }
>         }
>       }
>     }
>   },
>   "size": 0
> }
>  
> output content :
>  {
>    "took": 18,
>    "timed_out": false,
>    "_shards": {
>       "total": 21,
>       "successful": 21,
>       "failed": 0
>    },
>    "hits": {
>       "total": 913222,
>       "max_score": 0,
>       "hits": []
>    },
>    "facets": {
>       "terms": {
>          "_type": "terms",
>          "missing": 0,
>          "total": 11635,
>          "other": 0,
>          "terms": [
>             {
>                "term": "0100202638",
>                "count": 338
>             },
>             {
>                "term": "0100203758",
>                "count": 330
>             },
>  
>
> index2 : 
>  POST /bookdatas/_search
> {
>     "query": {"match_all": {}}
> }
>  
> Output content : 
>  {
>    "took": 1,
>    "timed_out": false,
>    "_shards": {
>       "total": 5,
>       "successful": 5,
>       "failed": 0
>    },
>    "hits": {
>       "total": 26560,
>       "max_score": 1,
>       "hits": [
>          {
>             "_index": "bookdatas",
>             "_type": "bookdatas",
>             "_id": "JtJ1l7z4QU-dnQuHGuEcJA",
>             "_score": 1,
>             "_source": {
>                "productName": "TEST_Stuff",
>                "productId": "0100202638"
>             }
>          },
>          {
>             "_index": "bookdatas",
>             "_type": "bookdatas",
>             "_id": "J_WipyB0Tl-F44ChCSBgxg",
>             "_score": 1,
>             "_source": {
>                "productName": "book1",
>                "productId": "0100001733"
>             }
>          },
>  
>
> I want to change "term": "0100202638" to "productName": "TEST_Stuff".
>
> output content like to : 
>                 "term": "TEST_Stuff",
>                "count": 338
>  
> Do you have any suggest??
>
> Thanks
>  --
> You received this message because you are subscribed to the Google Groups 
> "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to [email protected] <javascript:>.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/elasticsearch/c9a3c3e4-09a9-4e49-8754-999952a948fa%40googlegroups.com
> .
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/c54b9656-17b9-4efd-8208-1df6eaca9eab%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to