Its true that Hive is good for AD-HOC queries - PIG is good for ETL - Agree.