# Stored procedure in Elastic search **URL:** \ **Category:** Elasticsearch\ **Created:** [January 27, 2019, 7:12am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882 "2019-01-27T07:12:12Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Raghunadhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raghunadhan/32/44239_2.png) [@Raghunadhan](https://discuss.elastic.co/u/Raghunadhan)\ **Post date:** [January 27, 2019, 7:12am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/1 "2019-01-27T07:12:12Z")
Dear All, I from relational database background. In MySQL we use to store datas in database based on conditions for requirements.We used to write script that is stored procedures .Using stored procedure we used to store datas and updated database.If we call that script using as single name it does all the opearations written in the script based on our input to scripts. Then help me out to write code in elasticsearch as that above stored script(stored procedure) that multiple operations. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [January 27, 2019, 7:32am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/2 "2019-01-27T07:32:58Z")
Elasticsearch does not support stored procedures, so you will need to implement any such logic externally. ---
**Author:** ![Raghunadhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raghunadhan/32/44239_2.png) [@Raghunadhan](https://discuss.elastic.co/u/Raghunadhan)\ **Post date:** [February 11, 2019, 6:59am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/3 "2019-02-11T06:59:46Z")
Dear Christian, What does it mean -\> Implement it externally.Then how to write in elasticserch equivalent to stored procedure ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [February 11, 2019, 7:05am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/4 "2019-02-11T07:05:26Z")
You can’t so need to handle this ap the application layer. ---
**Author:** ![Raghunadhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raghunadhan/32/44239_2.png) [@Raghunadhan](https://discuss.elastic.co/u/Raghunadhan)\ **Post date:** [February 11, 2019, 7:09am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/5 "2019-02-11T07:09:26Z")
Need to write that stored procedure in application layer(i.e front end developer) is this right?. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [February 11, 2019, 7:13am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/6 "2019-02-11T07:13:52Z")
You will need to implement the logic outside Elasticsearch. If you have a front end connect directly to Elasticsearch instead of via a server process I guess that is where you need to put it. I might however be easier to introduce an intermediate layer. ---
**Author:** ![Raghunadhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raghunadhan/32/44239_2.png) [@Raghunadhan](https://discuss.elastic.co/u/Raghunadhan)\ **Post date:** [February 11, 2019, 7:17am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/7 "2019-02-11T07:17:07Z")
Dear christian, IF you can please tell me an intermediate layer to write to write that stored procedure. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [February 11, 2019, 7:20am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/8 "2019-02-11T07:20:03Z")
Create a server process in the programming language of your choice and have the front end connect to this instead of directly to Elasticsearch. You can then implement more complex logic there and keep this out of your front end. ---
**Author:** ![Raghunadhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raghunadhan/32/44239_2.png) [@Raghunadhan](https://discuss.elastic.co/u/Raghunadhan)\ **Post date:** [February 11, 2019, 7:23am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/9 "2019-02-11T07:23:42Z")
From front end to server process then connect to elasticsearch .is this correct ---
**Author:** ![Raghunadhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raghunadhan/32/44239_2.png) [@Raghunadhan](https://discuss.elastic.co/u/Raghunadhan)\ **Post date:** [February 11, 2019, 8:25am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/10 "2019-02-11T08:25:13Z")
Dear Christian, ``` What is an Elasticsearch sql. ``` ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [February 11, 2019, 8:29am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/11 "2019-02-11T08:29:49Z")
Elasticsearch has [its own query language](https://www.elastic.co/guide/en/elasticsearch/reference/current/search.html) and supports [aggregations](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations.html). [This blog post](https://www.elastic.co/blog/a-practical-introduction-to-elasticsearch) provides a good introduction to Elasticsearch and the query language. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 11, 2019, 8:29am UTC](https://discuss.elastic.co/t/stored-procedure-in-elastic-search/165882/12 "2019-03-11T08:29:53Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.