elasticsql - convert sql to elasticsearch DSL in golang(go)

We have collection of more than 1 Million open source products ranging from Enterprise product to small libraries in all platforms. We aggregate information from all open source repositories. Search and find the best for your needs. Check out projects section.

elasticsql - convert sql to elasticsearch DSL in golang(go)

To use this tool, you need to understand the term and match phrase of elasticsearch.Setting a field to analyzed or not analyzed will get different result.

https://github.com/cch123/elasticsql

Tags	elasticsearch sql dsl elastic search sql-to-elasticsearch query-library
Implementation	Go
License	MIT
Platform	Windows MacOS Linux

Related Projects

ElasticHD - Elasticsearch 可视化DashBoard, 支持Es监控、实时搜索，Index template快捷替换修改，索引列表信息查看， SQL converts to DSL等

Precompiled binaries for supported operating systems are available.ElasticHD does not require any software. It works in your web browser, allowing you to manage and monitor your ElasticSearch clusters from anywhere at any time. Built on responsive CSS design, ElasticHD adjusts itself to any screen size on any device.

elasticsearch elastichd elastic elasticdashboard sql sql-converts elastic-sql-dsl es esdashboard elasticsearchdashboard elasticsearch-dashboard elasticsearch-tools elasticsearch-management

elastic-builder - A Node.js implementation of the elasticsearch Query DSL :construction_worker:

Javascript

A Node.js implementation of the Elasticsearch DSL for use with the official elasticsearch javascript client with builder syntax. Check out the API reference documentation.

elasticsearch query-builder nodejs elasticsearch-query-dsl elastic-builder querying queries query elastic search elasticjs ejs dsl

Flummi - Elastic Search HTTP REST Client

Java

Flummi is a client library for Elastic Search. It has been successfully tested with Elastic Search versions 2.3, 2.4 and 5.1. It provides a comprehensive Java query DSL API and communicates with the Elastic Search Cluster via HTTP/JSON. Flummi uses HTTP and JSON for communication with Elastic Search. Its only dependencies are Gson and AsyncHttpClient, so it is good for you if you don't want to have your application depend on the full ElasticSearch JAR.

elasticsearch-client elasticsearch-library

elastic.js - A JavaScript implementation of the elasticsearch Query DSL

Javascript

Javascript API for ElasticSearch DSL

elasticsearch search elasticjs elastic elastic-search es ejs elasticsearch-client elasticsearch-library

zombodb - Making Postgres and Elasticsearch work together like it's 2018

ZomboDB brings powerful text-search and analytics features to Postgres by using Elasticsearch as an index type. Its comprehensive query language and SQL functions enable new and creative ways to query your relational data. From a technical perspective, ZomboDB is a 100% native Postgres extension that implements Postgres' Index Access Method API. As a native Postgres index type, ZomboDB allows you to CREATE INDEX ... USING zombodb on your existing Postgres tables. At that point, ZomboDB takes over and fully manages the remote Elasticsearch index and guarantees transactionally-correct text-search query results.

postgres elasticsearch postgresql text-search sql

bodybuilder - An elasticsearch query body builder :muscle:

Javascript

An elasticsearch query body builder. Easily build complex queries for elasticsearch with a simple, predictable api. Check out the API reference documentation.

elasticsearch querydsl builder bodybuilder querying queries query elastic search dsl elasticsearch-tools

elasticsearch-sql - Use SQL to query Elasticsearch

Java

Query elasticsearch using SQL

sql elasticsearch

Quicksql - Simpler, Safer, Faster Unified SQL Analytics Engine for Multi-Datasources

Java

Quicksql is a SQL query product which can be used for specific datastore queries or multiple datastores correlated queries. It supports relational databases, non-relational databases and even datastore which does not support SQL (such as Elasticsearch, Druid) . In addition, a SQL query can join or union data from multiple datastores in Quicksql. For example, you can perform unified SQL query on one situation that a part of data stored on Elasticsearch, but the other part of data stored on Hive. The most important is that QSQL is not dependent on any intermediate compute engine, users only need to focus on data and unified SQL grammar to finished statistics and analysis. An architecture diagram helps you access Quicksql more easily.

hive spark sql flink

elasticsearch-dsl-py - High level Python client for Elasticsearch

Python

Elasticsearch DSL is a high-level library whose aim is to help with writing and running queries against Elasticsearch. It is built on top of the official low-level client (elasticsearch-py).It provides a more convenient and idiomatic way to write and manipulate queries. It stays close to the Elasticsearch JSON DSL, mirroring its terminology and structure. It exposes the whole range of the DSL from Python either directly using defined classes or a queryset-like expressions.

elasticsearch search

kibi - Kibi is a friendly - kept in sync - Kibana fork which add support for joins across indexes and external sources, tabbed navigation interface and more

Javascript

Kibi extends Kibana 5.5.2 with data intelligence features; the core feature of Kibi is the capability to join and filter data from multiple Elasticsearch indexes and from SQL/NOSQL data sources ("external queries").In addition, Kibi provides UI features and visualizations like dashboard groups, tabs, cross entity relational navigation buttons, an enhanced search results table, analytical aggregators, HTML templates on query results, and much more.

kibana elasticsearch relational-browsing logstash analytics visualizations dashboards dashboarding data-intelligence relational sql sparql kibana-alternative

elasticsearch-py - Official Python low-level client for Elasticsearch.

