I am new to Hive. I have several SQL from RDBMS database that I need to convert to hive. What's the best reference for HIVEQL? For now I am trying to figure out how to do this in hive:
Select distinct A_ID, First_Value(path IGNORE NULLS) over(PARTITION BY A_ID ORDER BY t_timestamp) From WEB_DATA Any help would be appreciated.