Elastic just released their new pipeline query language called
ES|QL . This is a conscious attempt to consolidate the language zoo in the
Elastic ecosystem
(queryDSL ,
EQL ,
KQL ,
SQL ,
Painless ,
Canvas/Timelion ).
Elastic said that they worked on this effort for over a year. The
documentation is still sparse, but we still tried to read between
the lines to understand what this new pipeline language has to offer.
eyJ2ZXJzaW9uIjoiMSIsImVuY29kaW5nIjoiYnN0cmluZyIsImNvbXByZXNzZWQiOnRydWUsImVuY29kZWQiOiJ4nO1aW3PayFx1MDAxMn73r3Cxr4ky98u+2WBcdTAwMWLbiSGBdVx1MDAxY5/acslCgIyQiCQwTjb//bRkXHUwMDFiXHRxMWAgbDZylVx1MDAwYvXMqEc9/c3X3aPve/v7heihZ1x1MDAxN/7cL9hDy3SdRmDeXHUwMDE33sTygVx1MDAxZISO70FcdTAwMTNJ7kO/XHUwMDFmWEnPdlx1MDAxNPXCP9+9M3s9I1x1MDAxZGVYfvdxpO3aXduLQuj7P7jf3/+e/M/oiuxhlPRNpKkmTfPCXHUwMDBi30uUaqU5XCKEsVFcdTAwMDcnLIGiyG5Aa9N0QzttiUVcdTAwMDXr+KRuuWU0aJ66XHUwMDE3XHUwMDAzt2Kx/nE9Vdp0XFy3XHUwMDE2PbiPb2Ra7X5gp61hXHUwMDE0+Fx1MDAxZPuz04jaz1x1MDAwNsjIR+NcdTAwMWFm2IZcdIyaXHUwMDAzv99qe3ZcdTAwMTi/Olx1MDAxYUn9nmk50Vx1MDAwM8gwSqWm10pcdTAwMWWSSoaxKpXexyOIQDnlRd/1g1j5XHUwMDFm2I7/Uu23ptVpwVx1MDAxNLzGqE9cdTAwMTSYXtgzXHUwMDAzWI603/3Ta2GiXGastVZYKM04xel7tm2n1Y6SPjzVbyfGxlx1MDAxNFx1MDAwYiQ5yqxFrLV32khW/O/UxIHZtU/jIV7fdbNG8lx1MDAxYU9GXHUwMDFha7iNXHUwMDFijjLOkz6q32uYj0uNhSZcdTAwMTJRmLFcImLU7jpeJ/8417c6U7yj6XtRzflm55YjXHUwMDE2XHUwMDFmm13HTdZpJE48XHUwMDE1XGZ5VCuMyVx1MDAwZVxcp+Ulblx1MDAwNpO1gzFnjlx1MDAxY8DEqEPk99JWXHUwMDBitJiOZ1x1MDAwN5Nm8Vx1MDAwM6fleKZbn6JcdTAwMTFezy6PlsTIrMmtXHUwMDE52nEryJVKhD/eLIc5jFhe+lxmOszBylJQpVx1MDAxNkbdgV+6e7Bub0rlsONdXHUwMDBlr6tHXHUwMDFl/2vnUccyXHUwMDE2fVx0dU3aoFS+XHUwMDAydcKQMeik1ERcdTAwMGIlU83zQKc0YohKlq7Er4+5f7Zccrl/toQ4jPPSZ8RcdTAwMTHwXGYtuEx9/yXAXHJvmpVuUK25Z6dnJ5Wreuns5sHbfcCJLdJcdTAwMWNFXHUwMDA2je1KlVx1MDAxNkwxmmJoLuJgY1Tw91x1MDAxZlx1MDAwMtzH99tGXFxW4yYhx1x1MDAxNclLnyHHJIJ4hpHUSi9BLrgptVx1MDAwNt7VtVuvfzk8872K/Ov8fOchRzUxXHUwMDE0QVx1MDAxNOe4XHUwMDBlXHUwMDBiXHUwMDAyUSBmSGQxsPZQU1x1MDAxYVx1MDAxNHNNKSGSU41Sr1x1MDAxZWGQTkBQaEklxPybxuBY41x1MDAwNFxupaaYyVeikKgx6Vx1MDAxY1x1MDAxMH7t28FDqbZ1KE7qXVxikIRPXHUwMDA15CNSbFLu4MrFfcnpXGbDoFY+Lt5XrzMv9oTa5FHj/MCEQVx1MDAwNSUq761cdTAwMDQjQyDOxlx1MDAwMqeRl3GDTounODVYzsEnMZJ3ectusIY51+X/UELZWqxcdTAwMTn6oVx1MDAwZlx09XTkp94yXHUwMDFk+euBx3Oeh1x0ZN1Eion8IDYp53lpmjVgyCUpWyhXX1x1MDAwZYqKUIVI1kFcdTAwMTeFYs93slx1MDAxNYn4Sn/tp26Q3Ix+//1mau+3445cdTAwMTZfqYulg/dyXHUwMDBmKbhmXHUwMDE4XHUwMDE1/W7XieCtqvGMJkxcdTAwMWaZQXToeFxyx2vl22yvMaMlXHUwMDE5dVx1MDAxMFx1MDAwNP592zYn1lx1MDAxOcbl21biUKZnh62YMy6RWIJDrft+0VKVO8SPdPfzYfeudfx+5zlcdTAwMTQjWHhcdTAwMDGeiFx1MDAxOcRcZpiLVHfyXHUwMDAwzVxygSXO7k3rZlJcdTAwMGUzUFRLgoWckT5OXHUwMDEyKYXwhinyU5NHLVx1MDAwNU2tuWlcdTAwMTY92n4se7R0MDuXO6lt0Wt57jlhr1x1MDAxMn267pBvXHUwMDE1dbFcYndiKVxyjuJcdTAwMTgrz51EXHUwMDE4XGJSXG5Gp3CnUFx1MDAwNlZcdTAwMTRcIrRpXHUwMDFlXHUwMDA1bEykpGNcdTAwMDN/M+jLXGbKXHUwMDE1JVpcYqGy3va0nVIp89JRsVx1MDAxYkJlMMz6+Vx1MDAxMzYurFdKKNfKn1N8Lb4yXvbLkiiXM484sFx1MDAwNMBSwtHi1Valq93B1zNyUVx1MDAxYVx1MDAwNiX7pIPOW+Xdr7ZCUmdQKjiVwKdaZCpcdTAwMWPJLoWYoaTAYFx1MDAwN1xuQWRmy187lVJDSJhcdTAwMDCjPJdQzKFSSJWFQlx1MDAxY22cTF9AMoH4I53Cpun0fPt0er4uOp3OlCkkRcZh85DUVDPYM8nix45XzauK2S5eXt1/lYHfZe/PO3rdx46v4LdcdTAwMTmIJNRQXHUwMDFjgkQhVVx1MDAxY6nlwlx1MDAwNmhEYFxuXHUwMDAyiJxcdTAwMGLIVVxif5S7Y8j4lVx1MDAxOFx1MDAwZp7TXGaeXHUwMDE5SKpph5Fac1wiXHT6ySWi2E1WyktX46pcdTAwMDU5cFx1MDAxOTbbXGbTv522rPE1WtBJpl+JVyGymVxyYqJcdMdULFx1MDAwZeJq66J0eV1cdTAwMWOSPmuV7mr9ty3ywdp5Xlx1MDAwNZBcdTAwMWFcdTAwMDBcdTAwMDZIszhcdTAwMDfjXG49XHUwMDA2Y4aRXHUwMDAxXHUwMDExXHUwMDA2iPlcdTAwMGIwXlx1MDAwM69yXHUwMDFh86pcdTAwMTY8qTgvwqtcdTAwMDQ4lWKcPVx1MDAxONp+klxuwSfW22PV2vZZtbYtVlV85olcdTAwMGLmYGai9OKHnGUzOij2qWX1blx1MDAxYlx1MDAxZtmJqLTfftQ7T6pSXHUwMDE5iFx1MDAxMCw5p1x1MDAxM6TKKDa0ppRCkLtBUoVMi6tcdTAwMTlJPbRcdTAwMTGMxtpGpCpcdTAwMTiXXHUwMDA0QoGfiEVcdTAwMTVXrFYqXHUwMDE4/fKcOrmqiTxd0LWR6sxcdTAwMTJcdTAwMDWmSCCl1Fx1MDAxMiXfIa87d2bXPGhcckW9XHUwMDExfji58b+1d55UNTFiS1x1MDAwM1x1MDAxYZTCWUQkKCbCIFx1MDAxNI0nj2s/O0XaYFJrXHUwMDA2oS6Oq8tTvl+YUvJVSFx1MDAxMMLXXtpaMjCWXHUwMDE4Z06KNk2oVWBBN570lll1Uu/r67+HzeZcdTAwMTeOjztccvNrp1o+6J+5qExcdTAwMTep/0I6ZPCJY34qRD6FenYwxWHfYONl4TTzgvidMDKWlv0u/b5Y+qVcdTAwMWEx2Fx1MDAxOaTIOttzwYHNKTgwSjSimVwi7dpqvytDcb3sNcXb4ivjZ5PstSxJ72jxXHUwMDE3vG3myiuuXHUwMDE44XSJL/9Is1x1MDAxZDjBhzD6cncxXGKOXHUwMDFhxc9XtrvzfEpcdTAwMTVk/lxuaSZhpbVcdTAwMTQ8x6hcZlx1MDAxYiDb4KdIXHUwMDA0x1x1MDAxYiHXmDCIzCGMSstcdTAwMDLz0lOFXHUwMDE5kCn5qdmpVlx1MDAxOKXHXHUwMDA3mybToulccszwXd3pXHUwMDAyX/netjl1pvrXU2s1uKn4g083Z43Lh9My+lx1MDAxNFxcRpgs+lnS+KF7Qq1cdTAwMTJcdTAwMTmYsXHOfXY3yPPYrO+84y/vJFx1MDAxZifl39z68rEq4kKKuOQ6ZY9VfOZcdTAwMDFcdTAwMWLFlGKNN8CtilxivdppzFq5ddLX4ivjZf9cdTAwMWVm3XuaW8Hs9WpcdTAwMTFYXHUwMDFiWlx1MDAxZlFcXFx1MDAxODj2/eFcdTAwMTSfbyZXYe9cdPWxz9uxZb//2Pvxf9J+rVx1MDAxNCJ9ES | QL queryDSL EQL KQL SQL Painless Canvas/Timelion