른록노트

참고사이트https://www.elastic.co/guide/en/elasticsearch/reference/2.3/search-uri-request.html

Search APIseditMost search APIs are multi-index, multi-type, with the exception of the Explain API endpoints.RoutingeditWhen executing a search, it will be broadcast to all the index/indices shards (round robin between replicas). Which shards will be searched on can be controlled by providing the routing parameter. For example, when indexing tweets, the routing value can be the user name:POST /t..

Combining FilterseditThe previous two examples showed a single filter in use. In practice, you will probably need to filter on multiple values or fields. For example, how would you express this SQL in Elasticsearch?SELECT product FROM products WHERE (price = 20 OR productID = "XHDK-A-1293-#fJ3") AND (price != 30)In these situations, you will need to use a bool query inside the constant_score que..

POST test/type1/1/_update{ "script" : "ctx._source.new_field = 'value_of_new_field'"} 참고사이트https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-update.html

CAST함수는 형변환 함수이다. 형변환 함수(Cast Functions) MySQL 4.0.2부터 추가된 함수로 CAST()와 CONVERT() 함수는 한 타입의 값을 취해서 다른 타입의 값으로 사용된다. 구문은 아래와 같다. CAST(expression AS type) 참고사이트http://database.sarang.net/?inc=read&aid=19889&criteria=mysql&subcrit=&id=&limit=20&keyword=&page=2

[type과 index삭제하기] DeleteMapping APIhttps://www.elastic.co/guide/en/elasticsearch/reference/1.4/indices-delete-mapping.html[다시해본결과 안되네요..] [type안에 데이터 삭제하기] post [인덱스]/[타입명]/_delete_by_query{ "query": { "match_all": {} }} API사이트https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-delete-by-query.html

1. RDB ElasticSearch 비교RDBElasticSearchDatabaseIndexTableTypeRowDocumentColumnField 참고사이트http://sarc.io/index.php/aws/565-aws-elasticsearch-index-document

Field datatypeseditElasticsearch supports a number of different datatypes for the fields in a document:Core datatypeseditstringtext and keywordNumeric datatypeslong, integer, short, byte, double, float, half_float, scaled_floatDate datatypedateBoolean datatypebooleanBinary datatypebinaryRange datatypesinteger_range, float_range, long_range, double_range, date_rangeComplex datatypeseditArray data..