Python

Official low-level client for Elasticsearch. Its goal is to provide common ground for all Elasticsearch-related code in Python; because of this it tries to be opinion-free and very extendable.For a more high level client library with more limited scope, have a look at elasticsearch-dsl - a more pythonic library sitting on top of elasticsearch-py.

elasticsearch search client

phpMyFAQ - phpMyFAQ - Open Source FAQ system for PHP and MySQL, PostgreSQL and other databases

phpMyFAQ is a multilingual, completely database-driven FAQ-system. It supports various databases to store all data, PHP 5.6+ is needed in order to access this data. phpMyFAQ also offers a multi-language Content Management System with a WYSIWYG editor and an Image Manager, real time search support with Elasticsearch, flexible multi-user support with user and group based permissions on categories and records, a wiki-like revision feature, a news system, user-tracking, 40+ supported languages, enhanced automatic content negotiation, HTML5/CSS3 based responsive templates, PDF-support, a backup-system, a dynamic sitemap, related FAQs, tagging, RSS feeds, built-in spam protection systems, OpenLDAP and Microsoft Active Directory support, and an easy to use installation script. phpMyFAQ is only supported on PHP 5.6.0 and up, you need a database as well. Supported databases are MySQL, Percona Server, PostgreSQL, Microsoft SQL Server, SQLite3 and MariaDB. If you want to use Elasticsearch as main search engine, you need Elasticsearch 2.x as well. Check our detailed requirements on phpmyfaq.de for more information.

faq phpmyfaq mysql database postgresql sqlite mssql elasticsearch docker docker-compose

bloodhound - Haskell Elasticsearch client and query DSL

Haskell

Search doesn't have to be hard. Let the dog do it."ES is a nightmare but Bloodhound at least makes it tolerable." - Same user, later opinion.

elasticsearch-client elasticsearch-library

elasticsearch-gui - An angularJS client for elasticsearch as a plugin

Javascript

Welcome to the Gui plugin for elasticsearch. Using this plugin you can explore your elasticsearch index. This plugin gives you a few different ways to start exploring. There is a way to search the repository in a way you would do it on a web site. You can enter keywords, do advanced search, use facets. Another way to explore the index is focussed on learning the structure of the actual executed query. You can enter a number of items to include in the query. You can enter fields, facets, highlighting, limit the indexes, limit the types. Finally there is a way to show some of the data in a graph. Since we use mainly JavaScript, it is possible to connect to a remote elasticsearch instance. To facilitate this, elasticsearch returns a specific html header.

elasticsearch plugin gui

FiltrES.js - A simple, safe, ElasticSearch Query compiler

Javascript

A simple, safe, ElasticSearch query engine, allowing you or your end-users to enter arbitrary expressions without p0wning you or learning the ElasticSearch Query language. There are many cases where you want a user to be able enter an arbitrary expression through a user interface or simply want to avoid ElasticSearch's powerful, but complicated query language.

elasticsearch query dsl

elastic4s - Elasticsearch Scala Client - Non Blocking, Type Safe, HTTP, TCP

Scala

Elastic4s is a concise, idiomatic, reactive, type safe Scala client for Elasticsearch. The client can be used over both HTTP and TCP by choosing either of the elastic4s-http or elastic4s-tcp submodules. The official Elasticsearch Java client can of course be used in Scala, but due to Java's syntax it is more verbose and it naturally doesn't support classes in the core Scala core library nor Scala idioms.Elastic4s's DSL allows you to construct your requests programatically, with syntactic and semantic errors manifested at compile time, and uses standard Scala futures to enable you to easily integrate into an asynchronous workflow. The aim of the DSL is that requests are written in a builder-like way, while staying broadly similar to the Java API or Rest API. Each request is an immutable object, so you can create requests and safely reuse them, or further copy them for derived requests. Because each request is strongly typed your IDE or editor can use the type information to show you what operations are available for any request type.

elasticsearch reactive-streams elasticsearch-client elasticsearch-library

elasticsearch-operator - manages elasticsearch clusters

The ElasticSearch operator is designed to manage one or more elastic search clusters. Included in the project (initially) is the ability to create the Elastic cluster, deploy the data nodes across zones in your Kubernetes cluster, and snapshot indexes to AWS S3. The operator was built and tested on a 1.7.X Kubernetes cluster and is the minimum version required due to the operators use of Custom Resource Definitions.

kubernetes operator elasticsearch

elasticsearch-head - A web front end for an elastic search cluster

Javascript

A web front end for an elastic search cluster

elasticsearch-monitoring elasticsearch-management elasticsearch-tools

elasticsearch-learning-to-rank - Plugin to integrate Learning to Rank (aka machine learning for better relevance) with Elasticsearch

Java

Rank Elasticsearch results using tree based (LambdaMART, Random Forest, MART) and linear models. Models are trained using the scores of Elasicsearch queries as features. You train offline using tooling such as with xgboost or ranklib. You then POST your model to a to Elasticsearch in a specific text format (the custom "ranklib" language, documented here). You apply a model using this plugin's ltr query. See blog post and the full demo (training and searching).Models are stored using an Elasticsearch script plugin. Tree-based models can be large. So we recommend increasing the script.max_size_in_bytes setting. Don't worry, just because tree-based models are verbose, doesn't nescesarilly imply they'll be slow.

elasticsearch relevant-search machine-learning search-relevance