You are looking at preliminary documentation for a future release. Not what you want? See the current release documentation.
This chapter describes the SQL syntax and data types supported in X-Pack. As a general rule, the syntax tries to adhere as much as possible to ANSI SQL to make the transition seamless.