On Tue, Sep 15, 2009 at 12:23 PM, Ted Dunning <[email protected]> wrote: > I don't need to be amazed. I am a strong proponent of map-reduce. People > forget, but I bought the beer at the first Hadoop summit at Gordon Biersch. > > I just don't think that selling Hive or Pig as SQL is fair to the buyer or > the seller. They aren't the same and have very different virtues. > > On Tue, Sep 15, 2009 at 8:34 AM, Edward Capriolo <[email protected]>wrote: > >> Hive is not 100% SQL, but I would say join the Hive user list and be >> amazed. New types of joins, theta-join, etc have been added by user >> request. Most of the time if you can't do something you would expect >> to do in SQL there is a work around. >> >> The flip side is true as well, Hive has specific support that other >> databases don't :) >> > > > > -- > Ted Dunning, CTO > DeepDyve >
Ted, I meant that I am more amazed by it, not that you should be amazed by it :) There have been several tickets opened up like "Let Hive do theta Join" and then sometimes, with in days, hive trunk supports it. That is pretty impressive to me. As for >>I just don't think that selling Hive or Pig as SQL is fair to the buyer or >>the seller. They aren't the same and have very different virtues. I agree. I think I qualified that as my opinion. However, I will say that I believe I have received some unsolicited from Aster. Likewise, I notice Aster will reply to blogs about hadoop and plug away, without really referencing the topic of the blog in any specific way. So, I would argue the precedent is set. Maybe, it is just my pet-peeve. The philosophical "What is SQL?" is hard to answer. Being different SQL standards like http://en.wikipedia.org/wiki/SQL-92 or SQL-89 may only be partially supported by a particular vendor. Every implementation adds/subtracts features. I often describe Hive query language in this way: "If you know SQL I can teach you Hive-QL rather quickly."
