News for hackers. Stuff that matters.

A comment on We Can Do Better Than SQL. Parent comment

Re:We Can Do Better Than SQL by daveFNbuck on Friday May 10, 2019 @01:34AM (#19875326)
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.
[ Parent | on HN ]
Re:We Can Do Better Than SQL by orange8 on Friday May 10, 2019 @01:39AM (#19875352)
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.
[ Parent | on HN ]
Re:We Can Do Better Than SQL by daveFNbuck on Friday May 10, 2019 @02:06AM (#19875448)
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.

[ Parent | on HN ]
Re:We Can Do Better Than SQL by orange8 on Friday May 10, 2019 @03:26AM (#19875803)
What is your favourite HiveQl extension?
[ Parent | on HN ]