Elasticsearch SQL
elastic.co
Elasticsearch SQL
1–10 of 63 posts
Re: Elasticsearch SQL
#2As I remember it was introduced in 2018th: https://www.elastic.co/blog/an-introduction-to-elasticsearch..., although there was an open source extension for that…
Although I wasn’t very hard to implement it for a subset of queries like group by, etc. - primary problem was a good OSS sql parser. We used Presto back in 2016th for that
Re: Elasticsearch SQL
#3Seems like all the NoSQL databases eventually implement SQL, maybe we should use EventuallySQL instead NoSQL
Re: Elasticsearch SQL
#4I haven't used it but you could technically do this over spark in a bunch of round-about ways. But this would be more direct. more right out of the box.
Re: Elasticsearch SQL
#5Seems like all the NoSQL databases eventually implement SQL, maybe we should use EventuallySQL instead NoSQL
MongoDB took about 8 years to fully implement SQL features but they forced it into their god-awful syntax. At least Elastic stuck with SQL?
Re: Elasticsearch SQL
#6Seems like all the NoSQL databases eventually implement SQL, maybe we should use EventuallySQL instead NoSQL
A reminder that NoSQL stands for "not only SQL"
Re: Elasticsearch SQL
#7I’m conflicted on efforts like this. On the one hand SQL is for better or worse the Lingua Franca of database interfaces. On the other hand these half hearted, castrated implementations rarely work with tools geared towards working with true relational stores. The only real gain here is the surface level familiarity and of course the big fat check mark that the marketing team can put on the brochure to say “why, yes of course we support SQL!”
Re: Elasticsearch SQL
#8Seems like all the NoSQL databases eventually implement SQL, maybe we should use EventuallySQL instead NoSQL
A reminder that NoSQL stands for "not only SQL"
In a practical sense what it really means is "non-RDBMS." Even more specifically what it means is "any of the database technologies that were created or popularized in the period following RDBMS dominance in order to circumvent the performance limitations RDBMS technologies encountered at internet scale."
SQL just, unfortunately, was treated somewhat synonymously with RDBMS.
Re: Elasticsearch SQL
#9Seems like all the NoSQL databases eventually implement SQL, maybe we should use EventuallySQL instead NoSQL
A reminder that NoSQL stands for "not only SQL"
That’s a backronym.
> NoSQL (originally referring to "non-SQL" or "non-relational") […] NoSQL systems are also sometimes called Not only SQL […]
Re: Elasticsearch SQL
#10I look forward to a future where everything is SQL at this point. It seems we have spent a significant amount of effort avoiding it, but it time and time again is the best way to query your data.
I recently started using Steampipe and it has made my life about 30x better not having to deal with the AWS or Slack API. Essentially a tool to let you query their APIs using SQL, behind the scenes it boots up a Postgres database and essentially does ETL into it.
It doesn't do any updates to resources though, so back to the API again...