3 ms·
i would be surprised if they were supporting sql as query language. do you mean by using spark sql?
by ousta 8y ago
i would be surprised if they were supporting sql as query language. do you mean by using spark sql?
- vquemener 8y agoActually, they really do support SQL as a query language : https://www.elastic.co/en/blog/an-introduction-to-elasticsearch-sql-with-practical-examples-part-1 https://www.elastic.co/en/blog/an-introduction-to-elasticsea...
- ousta 8y agoyeah a "subset of SQL" and on the page you gave me 0 example of a JOIN. so no JOIN no SQL sorry
- AtlasBarfed 8y ago"We support SQL on our distributed data platform" has to be the new big lie of distributed systems salespeople. I'm not saying that computing joins, aggegates, sorts, etc can't be done in a distributed fashion, it just takes time, a lot of network reliability/reattempts, and understanding of the approximate nature of results if there are ongoing "eventually consistent" updates rolling through the cluster(s).
- ousta 8y agowell you cannot have a search engine query time + a SQL layer at least not at DB speeds
- lnx01 8y agoThere's even a JDBC driver on the commercial tier