how can i filter out a whole set of batch records in hive?

You can try using correlated subquery –

select id,Description from tablename t
where not exits 
    (select 1 from tablename t1 where t.id=t1.id and description='Item removed from batch')

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top