Hi Guys, I want to join 2 tables in hive on couple of columns and out them one condition is timestamp of one column is greater then the other one. In SQL I could have written in this way:
table_a a Join table_b b on a.user_id = b.user_id and a.title_id = b.title_id and a.timestamp > b.timestamp How to write last condition in Pig? *a.timestamp > b.timestamp* Thanks, Sonia
