Hi, Though the documentation does not explicitly mention support for Windowing and Analytics function in Spark SQL, looks like it is not supported.
I tried running a query like Select Lead(<column name>, 1) over (Partition By <column name> order by <column name>) from <table name> and I got error saying that this feature is unsupported. I tried it in Databricks cloud and that supports Spark 1.4. Can anyone please confirm this ? Regards, Sourav