I have manually installed Cloudera's Hadoop and Cloudera's Hive RPM on RHEL. I have Sqooped data into Hive and can run normal HiveQL queries on the data fine. However, I cannot run LAG or LEAD on it.
This site suggests that it is possible: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-18.104.22.168/ds_Hive/language_manual/ptf-window.html
But this site says that Cloudera doesn't provide the version of Hive that comes with LAG, LEAD, etc.: http://www.justinjworkman.com/big-data/hive-0-11-0-on-cloudera/#building
Is there any documentation on how to run these types of functions in HiveQL?