Sort:  

It was the issue with hive that got me confused. I had to post it again when I didn't see the first post I posted.