you may want to read the following pages one is from pig architect http://developer.yahoo.com/blogs/hadoop/posts/2010/01/comparing_pig_latin_and_sql_fo/
http://www.larsgeorge.com/2009/10/hive-vs-pig.html also remember that these technologies are evolving On Thu, Oct 18, 2012 at 12:32 AM, yogesh dhari <[email protected]> wrote: > Hi All, > > I want to understand about the exceptional cases where Hive takes over Pig > and Pig takes over Hive. > > leaving the Fact Pig is best as an ETL Tool and Hive is best Data Warehouse. > > Please suggest me me the real use cases for both. > > Thanks &Regards > Yogesh Kumar > > > -- Nitin Pawar
