The correct link is https://docs.databricks.com/spark/latest/spark-sql/index.html .
This link does have the core syntax such as the BNF for the DDL and DML and SELECT. It does *not *have a reference for date / string / numeric functions: is there any such reference at this point? It is not sufficient to peruse the DSL list of functions since the usage is different (and sometimes the names as well) than from the DSL. thanks stephenb 2017-08-10 14:49 GMT-07:00 Jules Damji <dmat...@comcast.net>: > I refer to docs.databricks.com/Spark/latest/Spark-sql/index.html. > > Cheers > Jules > > Sent from my iPhone > Pardon the dumb thumb typos :) > > > On Aug 10, 2017, at 1:46 PM, Stephen Boesch <java...@gmail.com> wrote: > > > > > > While the DataFrame/DataSets are useful in many circumstances they are > cumbersome for many types of complex sql queries. > > > > Is there an up to date *SQL* reference - i.e. not DataFrame DSL > operations - for version 2.2? > > > > An example of what is not clear: what constructs are supported within > > > > select count( predicate) from some_table > > > > when using spark sql. > > > > But in general the reference guide and programming guide for SQL seems > to be difficult to locate - seemingly in favor of the DataFrame/DataSets. > >