3 ms·
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.
by daveFNbuck 7y 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.
- orange8 7y agoWhile 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 7y agoThat'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.
- orange8 7y agoWhat is your favourite HiveQl extension?