← Back to context

Comment by daveFNbuck

7 years ago

Hive queries are written in HiveQL, not SQL. I used to write a lot of Hive and Impala queries, and going back to plain SQL is disappointing.

3 comments

daveFNbuck

Reply
orange8  7 years ago

While based on SQL, HiveQL does not strictly follow the full SQL-92 standard, just like all the other SQL dialects out there. hiveQL is SQL.

  • daveFNbuck  7 years ago

    That's a fair argument, but from personal experience HiveQL has some pretty major features added on that make it "have such power and support so many use cases" in a way that other common variants like the one used by MySQL doesn't.

    A lot of HiveQL's power comes from extending the language, not from the use of a small set of timeless features.