4 ms·
I don't get the point of this. Do people not want to learn ES so bad that they will use something like this without understanding how to build an ES query obje
by johnnymonster 11y ago
I don't get the point of this. Do people not want to learn ES so bad that they will use something like this without understanding how to build an ES query object? All this plugin does is convert sql to an ES query...
- dragonwriter 11y agoNot having to learn a different query language for every product is exactly the point of SQL, and naturally also the point of pretty much every "SQL interface for X".
- threeseed 11y agoIf only this was the case. Except that every database has their own flavour of SQL with plenty of proprietary extensions. Not to mention each database will support a different subset of SQL.
- dragonwriter 11y ago> Except that every database has their own flavour of SQL with plenty of proprietary extensions. Not to mention each database will support a different subset of SQL. Its a lot easier to become familiar with a new SQL dialect than a new query language, especially since a lot of basic querying will be the same between different dialects.
- threeseed 11y agoLearning the basics is easy with any query language eg. MongoDB/ES JSON. It's when you start writing more advanced queries that you realise that SQLs "write once, run anywhere" premise is an illusion.
- hobs 11y agoDont know why anyone is downvoting this, this is absolutely true, and its even worse because the subset might work differently with the same keywords due to the underlying optimizer differences. This makes code you wrote in two different engines with the same syntax run vastly differently. Only if you are writing basic queries is the ansi sql promise realized.
- carterehsmith 11y ago>>Except that every database has their own flavour of SQL Sure, but simple queries, like the poster above provides as an example, have been standardized for like decades, and work the same across pretty much every credible RDBMS. https://news.ycombinator.com/item?id=10577996 https://news.ycombinator.com/item?id=10577996
- collyw 11y agoSure, but its relatively easy traslating from one dialect of SQL to another, as opposed to learning a whoe new query language.
- shtylman 11y agoPersonally I find SQL much easier to read. In a product where you might allow users to write queries it is a much more pleasant UX experience to write and read SQL than it would be to do so for ES queries. It isn't a problem to understand how to build an ES query object but an ES query object is pretty terrible to read IMO.
- elif 11y agoNo idea what motivated the authors, but from my perspective, basically: yes. I've been working with ES for years now. the query language changes about twice per year, things which used to be the only way to do things become deprecated. (see: https://www.elastic.co/guide/en/elasticsearch/reference/current/search-facets.html https://www.elastic.co/guide/en/elasticsearch/reference/curr... ) Even if you do understand 100% of the idiosyncrasies of elasticsearch, you still need to construct horrifically nested JSON to do meaningful queries... making it annoying to do in code, but mind wrenching to debug with curl.
- hughes 11y agoIt could certainly lower the barrier of entry into ES. I was almost scared off by the bafflingly huge query object I had to build for my first few (seemingly simple) queries.
- okigan 11y agoES query is enormously verbose (and JSON formatting adds another layer) -- so SQL is not great but it is much more succinct than ES alternative
- cploonker 11y agoAbsolutely agree. ES query is difficult to read.
- taf2 11y agoI think it's the size of the ES query object as well as complexity... even the ES documentation provides SQL examples to explain the ES query object... Here's a good example: https://www.elastic.co/guide/en/elasticsearch/guide/current/combining-filters.html https://www.elastic.co/guide/en/elasticsearch/guide/current/... SQL: SELECT document FROM products WHERE productID = "KDKE-B-9947-#kL5" OR (productID = "JODL-X-1937-#pV7" AND price=30) ES Query: { "query" : { "filtered" : { "filter" : { "bool" : { "should" : [ { "term" : {"productID" : "KDKE-B-9947-#kL5"}}, { "bool" : { "must" : [ { "term" : {"productID" : "JODL-X-1937-#pV7"}}, { "term" : {"price" : 30}} ] }} ] } } } } }