August 29, 2017 at 3:42 pm
David.Poole - Tuesday, August 29, 2017 2:31 PMCertainly HIVE gives a sort of SQL called HQL which is based on the MySQL dialect.
Cassandra has CQL, Aerospike has AQL and Couchbase has NiQL.
Apache Spark goes for ANSI SQL 2011 but many of the SQL on distributed platforms do not support ROLLUP and CUBE operations.
Here's a tip. When a vendor of an amazing new data technology claims ANSI SQL compliance ask them which one. Remember without stating a year its a pretty meaningless feature. You'd hope for ANSI SQL 2008 or higher.I think the NOSQL movement started off as something akin to teenage rebellion and its now reached a certain maturity to find out that "by the time a man thinks his father may have been right he usually has a son who thinks he is wrong". I think some really good ideas have come out of the NOSQL movement and new ways of thinking. But equally I think that over a beer or two the NOSQL champions would concede that some of their complaints against SQL were because they didn't grasp the full complexity of what a traditional database has to do i.e. transactions, multi-concurrent locking, security etc.
I think both the SQL and the NOSQL worlds have a lot to teach each other but I would be wary of trying to build a "one true solution". To misquote Terry Prattchet the use of the NOSQL crowd is that they have not learned the limits of the possible
Regarding SQL reconsidered, I also think the NoSQL vendors hit a wall when it came time to acquire a customer base outside academia and open source programming community. You can teach a room full of data analysts and executives how to code SQL in a week, but teaching them MapReduce, JSON, and/or XQuery is something else. Those are the corporate customers willing to pay $$$,$$$. Geeks and hobbyists, while they were instrumental in developing the NoSQL movement early on, they just don't pay the bills.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply