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.