Convert a function into HIVE QL format?
Func(lead(e_date) OVER (PARTITION BY s_id, s_name ORDER BY e_date)-1,'2018-10-27') AS env_date
Error is here:
FAILED: ParseException line 1:1599 missing ) at 'OVER' near '(' in subquery source line 1:203 missing FROM at '(' near '(' in subquery source line 1:204 cannot recognize input near 'PARTITION' 'BY' 's_id' in subquery source.